Hi,

You can not get the Width or Height directly via the object model.
As a work around what you can do is, via code, attempt to move the data
label outside of the chartareas boundaries. As this is not possible the
data labels gets positioned as near to the edge as possible. You can
then use the new left and top position to do some simple maths to work
out the width and height.

Cheers
Andy

Phil Stanton wrote:
I am trying to position datalabels on a scatter chart using Bob Bovey's XY
labeller. This puts a label on a chart for each point. Many of the labels
are sloping upwards and consequently I need the bottom left of the label
next to the point concerned. The label position is defined by the Top and
Left and I want to position it by the Bottom Left. Consequently I need to
know the height of the label.
Any ideas how

Thanks

Phil



--

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