View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Percentage in Data Labels Tab

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Falcon08" wrote in message
...
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.