J johnanish New Member Feb 18, 2012 #1 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
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 Active Member Feb 18, 2012 #2 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/
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/