Showing Grand Totals in Pivot Charts

[Nikki]

I have created a pivot table which contains a Grand Total
column. This grand total column displays the sum of the
counts for all the columns correctly. This number does not
seem to be available to me when I generate a pivot chart.
How can I make the grand total from the pivot table
display in the pivot chart?

 

[Jon Peltier]

Hi Nikki -

Unfortunately pivot charts aren't as flexible as regular charts. But you
can make a regular chart from pivot table data. Select a blank cell that
isn't near the pivot table. In step 2, click on the Series tab, then one
by one add the series and the data range for each series. You can add a
series for the grand totals this way.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Nikki]

Thank you very much...

-----Original Message-----
Hi Nikki -

Unfortunately pivot charts aren't as flexible as regular charts. But you
can make a regular chart from pivot table data. Select a blank cell that
isn't near the pivot table. In step 2, click on the Series tab, then one
by one add the series and the data range for each series. You can add a
series for the grand totals this way.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


.