Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Table Chart - Group Totals
I have a pivot table which is translated into a chart.
I have 20 rows of data, each has a numeric value, which is in turn translated into a Vertical Bar Chart. I can get the chart to display the relevant values for each Bar. Now I have "grouped" some of the rows in the pivot table, and the pivot table displays the totals for each of the groups, the chart "groups" together the bars under a relevant heading that I have given in the PT. What I now want to do is display on the chart somewhere [ possibly at the bottom where the group headings are displayed ] the totals for each of the groups. Can this be done, if so how can I achieve it? Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Table Chart - Group Totals
bump
"Dave Eade" wrote: I have a pivot table which is translated into a chart. I have 20 rows of data, each has a numeric value, which is in turn translated into a Vertical Bar Chart. I can get the chart to display the relevant values for each Bar. Now I have "grouped" some of the rows in the pivot table, and the pivot table displays the totals for each of the groups, the chart "groups" together the bars under a relevant heading that I have given in the PT. What I now want to do is display on the chart somewhere [ possibly at the bottom where the group headings are displayed ] the totals for each of the groups. Can this be done, if so how can I achieve it? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to add colum totals to a pivot chart data table | Charts and Charting in Excel | |||
Pivot Totals: Group totals different from Grand totals | Excel Discussion (Misc queries) | |||
Pivot Table Chart - With Pivot Table Totals | Charts and Charting in Excel | |||
Pivot table/chart - can I use data ranges? why will it not group d | Charts and Charting in Excel | |||
How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel |