Positioning datalabels
Sound what I need, thanks
How do I get the pixle values as I thought chart dimensions were in points
Phil
"Joel" wrote in message
...
This problem is similar to a macro I run at work all the time. I needed
to
drop a line on a chart at a particular X value. I used simple ratios as
expalined below
Suppose your x axis goes from 10 to 100 and you need to find the value of
50
then
X_Ratio = (50 - 10)/(100 - 10)
Then if the pixel values of the chart goes from 1000 to 2000. You can get
thiese numbers from the .left parameter and the .width parameter of the
chart.
X_Pixel = (X_Ratio * (2000 - 1000)) + 1000
"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
|