I don't know of any way to include the grand total in a PivotChart. You
can 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
> Pretty basic question. I have a pivot table (chart) that is charting a
> set of issue into four priorities (P1, P2, P3, P4) over time. We are
[quoted text clipped - 7 lines]
> line (sum of all prioritys over time) to be graphed as well and I
> cannot do this.

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