Linking Data points in Excel

Copper Contributor

I am trying to figure out a way to link numbered data in a scatter plot to a cell in a separate tab that has a description explaining the specific data point I select. So if I were to click a data point in the scatter plot, it would take me to a designated cell describing the details of that data point (worded description). I have been researching different "macros" and "table events" and can't find anything that works. If anyone has any recommendations or has methods of accomplishing what I am trying to do I am all ears!!! Thank you.

0 Replies