Dear All

I am createing the Chart from Pivot Table that I use data from Detail Tab sheet to Pivot Table and i need to create Graph from pivot table but it does not work.

Because of I need to show X axis is month and Y axis is QTY, then i attempt to create the the another table at B14:F16 and then use this data to do the graph.

And how can writ formula for get Grand Total from Pivot Table to another Table.

i use pivot table because i have to select Brand, Brand Type and need to get Grand total to do Graph.

Could you please help me to this one? You may advice and change some format if it is better.

Best regards.Pivot Chart.xlsx