How-to Add a Grand Total Line on an Excel Stacked Column Pivot Chart

Download the sample file and read the tutorial here: www.exceldashbo...
Today I answer a viewer question. "How do I add a cumulative grand total amount as a line above a stacked column pivot chart in Excel?" Well there are a few tips and tricks to create this type of pivot chart, but you can see how to do it in this tutorial.
Some show notes that may help you modify your pivot chart:
1) www.exceldashbo...
2) www.exceldashbo...

[@contextmatters8243]

hi.
Great video!
Question: What version of Excel you're using; I don't see "Combo" in the "Select Chart Type" choices?

[@exceldashboards]

I believe that this one was done in version 2016. Should still be like this in 2013 and 2019. Are you on the online version?

[@contextmatters8243]

@@exceldashboards Hi.
Thanks for responding...
I'm on Excel 2010 (which I suspect was the issue) where I bought the disks and installed myself.
I guess I have to make a decision on whether or not to spring for a newer version.....
Twelve (12) years old --- I guess it's about that time. 🙂