I don't know of a way to include the grand total 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

Kristin wrote:
I want my grand totals to show in my pivotchart, how can I get this
accomplished?

Thank you


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