Forum Discussion
How to Add total in pivot stacked column Chart (macos)
Aru23 It's difficult to picture how your data and pivot table exactly look like, but I created a small example in the attached file. Done that
The trick is to add the total as the last value in each series so that it is stacked on top. Then change the chart type of the 'Total' data point to a Line. Format the line as "no line" and if you want add a marker with a label.
Riny_van_Eekelen Thanks for your reply.
I have attached my sample sheet, please check and let me know how can I achieve adding total in the top of the stacked chart using Excel 365 (macos).
Note: I do not have total in the raw data.
Aru23 Better to share or upload a file with data that resembles your real data. You are counting Y and N. Otherwise, include a total count of the number of Y and N together for each a, b and c.
Thanks Riny_van_Eekelen for your suggestion,
I have attached the sample sheet.
Here I don't have or want total in the raw data.
How I can achieve adding grand total in the Stacked Bar Chart.
