auto position of data labels in a line chart

Hi All

Does anybody know of a way of automatically having data labels either
positioned above or below depending on another cell value?

Basically when I update data behind a series of charts, sometimes (depending
on the values) its best to have the value labels above and sometimes below.
I want the chart to know which is best automatically without me clicking on
each series of data labels and manually changing them. I was thinking I
could link this condition to a cell (in which I would have a formula telling
it what to do).

I think the only way that this could be done would be within VB, but am not
sure.

Thanks in advance

Nick

Hi,

For a non vba approach. Try adding 2 extra series, which will display
the up/down data labels. Add formula to their cells so that either the
value is used or NA().

Format the 2 data series to have no pattern or fill/markers. Add data
labels to each and format one set to align above and one below.
If that didn't make any sense post back

Cheers
Andy

Nick Turner wrote:
Hi All

Does anybody know of a way of automatically having data labels either
positioned above or below depending on another cell value?

Basically when I update data behind a series of charts, sometimes (depending
on the values) its best to have the value labels above and sometimes below.
I want the chart to know which is best automatically without me clicking on
each series of data labels and manually changing them. I was thinking I
could link this condition to a cell (in which I would have a formula telling
it what to do).

I think the only way that this could be done would be within VB, but am not
sure.

Thanks in advance

Nick

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thanks Andy

Makes sense. I was hopeing that their was a way I could do this without
using VBA.

Nick

"Andy Pope" wrote:

Hi,

For a non vba approach. Try adding 2 extra series, which will display
the up/down data labels. Add formula to their cells so that either the
value is used or NA().

Format the 2 data series to have no pattern or fill/markers. Add data
labels to each and format one set to align above and one below.
If that didn't make any sense post back

Cheers
Andy

Nick Turner wrote:
Hi All

Does anybody know of a way of automatically having data labels either
positioned above or below depending on another cell value?

Basically when I update data behind a series of charts, sometimes (depending
on the values) its best to have the value labels above and sometimes below.
I want the chart to know which is best automatically without me clicking on
each series of data labels and manually changing them. I was thinking I
could link this condition to a cell (in which I would have a formula telling
it what to do).

I think the only way that this could be done would be within VB, but am not
sure.

Thanks in advance

Nick

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info