newbie: Getting the X and Y positions

N

Nicky

Hi all.

I've searched through the groups and can't seem to find anything that
helps me. I've created an XY Scatter chart and need to draw a line
from a point in one series to a point in another series. Currently,
i'm able to get the X value of points, but not the x and y position
which I need to draw my line. I'm just a newbie when it comes to VBA,
so I appreciate any help.

Thanks, Nicky
 
G

Greg Wilson

Have you considered simply adding a new series containing
the two points - one from each of the existing series?
This series would not have markers, just the straight line
type. This would in effect draw a line between the two
series.

Regards,
Greg
 
J

Jon Peltier

And the advantage to Greg's suggestion is that, if the axis scales
change, the added series would move accordingly, while the drawn line
would sit dumbly where you drew it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Top