Thank you so much ^^
Hi jaemin,
Thanks for your feedback. To answer your original question, it will help if you insert a new table to calculate Percent.
Format the cells in B as Percentage.
Formula in B2 of the Percent table (and Fill Down)
=Total Sales::B2÷Total Sales::B$5
The 'divide by' symbol looks like a 'plus' symbol at this forum resolution, but it isn't.
Note the $ symbol in the formula to keep B$5 fixed on Gross Sales as you Fill Down.
I had to click on Edit Data References > Plot Rows as Series (bottom Left of the Numbers window).
Then click on each Series and Format Panel > Series > Value Labels > Same as Source Data
but I think you have already worked that out 😉.
Thanks for the gold star.
Regards,
Ian.
Wow!!! Thank you so much your help. ^^
Hi jaemin,
Glad to help, and thank you for the green tick and your feedback. Keep posting in Numbers for Mac.
Regards,
Ian.
Hi Ian and jaemin,
I've discovered you don't really need to have an intermediate table to calculate percentage. Here I achieved the same effect without an extra table by selecting range A1:B3 and from the menu choosing 'Insert > Chart > 2D Stacked Bar', then clicking 'Edit Data References' and choosing 'Plot Rows as Series' (lower left), then selecting 'Percentage' for 'Axys Scale' and 'Value Labels'.
SG
Hi SG,
🙂
Regards,
Ian.
Thank you so much ^^
I'm in trouble to modify bar chart