Scatter graph - data reference

Copper Contributor



I have a Scatter graph and i want to add an option that by pressing a dot on the graph it will highlight and/or link to the cells that commpose it.

for example,

by pressing the dot (3,4) on the graph it will highlight Row 4 A:C or link to the range if it's in a diffrent sheet.





0 Replies