How do I change a data label to read different than the actual numerical value in excel 2007 graph. i.e number in my axis that increase by 20's, the bar graph reads whole number, but I want to place a data label that reads a percent of the total over each bar. Does anyone know how to do this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Data label different than actual number in graph
- Thread starter 4hunters
- Start date
-
- Tags
- data label percent
Gerald Higgins
Well-known Member
- Joined
- Mar 26, 2007
- Messages
- 9,258
Here's one way, there may well be others.
I haven't used 2007 - I've done this in 2003 and assume you can do the same in 2007.
Make sure you are using a stacked bar chart type.
Turn off the data labels for your main series.
Use a dummy range to calculate the percentages you want to show.
Add this range as another data series.
Make sure it is in the correct sequence so that this new series sits on top of your existing series.
Set the labels to appear for this range.
Then change the format of this series to no fill, no border, so that it is effectively invisible, except for the % labels, which should be floating above the main bars.
I haven't used 2007 - I've done this in 2003 and assume you can do the same in 2007.
Make sure you are using a stacked bar chart type.
Turn off the data labels for your main series.
Use a dummy range to calculate the percentages you want to show.
Add this range as another data series.
Make sure it is in the correct sequence so that this new series sits on top of your existing series.
Set the labels to appear for this range.
Then change the format of this series to no fill, no border, so that it is effectively invisible, except for the % labels, which should be floating above the main bars.
Upvote
0
Similar threads
- Question
