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...