Forum Discussion
Displaying values to right of clustered bars
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.
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.
HansVogelaar Thank you so much!!
