Link back to source data from a point in a scatter plot?

[Riverglen]

I have a spreadsheet that contains a scatter plot based on a table of data on another sheet. When I hover the mouse pointer over any point in the plot, Excel displays a little pop-up box that identifies the coordinates of the point. Example: Series "My System" Point 4059 (4059, 4.7).

It would be very useful if I could write some sort of a macro to find the row in the source data sheet from which the plot coordinates were obtained. Cursor the point, enter <ctrl>-F and be taken back to the source sheet with the appropriate row or one of the cells from which the data was plotted given the focus.

Since Excel clearly "knows" where the point came from, it seems like what I want to do should be possible. Can anyone suggest an approach?

I am using Excel 2000.

[Riverglen]

Maybe I should clarify my terminology. By "sheet" I'm referring to a separate tabbed page in the same workbook file. The chart and the source data are on separate tabbed sheets in the same Excel file.

[Andy Pope]

You need to use chart events to identify the data point
http://www.computorcompanion.com/LPMArticle.asp?ID=221

You then need to parse the series Formula
http://spreadsheetpage.com/index.php..._chart_series/

[Riverglen]

Many thanx Andy,

I haven't had a chance to absorb the info in the links you provided, but apparently what I want to do is at least possible. You've set me off on a nice little educational "science project". I am not an experienced VBA programmer, so I may be back for some more help