S Shafali New Member Feb 27, 2012 #1 How can I add a grand total on Stacked chart in Pivot table chart? Thanks, Shafali
Luke M Excel Ninja Staff member Feb 27, 2012 #2 You can't do that with a PivotChart, and with a regular chart, you can't do it natively. In a regular chart, you would need to plot a dummy series that have the grand totals as values, and then display the labels from that series.
You can't do that with a PivotChart, and with a regular chart, you can't do it natively. In a regular chart, you would need to plot a dummy series that have the grand totals as values, and then display the labels from that series.
