Solved

Excel 2007 Chart - How to add a percent value on a bar chart?

Posted on 2010-08-19
8
1,135 Views
Last Modified: 2012-05-10
I have an Excel 2007 bar chart.  Here are sample values for the Chart:

Status      Comp      Incomp
ABC      500      200
DEF      200      200

How can I add a % value for each bar.  For example, status DEF should have a value of 50%. Note that the % value does not have to be on the bar.  It can be to one side or near the bottom of each bar.

Thank you
0
Comment
Question by:Tom Sage
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
8 Comments
 
LVL 13

Expert Comment

by:MWGainesJR
ID: 33479109
use a stacked bar.....it might be what you want....see attached.....
Book1.xls
0
 

Author Comment

by:Tom Sage
ID: 33479183
I am using a stacked bar, and I can get the chart in your sample.  

What I want to do is to add a label to each bar that has the percent.  For example, the bar on the right should have a label of 50%.

Thank you
0
 
LVL 13

Expert Comment

by:MWGainesJR
ID: 33479245
but it shows on the y axis that it is 50%.....I'm not sure you can do what you're asking......
0
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
LVL 13

Expert Comment

by:MWGainesJR
ID: 33479381
The attached is about as close as you can get without using vba.
Book1.xls
0
 

Author Comment

by:Tom Sage
ID: 33479474
Thank you for your extra efforts.  I want to stay with the bar chart because I can put several bars in a smaller area.  

I do not mind using VBA.  I am familar with the Basic language, and i am familiar with objects.  I usually do my VBA work by recording a macro and using the code it created during the recording.

Thanks
0
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 500 total points
ID: 33479883
Hello MisterT,

you don't need VBA for that. What you DO need, though, is to calculate the percentages in your data table. Then, with the data labels on your chart,  click on an individual data label, click into the Formula bar, enter a = sign and click the cell that has the percentage value you want to show. Repeat for all data labels.

For a large chart, this manual method may be a bit tiresome. Instead, you can use a free Add-in called XY Chart Labeler. It's available from here and can put labels on any kind of chart, not just XY.

see attached

cheers, teylyn
Copy-of-Book1-1.xls
0
 
LVL 50
ID: 33479889
0
 

Author Closing Comment

by:Tom Sage
ID: 33481064
Thanks for the help !
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question