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.
Aru23 Not in one like that. Although you tried to follow my example, you put what I intended to be in the column area in the row area. It's also problematic when you deal with Y and N rather than numerical values.
Can you upload an example with more realistic data that resembles your own? I could create something myself again guessing what you are after, but I'd rather have you clarify what you are dealing with.