Scatter graph - data reference

Occasional Visitor

hey,

 

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.

 

Erans1885_0-1639595913623.png

 

 

0 Replies