newbie: Getting the X and Y positions
 

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

newbie: Getting the X and Y positions
 

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/
_______

Greg Wilson wrote:

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