Is it possible to use a mouse click on a chart to trigger a hyperlink ?
(the hyperlink will be to a place within the document)
It can be done on images and shapes, so can this also be done on charts ?
Add a comment
|
1 Answer
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.
-
Hi, I am trying this method, however Link is 'greyed' out on the insert tab when any chart is selected, I am using 2016– PeterHMay 17, 2018 at 11:43
-
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.– davMay 17, 2018 at 11:47