View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Positioning datalabels

"Peter T" wrote in message news:%

Create an XY scatter or ordinary Line type, play with all the various Axis
options in the Scale tab (X-axis options are different in Scatter vs
non-Scatter), include both +ve & -ve X & Y values


Forgot to say, the idea of the demo is to return an array of arrays of point
coordinates (one XY-array per series) then do whatever with the known
coordinates. The demo includes a routine to maintain arrows over points. For
testing I'd go with that, then if OK make your own function to move your
labels (pass a datalables object to a similar routine as ArrowsToPoints).

Not sure the method you described to calculate datalabel sizes, and hence
centres, is quite right as it's not normally possible to place a label
exactly to bottom right of the chart area.

Regards,
Peter T