pivot graph
 

How do you get the grand total column from the pivot table graphed on
the pivot graph???


--
cutsygurl
------------------------------------------------------------------------
cutsygurl's Profile: http://www.excelforum.com/member.php...o&userid=15041
View this thread: http://www.excelforum.com/showthread...hreadid=475577

Hello Cutsygurl,
I do not know a way to include the grand total as a cloumn in a PivotChart.
You could create a normal chart, based on the pivot table, and include your
grand total
in this normal chart.
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. Take
care not to select a cell which contains a Pivot Table button, or the chart
will become a Pivot Chart.

One of the MVP's may have a better solution.
Cheers,
Annie




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




"cutsygurl" wrote:


How do you get the grand total column from the pivot table graphed on
the pivot graph???


--
cutsygurl
------------------------------------------------------------------------
cutsygurl's Profile: http://www.excelforum.com/member.php...o&userid=15041
View this thread: http://www.excelforum.com/showthread...hreadid=475577