Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentages AND Value lables on Stacked Columns | Charts and Charting in Excel | |||
Adding percentages | Excel Worksheet Functions | |||
stacked bar chart with percentages | Charts and Charting in Excel | |||
Percentages on Charts | Charts and Charting in Excel | |||
Helped with stacked bar chart and percentages | Charts and Charting in Excel |