Percentage value labels on stacked bar chart

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

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.


Dave wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html