Excel 2007: I have a stacked column chart with 2 numbers. I want to display the % total in the columns data labels but still have the actual numbers showing as the y-axis. Any way to do this without having to create dummy data & a secondary y-axis?
Data example:
Hosp Data1 Data 2
A 10 15
B 25 5
C 5 10
I want the 5, 10, 15, 20, 25 on the y-axis but the two sets of data in each column should be % that adds to 100 (but not have the columns all meet at the top.
Hope this makes sense to someone -- this is my first post. Thanks.
Data example:
Hosp Data1 Data 2
A 10 15
B 25 5
C 5 10
I want the 5, 10, 15, 20, 25 on the y-axis but the two sets of data in each column should be % that adds to 100 (but not have the columns all meet at the top.
Hope this makes sense to someone -- this is my first post. Thanks.
