Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
C. Rizzo
 
Posts: n/a
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
From several workbooks onto one excel worksheet steve Excel Discussion (Misc queries) 6 December 1st 05 08:03 AM
Fan charts Dean Charts and Charting in Excel 7 May 30th 05 11:51 AM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Help making a chart that doesn't graph cells without data? Filtration Guy Excel Discussion (Misc queries) 0 March 22nd 05 09:21 PM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM


All times are GMT +1. The time now is 06:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"