Scatter Chart

  • Thread starter Thread starter Nino
  • Start date Start date
N

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?
 
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
 
Back
Top