View Labels as % in a non-100% stacked graph

[johnanish]

Lets say I have this data.

A B C D

80 20 80% 20%

65 15 81.25% 18.75%


How do I still get this as a stacked graph with the labels from C and D, but graph corresponds to A and B

 

[dan_l]

Ya know, I used to have a good way to do this.


I'll see if I can remember it. Till then, here's a crappy version:


http://dl.dropbox.com/u/1275899/crappycustomlables.xlsx


1. Add a 'ghost' series containing the percentage

2. Make that series transparent

3. Add data lables


This works because the percentage will be relative to the size of the bars. There are other ways though:


http://chandoo.org/wp/2010/05/05/change-data-labels-in-charts/