Pivot Charting Grand Total as Series

[Lim]

Hi

How can I get excel to chart the 'Grand Total' of the Row
as a series on the same chart of the data series?

Thanks in advance.

 

[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