Data label alignment

[Guest]

I was trying to include the value of each bar in a bar
chart. But the alignment menu for the data label only
allows for inside top, middle and end, which overlaps with
the bar and make it difficult to read. How do I make these
data labels to stay OUTSIDE AND ON TOP of the bar? Thanks

 

[Guest]

Thanks Andy. It was exactly what you described.

 

[Andy Pope]

Sounds like you are using the Stacked column chart, which does not offer
the Outside option because for all but the last series the data label
would appear in the next portion of the stack.

If your stack only contains 1 data series the change the chart type to
clustered column and the outside alignment will be available.

Failing that you might consider using Rob Bovey's XY Chart Labeler:
(http://www.appspro.com/utilities/utilities.asp)
Which has a feature that allows you to move data labels.
Or you could do it manually, select data labels then select a single
data label. You should know be able to move it withing the chart.

I was trying to include the value of each bar in a bar
chart. But the alignment menu for the data label only
allows for inside top, middle and end, which overlaps with
the bar and make it difficult to read. How do I make these
data labels to stay OUTSIDE AND ON TOP of the bar? Thanks

--

Cheers
Andy

http://www.andypope.info