Hyperlink to a Chart

[Logos]

Anyone know how to hyperlink to an Excel chart page? Not to a normal worksheet, which is pretty easy, but rather to those specialized chart pages the chart wizard creates.

Thanks much.

Logos

 

[Damon Ostrander]

Hi Logos,

Strictly speaking, a hyperlink will not link to a Chart sheet. The same effect can be accomplished via a simple macro. You didn't mention WHAT you want to hyperlink, so I will assume it is a Shape object for this example (textbox, rectangle, etc.). Simply right-click on the Shape, select Assign Macro, select New, and then insert

Charts("Chart1").Activate

into the macro that appears. It should then be something like

Sub AutoShape1_Click()
Charts("Chart1").Activate
End Sub

Now you should be able to click on the Shape and go directly to the chart.