You can't hyperlink to a chart sheet. Jon Peltier describes a
workaround, using a macro, in the following thread:
http://groups.google.com/groups?&thr...08%40yahoo.com
Robert Stober wrote:
I would like to create a "Table of Contents" for a rather complicated
workbook that conatins several charts. I would the text "Chart 1" to link to
the work sheet that contains a stand-alone chart. I can easily create
hyperlinks using the hyperlink button, but for some reason my chart sheets
don't show up, and typing them in manually causes Excel to crash. Hyperlinks
I create to non-chart worksheets work fine.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html