Charting Grand Totals using the Pivot Chart

[gregpferdner]

I am trying to chart the grand total for 3 series in my pivot chart. I am able to chart the 3 series correctly but can't figure out how to add the grand total for my 4th series.

I do not want to create a chart pointing to the pivot or copy paste the pivot to values and chart off that. I need the pivot chart to already capture the grand total. (i'm just using a simple line chart).

Any help you could offer would be greatly appreciated!!!!

Thanks, Greg