You cannot hyperlink a chart directly; unless the chart is embedded within a
worksheet in which case you can hyperlink to any cell under the chart. The
only way to achieve this is using a macro. Try the below and feedback

-----Set the Security level to low/medium in (Tools|Macro|Security). From
workbook launch VBE using short-key Alt+F11. From menu 'Insert' a module and
paste the below code. Save. Close the VBE window and get back to Workbook.

Sub GoToMyChart()
Charts("Chartname").Activate
End Sub

------Right click the pictureAssign MacroFrom the list Select GoToMyChart
and click OK. Now try mouse click the shape.


If this post helps click Yes
---------------
Jacob Skaria


"Cloud Strife" wrote:

Hi, based on my title, I like to use the hyperlink from a picture that in
worksheet 1, like to link to another worksheet that only have CHART, but when
I do hyperlink, the chart worksheet is not inside it, what should I do?