| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
| Pivot Table Chart - With Pivot Table Totals | Charts and Charting in Excel | |||
| Pivot Table % of Totals | Excel Discussion (Misc queries) | |||
| Totals For a Pivot Table?? | Excel Discussion (Misc queries) | |||
| How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel | |||
Hybrid Mode
