Hyperlink to a chart sheet...?
 

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

Hyperlink to a chart sheet...?
 

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

Hyperlink to a chart sheet...?
 

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

http://pubs.logicalexpressions.com/P...?ID=209#jon016

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Debra Dalgleish wrote:
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.