PivotChart, How to show Grand Totals in the chart?

[Kristin]

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

Thank you

[Debra Dalgleish]

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