?
Solved

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

Posted on 2010-08-19
8
Medium Priority
?
1,141 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
Independent Software Vendors: 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!

 
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 2000 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

762 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