Interactive graph with table cells

I have big data set (~5000 data). I wish to know the position of point in graph. Is there anyway that I can select one point in graph and from there I get the corresponding cell "activated" so that the point can move according to selected cell?

Add on: Is there any possibility that the graph can "follow" the selected cell so that I don't have to scroll up and down to select the cell and to look into the graph?

You can use chart events to determine selection of series and point.
Decode the series formula in order to locate source cell.

toggle between worksheets in order to set a reference to the chart. If this does what you want then you can add code to the Thisworkbook open event to enable chart events.

Please Login or Register  to view this content.