I can't get the percentages to work in a bar chart data label.

G

Guest

I created a bar chart in Excel and when I go to Chart Opens, I can add the
value of each bar in as a data label but the percentage choice is grayed out.
How do I include percentages?
 
J

Jon Peltier

Convert the worksheet data to percentages first, then plot these percentages
in your chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding percentages to stacked bar charts 1
Pie Chart percentage 1
Label a Percentage Bar with Value 3
Stacked Bar chart - percentage share of a bar info 1
chart Label text referencing worksheet cell value 1
Stacked Bar Chart - Data Labels:Percentage - Excel 2003 0
Percentages in a pie chart 3
Excel 2003 Charting 2

Top