rickkcir
Technical User
- Jul 31, 2002
- 35
I have a bar chart that shows exposure to certain groups in millions of dollars.
Currently, the x-axis names each group, the y-axis shows millions of $'s (200, 400, 600, 800) and then the bars show how many millions of dollars for each group with the number of millions shown on each bar.
I would like to keep the y-axis as it is (200, 400, 600, 800), but instead of showing, for example, 71 (for 71 million) on the bar, I would like to show what the groups % of the total is. So, if the total is 900 million, instead of showing 71, I would like the bar to show 7.88% on the outside of the bar.
I have a % formula created, but any way I play with the chart expert, I can't seem to get it to show the number increments on the y-axis, but the % of total as the value of the bar.
Any help is greatly appreciated.....thank you.
Currently, the x-axis names each group, the y-axis shows millions of $'s (200, 400, 600, 800) and then the bars show how many millions of dollars for each group with the number of millions shown on each bar.
I would like to keep the y-axis as it is (200, 400, 600, 800), but instead of showing, for example, 71 (for 71 million) on the bar, I would like to show what the groups % of the total is. So, if the total is 900 million, instead of showing 71, I would like the bar to show 7.88% on the outside of the bar.
I have a % formula created, but any way I play with the chart expert, I can't seem to get it to show the number increments on the y-axis, but the % of total as the value of the bar.
Any help is greatly appreciated.....thank you.