Hyperlink to a chart sheet...?

[Robert Stober]

Hi,

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.

Any ideas?

Thank you,

Robert Stober

 

[Debra Dalgleish]

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?&[email protected]

 

[Jon Peltier]

It and many other questions are also answered in my Charting FAQ, in the
recent issue of TechTrax e-zine:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon016

- Jon