Percentage value labels on stacked bar chart

[Dave]

Hi
Another problem I have with charting.
I want to preapre a stacked-bar chart of 5 different
values, which is easy enough. However, I also want to show
data labels of the percentage of the total stack for each
category. When I go intot the data labels options, the
percentage one is greyed-out.

Does anyone know of a way I can get the percentage values
on there, without having to manually type into a text box
each time??

Thanks again

Dave

 

[Debra Dalgleish]

as answered in .excel.misc:

Rob Bovey has a free add-in, the XY Chart Labeler, that you can use to
add the labels:

http://www.appspro.com/utilities/Labeler.asp

In an unused part of the worksheet, calculate the percentages, e.g.:
=B2/SUM(B$2:B$5)
Format the results, then use this range as the source for the labels.