Scatter Chart

[Nino]

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?

 

[Jon Peltier]

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=utFn5#HxBHA.2620@tkmsftngp03

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/Excel/Charts/chartvba.html#PointInfo

- Jon