Scatter Chart

HI

I am using an excel scatter chart for easy of clarity
lets imagine i have 2 points on this chart. I would like
to retrieve the x,y coordinates of these points so that I
can draw a line using VBA between the points

can anyone help?

Nino -

Here are some suggestions in increasing order of difficulty.

A) Couldn't you connect the points with lines by formatting the series
to have lines?

B) In this post I provided a macro that drew a closed shape connecting
the points in an XY Scatter chart:

http://www.google.com/groups?selm=ut...%40tkmsftngp03

C) On this web page, I show how to get information about a plotted point
that you click on, using chart event procedures:

http://www.geocities.com/jonpeltier/...html#PointInfo

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Nino wrote:
HI

I am using an excel scatter chart for easy of clarity
lets imagine i have 2 points on this chart. I would like
to retrieve the x,y coordinates of these points so that I
can draw a line using VBA between the points

can anyone help?