How to use hyperlink to chart?

  • Thread starter Thread starter Cloud Strife
  • Start date Start date
C

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?
 
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
 
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
 
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
 
Back
Top