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.
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!!
So, I can't even figure out how to post a new topic...I looked it up and someone was saying how maybe when you first join it limits how many posts you can make at first to control for spam?
Anyway, new question below:
Hi Everyone,
I have these two pie charts, as you can see by the grid they are exactly lined up, but the LGBTQ one is slightly higher than the woman-business one. I tried moving it, but the orange section just separates from the green and turquoise sections. Is there a precise way to make sure this pie is exactly the same size and position as the woman-business one? I also tried experimenting with making the title two lines as in the woman-business title, but the pie didn't move. I've tried looking this up online and all I find is how to move the entire chart, not the pie itself. By the way, these are two charts right next to each other. Thank you for any help.
If you look closely, you'll see that the bottom edges of the charts are perfectly aligned, but the top edges aren't:
The one on the left is slightly taller than the one on the right. I'd try making the women chart as a whole slightly smaller so that it is the same size as the LGBTQ chart.
- Thank you, when I try and adjust the size of one chart, they both adjust, it's so weird...oh well...and thank you for providing the forum link...i'm not sure if i was there yesterday or not, but, currently i do see a start a discussion button, so, i bookmarked that link!!
If you go to the forum page, don't you see a 'Start a Discussion' button?
