How to use hyperlink to chart?

[Cloud Strife]

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?

 

[Jacob Skaria]

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 picture>Assign Macro>From the list Select GoToMyChart
and click OK. Now try mouse click the shape.


If this post helps click Yes

 

[Jacob Skaria]

Forgot to mention that you need to edit the name within double quotes.. The
actual name should be within double quotes

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

 

[Cloud Strife]

I'm using Office 2007, can I know where to set the security level for the
macro?

 

[Jacob Skaria]

On the Developer tab, click the Macro Security button in the Code group. The
Trust Center dialog box appears with the Macro Settings tab selected. Enable
macros..OK

If this post helps click Yes

 

[Cloud Strife]

Thanks for your help~