Hyperlink to Chart Sheets???

Hi I have created numerous Charts (onto new sheets) in my Excel Workbook.

I have created an index page which I want to Hyperlink to these charts within the Excel workbook.

The problem is that I cannot hyperlink to these chart sheets - I can only hyperlink to the sheets which contain the data tables from which these charts are created.

Any idea how I can hyperlink these chart sheets?

Thanks!!!

Well a way is to draw a button on the sheet and attach a macro to it.

Just go tools, macro, record new macro
then click on the chart tab and then stop the macro.
then attach the macro to the button

Regards

Dav

I've found an article which explains it nicely

Hyperlink to a Chart Sheet
You can't hyperlink to a chart directly, and a chart sheet has no underlying cells you can link to. You can fake it with a Worksheet_SelectionChange event procedure, however. In this example, the hyperlink is in cell B2. Enter the name of the chart sheet in cell B2, and format it with blue underlined text, so it looks like a real hyperlink. Right click on the sheet tab, select View Code, and paste this macro into the code module that appears:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("B2")) Is Nothing Then
On Error Resume Next
Charts(Target.Value).Activate
If Err.Number <> 0 Then
MsgBox "No such chart exists.", vbCritical, _
"Chart Not Found"
End If
On Error GoTo 0
End If
End Sub
When the user selects cell B2, the procedure is activated. The code jumps to the sheet with the name in the cell. If Excel cannot go to that sheet, the code assumes it's because the sheet doesn't exist, and alerts the user.

What dnf999 mentinoed works well for one hyperlink. Do you know how we should change it if we have multiple cells being linked to different chart sheets?