pivot graph

C

cutsygurl

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

Annie

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.
 
Top