Forum Discussion
How to Add total in pivot stacked column Chart (macos)
I m using mac, in Excel 365 I created table with 10 columns and created pivot table with 3 columns. Using the pivot table I created stacked bar chart, in which I could add label values to the breakdown but not the overall total.
Please advise.
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.
