Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to include the Grand Total Column in a pivot table chart?
Hi, I have a simple pivot table with two columns A and B against several rows
of responses. The pivot table also shows the Grand Total Column. I can graph the pivot table quickly and simply with the chart wizard (a bar chart in this instance) and it will display a bar for column A and a bar for B grouped per row response. Great. I want to add what is effectively the third column in the pivot - Grand total column, so I would have 3 bars per row response; A, B and Grand Total. I can then compare A and B to the total bar. How do I add/show the grand total in the pivot chart? Thanks! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to include the Grand Total Column in a pivot table chart?
You could created a stacked column chart, that would show A and B in one
column. The top of the each column is the grand total. Or, in the pivot table, create a calculated item =A+B, or a calculated field, if A and B are separate fields. NJT wrote: Hi, I have a simple pivot table with two columns A and B against several rows of responses. The pivot table also shows the Grand Total Column. I can graph the pivot table quickly and simply with the chart wizard (a bar chart in this instance) and it will display a bar for column A and a bar for B grouped per row response. Great. I want to add what is effectively the third column in the pivot - Grand total column, so I would have 3 bars per row response; A, B and Grand Total. I can then compare A and B to the total bar. How do I add/show the grand total in the pivot chart? Thanks! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Grand Total | Excel Discussion (Misc queries) | |||
PIVOT TABLE - GRAND TOTAL COLUMN | New Users to Excel | |||
Sorting Pivot Table by Grand Total | Excel Discussion (Misc queries) | |||
Grand total in Pivot-Table | Excel Worksheet Functions | |||
Pivot Table -- Add column to average Grand Total | Excel Worksheet Functions |