Display data from the Grand Total column of a Pivot Table on a Stacked Pivot Chart

I did it with GETPIVOTDATA function, in Excel 2007. Quite easy, actually.
Start the same – create the same structure as the original pivot without any filters, (Copy>Paste Values) but then delete the Values area and habits this measure with the GETPIVOTDATA function. The syntax I used was:
=IFERROR(GETPIVOTDATA(“Amount”,$A$8,”Date of Sale”,1 ,”Product”,”Product A”),0)

$A$8 is the information used to determine which PivotTable report contains the data that you want to retrieve.
In our case, point it to pivot table cell where it says “Sum of Amount”.
1 indicate the row number, Jan, in our case. You probably want to change it to 2, 3 etc. every time you drag the function down.
The last argument, “Product A”, also needs changing when dragging across columns, I pointed it to my GETPIVOTDATA table header.

Then create Grand totals as you like, and create chart.
Last thing- regarding changes in Base data: You need to pay attention that row data and columns header remain static even if Base table expand with new products and new dates. to partially solve it I decided to create the structure with 12 months rows (not only Jan-Apr but Jan-Dec). And to I keep in mind that when new product (Product F) will be add to Base data, then I’ll have to insert a new column for it manually. If new products add often, I’ll search the web for code to do that, or consider some kind of multivariable Retrieving using array formula or whatever.