Locate data records from scatter plot
Posted on 2014-03-31
I have an Excel scatter plot on which I have visually identified specific points for which I would like to locate within the set of records that was used to build the plot.
I can do this by:
1) hovering over the point to determine the exact x,y values for each point of interest
2) manually scanning the data table to find the x,y pair that matches these values
However, this cumbersome if there are more than a few points of interest or multiple plots to investigate.
Suggestions for how to accomplish this task in a more automated/interactive fashion are appreciated. Thank you in advance.