A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old February 23rd, 2006, 07:53 PM posted to microsoft.public.excel.charting
external usenet poster
 
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  
Old February 24th, 2006, 11:39 PM posted to microsoft.public.excel.charting
external usenet poster
 
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?



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Query does not order the same data in the same way Milković Aleksandar Running & Setting Up Queries 10 December 15th, 2005 12:01 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Worksheet Functions 7 September 3rd, 2005 03:47 PM
Fan charts Dean Charts and Charting 7 May 30th, 2005 11:51 AM
Format on data to import to Access tables? (I need your advice) Niklas Östergren General Discussion 5 December 13th, 2004 02:54 PM
Embed data in graph wrace Charts and Charting 5 May 5th, 2004 04:39 AM


All times are GMT +1. The time now is 07:21 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.