X,Y coordinates on chart

[lgarcia3]

I have to create a char, that when clicked on will return the point of the click. PLEASE, noticed that I will be clicking anywhere on the plot NO on a SERIES of points. In other words, lets say I have a XY chart with these values:

x= 1,2,3,4,5,6,7,8
y= 2,9,4,5,7,2,4,1

If I do an ALEATORY click somewhere on the plot (NOT ON AN ALREADY PLOTTED SERIES!) I will get the values equals or close to the ones shwon above.
Thanks!

 

[lgarcia3]

So, anyone knows the answer to this?

 

[Jon Peltier]

Here's an article about chart events, which is what you'll have to use:

http://www.computorcompanion.com/LPMArticle.asp?ID=221

Here are a couple of canned examples:

http://peltiertech.com/Excel/Charts/chartvba.html#PointInfo