Forum Discussion
Pivot table graphing wrong data
I am using a pivot table to show how many surgeries different hospitals do per month over the span of a year. For one of the hospitals though it is graphing the grand total data instead of that hospit...
Hello,
When using either regular charts or pivot chart to create a visualization of PivotTable data, its important to turn off the grand total and or subtotal.
To turn off the grand total:
1. In the Grand Total dropdown of the Layout group of the PivotTable Tools, select Off for Rows and Columns
Then you can create your PivotChart in the Tools group of the Analyze contextual ribbon tab.
All you need to do is turn off the grand total of that particular hospital so that it won't impact the insert chart
See a sample attached caption
When using either regular charts or pivot chart to create a visualization of PivotTable data, its important to turn off the grand total and or subtotal.
To turn off the grand total:
1. In the Grand Total dropdown of the Layout group of the PivotTable Tools, select Off for Rows and Columns
Then you can create your PivotChart in the Tools group of the Analyze contextual ribbon tab.
All you need to do is turn off the grand total of that particular hospital so that it won't impact the insert chart
See a sample attached caption
This did not solve the problem.