Pivot chart total series

When I use the pivot chart how can I display the grand totals (which are calculated by the table) as a series? I'm talking about the row and column totals that are calculated when you have the correct box selected in pivot table options.

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.

To create a normal chart from a Pivot Table:

1. Select an empty cell away from the Pivot Table.
2. Click the Chart Wizard button.
3. Click Finish, to create an empty chart.
4. Select cells in the Pivot Table, and drag them to the blank chart.

Note: If you select a cell which contains a Pivot Table button, the
chart will become a Pivot Chart.

To avoid this, you can build the chart from the data and either the
series or category axis labels. Then choose ChartSource Data. On the
Series tab, select a series. Click on a worksheet cell to add the series
name or Category axis label.


Jay wrote:
When I use the pivot chart how can I display the grand totals (which are calculated by the table) as a series? I'm talking about the row and column totals that are calculated when you have the correct box selected in pivot table options.


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