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.