Hyperlink to tab

[Koejns]

I have a problem within excel about hyperlinks.
I want the user of my excel worksheet to click on a hyperlink to show the graph that is on an other tab of my excel file.

So is there a formula or an other way to have excel create these kinds of hyperlinks?

I have tried the option of adding a hyperlink but the menu didn't show the graph tabs.

(I'm asked to make a sheet without macros so please no macros!)

 

[VoG]

As far as I know you cannot hyperlink to a chart sheet.

 

[VoG]

This may help http://www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=26&utilities=20&lang=en_us

 

[TiaXL]

I have a problem within excel about hyperlinks.
I want the user of my excel worksheet to click on a hyperlink to show the graph that is on an other tab of my excel file.

So is there a formula or an other way to have excel create these kinds of hyperlinks?

I have tried the option of adding a hyperlink but the menu didn't show the graph tabs.

(I'm asked to make a sheet without macros so please no macros!)

Use a hyperlink insert your text right click on it and go to hyperlinks, then on the right hand side select "Place in This Document. Then select the sheet you want it to go to and the cell reference and done.

As above excel wont let you link to a chart sheet(I assume due to the fact it needs to know which cell to select when you get there) but you can inbed your chart in a regular sheet and link to that

 

[Koejns]

@VoG I see that the problem can only be solved with an add on to excel and that is not what I want.

@TiaXL that is what I tried and it didn't work because I cannot link to a chart sheet...

 

[Misca]

Here's a simple workaround: Place the chart as an object to a normal worksheet. In the worksheet options hide all the unwanted columns / rows (even the column / rows headings) + adjust the chart settings to your taste.

When you're done your worksheet should look just like it was a chart sheet but since it's not, you can hyperlink to it easily (as well as get all the other advantages - conditional formatting etc. - of a normal sheet over a chart sheet).

 

[Andrew Poulsom]

You can't link to a Chart sheet directly, but ...

Create a Hyperlink to cell A1 on the same sheet (you can change the text to display to make it meaningful). Right click the sheet tab and choose View Code. Paste this into the window on the right:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    If Right(Target.Name, 2) = "A1" Then
        Sheets("Chart1").Activate
    End If
End Sub

Change the reference to Chart1 to suit. Press Alt+F11 to return to your worksheet, and try it out.