Re: Positioning datalabels

Tech-Archive recommends: Fix windows errors by optimizing your registry

Points and pixels are the same. Sorry for the confusion.

"Phil Stanton" wrote:

Sound what I need, thanks

How do I get the pixle values as I thought chart dimensions were in points

Phil


"Joel" <Joel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7BB34AEB-E320-4997-915F-4A24BC28A77C@xxxxxxxxxxxxxxxx
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






.

Quantcast