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