How to use hyperlink to chart?
 

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?

How to use hyperlink to chart?
 

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?

How to use hyperlink to chart?
 

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

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


"Jacob Skaria" wrote:

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?

How to use hyperlink to chart?
 

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

How to use hyperlink to chart?
 

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
---------------
Jacob Skaria


"Cloud Strife" wrote:

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

How to use hyperlink to chart?
 

Thanks for your help~