Column BaR Chart and Data Labels
 

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
--
Malik

Column BaR Chart and Data Labels
 

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