adding percentages to stacked bar charts
 

I have a stacked bar chart that I would like to add percent
labels to. When I click on the chart options and go to the data labels tab,
the 'percentage' box visible but it is greyed out and is not an option. Is
there a way I can display the percentages on this chart?

Thank you!!

adding percentages to stacked bar charts
 

Thank you Andy! It's too bad it's not an automatic feature.

"Andy Pope" wrote:

Hi,

You would need to calculate the percentages, using formula, in some other
cells.
You can then link the data labels to those cells using this free addin
http://www.appspro.com/Utilities/ChartLabeler.htm

I see you also posted this in the Powerpoint forum. If you are using MSGraph
you will need to do the linking manually the same for the calculations
unless you copy and paste from excel.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"LaurenA" wrote in message
...
I have a stacked bar chart that I would like to add percent
labels to. When I click on the chart options and go to the data labels
tab,
the 'percentage' box visible but it is greyed out and is not an option.
Is
there a way I can display the percentages on this chart?

Thank you!!