So, it turns out you can (at least in Excel 2016).
Select your chart
Insert > Links > Insert Link (bottom of your list) opens the standard Insert Hyperlink dialog box
Place in this document will allow you to choose a cell reference or defined name.
dav
Posted 2018-05-17T10:51:27.003
Reputation: 8 378
Hi, I am trying this method, however Link is 'greyed' out on the insert tab when any chart is selected, I am using 2016 – PeterH – 2018-05-17T11:43:35.513
Make sure you're selecting the Chart Area (outermost part), and not the plot area, or any other internal piece. Choosing any of those other areas grays out Links for me also. – dav – 2018-05-17T11:47:16.307
Hi, I am trying this method, however Link is 'greyed' out on the insert tab when any chart is selected, I am using 2016 – PeterH – 2018-05-17T11:43:35.513
Make sure you're selecting the Chart Area (outermost part), and not the plot area, or any other internal piece. Choosing any of those other areas grays out Links for me also. – dav – 2018-05-17T11:47:16.307