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! |
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 |
All times are GMT +1. The time now is 12:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com