This doesn't specifically answer your question, but Rob Bovey has written a
free utility, xy Chart labeller. I don't believe the code is protected, so
you can possibly look at that for ideas:
http://www.appspro.com/Utilities/Utilities.htm
--
Regards,
Tom Ogilvy
"Phil Stanton" wrote:
I have a scatter chart and I want to be able to position the labels
differently for each point ( depending on the space available on the chart)
I know the X & Y co-ordinates of the points in the series.
The chart is 622 point wide and the interior width of the plot area is 422
point wide. I know the height and width of the label
If for example I want to place a particular label exactly over a point, what
is the calculation using the X co-ordinate, widths to give me the
DataLabel.Left value
Thanks for any help
Phil