ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to add colum totals to a pivot chart data table (https://www.excelbanter.com/charts-charting-excel/198179-how-add-colum-totals-pivot-chart-data-table.html)

tmarsh

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?

Infinitogool

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