Data label alignment

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

Thanks Andy. It was exactly what you described.

>-----Original Message-----
>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.
>
>anonymous@discussions.microsoft.com wrote:
>
>> 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
>
>.
>

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.

anonymous@discussions.microsoft.com wrote:

> 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