Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / December 2006

Tip: Looking for answers? Try searching our database.

Data labels other than charted values

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Phil from Ohio - 29 Dec 2006 16:00 GMT
I'm using Microsoft Excel 2000.  My question is:  I have a bar chart.  The
format of the Y axis value is shown as percentage and I want to label the
value of each bar shown in the graph.  However, I want the label to be the
true value and not the percent value.  How would I do this?

Example:
You have a budget of $50.00.  Harry spent $25, Bill spent $20, and Bob spent
$5.  The bar graph shows Harry as spending 50%, Bill 40% and Bob as 10%.  But
I would like the label for each bar to be the original $25, $20, and $5.  Is
there any way to accomplish this?
Bernard Liengme - 29 Dec 2006 16:57 GMT
Rob Bovey's XY Chartlabeler (www.appspro.com) (works on every chart type)
or John Walkenbach's Chart Tools (www.j-walk.com).

happy new year
Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> I'm using Microsoft Excel 2000.  My question is:  I have a bar chart.  The
> format of the Y axis value is shown as percentage and I want to label the
[quoted text clipped - 9 lines]
> Is
> there any way to accomplish this?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.