Forum Discussion
Displaying values to right of clustered bars
Hi Everyone,
I am trying to display values to the right of clustered bars like this. So, basically I wouldn't have normal x-axis labels, I just want the exact value displayed to the right of the bar. The other thing is is my data already represent percentages, so, the values in my sheet like "9" or "14" are already percents and aren't decimals that need to be converted to percents. Is this helpful? I'm nervous to post here honestly because so many tech-ish forums have pretty unfriendly answers/responses, so, please be kind in your response. Thanks! I have obviously tried messing with axis labels, and the only video I found similar to this was how to convert decimals to percents and then display them...I just figured out the quick layout thing which seems to display values within the bars...so...that's close...
If you want 5 to display as 5% in the data labels:
Double-click on any data label for Hawaii. Excel should select all of them and activate the Format Data Labels task pane.
Click Label Options, then expand Number.
Enter 0"%" with quotes around % in the Format Code box, then click Add.
Do the same for the US data labels.
11 Replies
Hi Kelsey,
Don't worry, participants in this forum are very friendly. I think that what you want is data labels:
Not sure about the percentages though - could you show us what the data look like?
HansVogelaar Thanks so much, it's always something so obvious!! Here's a pic of some of my data, is this what you mean? So basically 5% of Hawaii small business firms are 0-2 years old, for example. I'm starting to get worried I need to enter the values in the cells as something like "5%" for the labels to show up.
If you want 5 to display as 5% in the data labels:
Double-click on any data label for Hawaii. Excel should select all of them and activate the Format Data Labels task pane.
Click Label Options, then expand Number.
Enter 0"%" with quotes around % in the Format Code box, then click Add.
Do the same for the US data labels.
