Pivot Charts
 

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

Pivot Charts
 

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


James L wrote:
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?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html