lost_in_the_sauce
Board Regular
- Joined
- Jan 18, 2021
- Messages
- 128
- Office Version
- 365
- Platform
- Windows
Not totally sure on how to add % of total numbers inside a bar chart that is based of actual $$.
Group A and B total sales and margin (sales- cost of sales) - created a clustered bar chart and then moved group B to a secondary axis and made it match the primary axis, combo achieved! First stack is sales, second stack is margin.
What I would like to add in is not the actual $ value of each block, but the % of total - is the first stack is Group A and B sales with a 60-40 ratio, I want 60% in the larger block and 40% in the smaller block. I have the formulas done in the spreadsheet - I have no idea how to get them where I want. If I'm not being clear about anything let me know.
Group A and B total sales and margin (sales- cost of sales) - created a clustered bar chart and then moved group B to a secondary axis and made it match the primary axis, combo achieved! First stack is sales, second stack is margin.
What I would like to add in is not the actual $ value of each block, but the % of total - is the first stack is Group A and B sales with a 60-40 ratio, I want 60% in the larger block and 40% in the smaller block. I have the formulas done in the spreadsheet - I have no idea how to get them where I want. If I'm not being clear about anything let me know.
