Forum Discussion
Solved
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 ...
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.
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!!