Column BaR Chart and Data Labels

[Malik]

My end user want to show the datalables (+ve or _ve) on same side. I can;t
find a specific option. In any case it only appears next to axis (TOP, Centre
or Bottom) but all depends on +Ve and -ve numbers.

Our requirement is that even number is +ve, it will stil show the Datalables
on the same side as -ve numbers.

I have option to remove the data lables and user Axis Labels .

Any idea

 

[Dave Curtis]

Hi,

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

=IF(B1>0,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