Percentage in Data Labels Tab

[Falcon08]

How can I activate the Percentage in Data Labels Tab? It is grayed out. I
am using a stacked column chart. For example, one column is totaled 270. In
that column is two numbers, which are 142 for males and 128 for females. I
added the value in Data Labels Tab to display the numbers (142 and 128) in
that column. I also want to display percentage along with those numbers,
but it is grayed out. Why is it grayed out and how can I display the
percentage in that tab?

Thanks.

 

[Jon Peltier]

That one is only enabled for pie charts. You could create custom labels in a
worksheet range and apply them using one of these free utilities:

Rob Bovey's Chart Labeler, http://appspro.com/Utilities/ChartLabeler.htm
John Walkenbach's Chart Tools,
http://www.j-walk.com/ss/excel/files/charttools.htm

- Jon