Re: Positioning datalabels

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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





.

Relevant Pages

  • Plotting a diagonal in a bubble chart
    ... I need to plot a diagonal in a bubble chart. ... otherwise I'd simply manually draw the line! ... takes its co-ordinates from a series on the chart. ...
    (microsoft.public.excel.charting)
  • RE: Positioning datalabels
    ... free utility, xy Chart labeller. ... "Phil Stanton" wrote: ... I know the X & Y co-ordinates of the points in the series. ...
    (microsoft.public.excel.programming)
  • RE: Positioning datalabels
    ... This problem is similar to a macro I run at work all the time. ... Then if the pixel values of the chart goes from 1000 to 2000. ... "Phil Stanton" wrote: ... I know the X & Y co-ordinates of the points in the series. ...
    (microsoft.public.excel.programming)
  • 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. ... If for example I want to place a particular label exactly over a point, ...
    (microsoft.public.excel.programming)
  • Re: Positioning datalabels
    ... Points and pixels are the same. ... "Phil Stanton" wrote: ... How do I get the pixle values as I thought chart dimensions were in points ... I know the X & Y co-ordinates of the points in the series. ...
    (microsoft.public.excel.programming)