View Single Post
  #2  
Old March 11th, 2004, 02:34 AM
Debra Dalgleish
external usenet poster
 
Posts: n/a
Default Pivot Charting Grand Total as Series

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

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


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