![]() |
How to add colum totals to a pivot chart data table
I have a chart for pivot table and would like to so totals for the data. The
data table on the chart displays the pivot table data but not the totals for each column. How can the totals be displayed on the chart? |
How to add colum totals to a pivot chart data table
Hi Tmarsh
You can't include the Grand Total in a pivot chart. 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 Regards, Pedro J. I have a chart for pivot table and would like to so totals for the data. The data table on the chart displays the pivot table data but not the totals for each column. How can the totals be displayed on the chart? |
All times are GMT +1. The time now is 03:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com