I'm using Excel 2007. I need to have a dynamic stacked chart based on a pivot table that has the 'grand total' at the top of each stack. I understand from reading other threads that you cannot include the grand total in a pivot chart. Is this correct? If so, how can I create a regular type chart from the pivot info that will be dynamic that includes a grand total?
Example
Sept Oct Nov TOTAL
Item1 1 2 3 6
Item 2 4 5 6 15
Would like chart that stacks Sept, Oct, Nov for Item 1 with the total on top, etc.
Your help would be greatly appreciated!
Example
Sept Oct Nov TOTAL
Item1 1 2 3 6
Item 2 4 5 6 15
Would like chart that stacks Sept, Oct, Nov for Item 1 with the total on top, etc.
Your help would be greatly appreciated!
