Forum Discussion
How to Add total in pivot stacked column Chart (macos)
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.