ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   I can't get the percentages to work in a bar chart data label. (https://www.excelbanter.com/charts-charting-excel/73622-i-cant-get-percentages-work-bar-chart-data-label.html)

C. Rizzo

I can't get the percentages to work in a bar chart data label.
 
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?

Jon Peltier

I can't get the percentages to work in a bar chart data label.
 
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/
_______

"C. Rizzo" <C. wrote in message
...
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?





All times are GMT +1. The time now is 10:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com