How to shift data labels to top of bar?

[mSolver]

As per chart - other than manually moving each $ value up, how do I exactly select the position (to top of bar)?

 

[myall_blues]

Use the data label position 'Outside end'

 

[mSolver]

If I use outside end, the % will overlap with the value though, how can I separate them cleanly?

 

[mSolver]

Use the data label position 'Outside end'

View attachment 113179

Any advice please? Thank you.

 

[myall_blues]

My apologies - this slipped my attention.

I'm assuming your data are laid out similar to this?

	%	$
A	35%​	379413​
B	7%​	70979​
C	9%​	97214​
D	25%​	273008​
E	7%​	75368​
F	3%​	30000​
G	5%​	57608​
H	2%​	20285​
I	7%​	80339​

Because you have two different vertical axes, you can display each value in a position independent of the other. It's just a bit tricky because they both plot on top of each other.
To do this, click on one of the bars of the series - either the % column or the $ column will be highlighted. Let's say it is %.
Now on the Chart Design menu->Chart Layouts group->Add chart element->Data labels->inside end.
Now press tab until the bars are highlighted again, but this time the $ column is highlighted.
Chart Design menu->Chart Layouts group->Add chart element->Data labels->outside end.

You should end up with something like this:

Hope this helps.

 

[mSolver]

My apologies - this slipped my attention.

I'm assuming your data are laid out similar to this?

	%	$
A	35%​	379413​
B	7%​	70979​
C	9%​	97214​
D	25%​	273008​
E	7%​	75368​
F	3%​	30000​
G	5%​	57608​
H	2%​	20285​
I	7%​	80339​

Because you have two different vertical axes, you can display each value in a position independent of the other. It's just a bit tricky because they both plot on top of each other.
To do this, click on one of the bars of the series - either the % column or the $ column will be highlighted. Let's say it is %.
Now on the Chart Design menu->Chart Layouts group->Add chart element->Data labels->inside end.
Now press tab until the bars are highlighted again, but this time the $ column is highlighted.
Chart Design menu->Chart Layouts group->Add chart element->Data labels->outside end.

You should end up with something like this:
View attachment 113406

Hope this helps.

got it! Didn't even realize there were 2 bars in 1 previously. If I only want to show the bar for $ value but not %, how to do it?

Also, If I want BOTH data labels to be Outside End, i.e. both outside of the bar but the numbers not overlapping, can this be done? Thank you.

 

[myall_blues]

If I only want to show the bar for $ value but not %, how to do it?

You could remake the graph and only choose one of the series as data instead of both. For example, in my data layout above just choose the first and second columns, or first and third columns, instead of both.
Alternatively you can right-click a bar, choose 'Select data' and turn off one of the data series that appear in the left hand pane. Of course in either case you will lose the data labels that go with it, but that's solvable.

Also, If I want BOTH data labels to be Outside End, i.e. both outside of the bar but the numbers not overlapping, can this be done?

You can set the margins of the labels. For example, let's say I've set them both outside end and they overlap.

Select say the $ bars (by tabbing as previously dicussed if necessary), then Chart Design menu->Chart Layouts group->Add chart element->Data labels->More data label options.
Then under Alignment you can adjust the top and bottom margins (and left and right also). In this example I've set the top margin to 0.5cm. Fiddle around until you get it right.