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

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
Tom SageAsked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
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
 
MWGainesJRCommented:
use a stacked bar.....it might be what you want....see attached.....
Book1.xls
0
 
Tom SageAuthor Commented:
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
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
MWGainesJRCommented:
but it shows on the y axis that it is 50%.....I'm not sure you can do what you're asking......
0
 
MWGainesJRCommented:
The attached is about as close as you can get without using vba.
Book1.xls
0
 
Tom SageAuthor Commented:
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
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
0
 
Tom SageAuthor Commented:
Thanks for the help !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.