Pivot Charts

[James L]

Hello

I have created a pivot chart from a pivot table. The chart is showing the data but does not show the Grand Total at the end of the chart. If draw a 'normal' chart it will show the Grand Total if you select it. Is it possible to do it on the Pivot Table

Thanks in advance
James

 

[Debra Dalgleish]

I don't know of any way to include the grand total in a PivotChart. You
can create a normal chart, based on the pivot table, and include the
totals in that.

On Jon Peltier's site, there are instructions for creating a normal
chart from pivot data:

http://www.peltiertech.com/Excel/Pivots/pivotcharts.htm