Wednesday, July 24, 2013

How to Include Grand Totals in Excel Pivot Charts


1. Open the PivotChart.
2. Click the 'Field List Button' image on the PivotChart toolbar if the Field List Button is not showing.
3. Click the field and go to 'Totals.'
4. Click 'Row Area' to add the grand total to the row area and 'Column Area' to add it to the column.

Blogger news