I want my grand totals to show in my pivotchart, how can I get this accomplished? Thank you
K Kristin May 4, 2005 #1 I want my grand totals to show in my pivotchart, how can I get this accomplished? Thank you
D Debra Dalgleish May 5, 2005 #2 I don't know of a way to include the grand total in a PivotChart. You could create a normal chart, based on the pivot table, and include the totals in that. On Jon Peltier's site, there are instructions for creating a normal chart from pivot data: http://www.peltiertech.com/Excel/Pivots/pivotcharts.htm
I don't know of a way to include the grand total in a PivotChart. You could create a normal chart, based on the pivot table, and include the totals in that. On Jon Peltier's site, there are instructions for creating a normal chart from pivot data: http://www.peltiertech.com/Excel/Pivots/pivotcharts.htm
