Hi,

One of many options is to seperate your =ve and -ve data into two series
using

=IF(B10,B1,NA())

and

=IF(B1<0,B1,NA())

and plot both series formatted the same. Then if you add the data labels for
one series, they'll all show on the same side of the axis.
Alternatively you could use Rob Bovey's Chart Labeller, but in this instance
you don't really need it.

Dave

url:http://www.ureader.com/msg/10296204.aspx