View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phil Stanton[_2_] Phil Stanton[_2_] is offline
external usenet poster
 
Posts: 23
Default Positioning datalabels

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