Pivot Chart / Table

[Bilbo Baggins]

Hi all
I have a pivot table showing various figures with a grand
total column at the right hand side, automatically
generated by selecting grand totals for columns under
pivot table options.
The various figures are displayed on a pivot chart as
lines over time but i want to include the grand total
column on the same chart as well, but cannot find any
options for doing this. It does not appear as an option
anywhere.
If anyone can help it would be much appreicated.
Bilbo

 

[Debra Dalgleish]

I don't know of any way to include the totals in a PivotChart. You could
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