linking in Excel

[Steve Kay]

Hi, I have a large excel file w/ 20 worksheets and
charts. I like to make a Table of Contents at the
begining (first worksheet) w/ links to different data
tables. Is there a way to link to a chart that is not in
a worksheet.. meaning it has its own sheet as a Chart?
Currently when I try.. It does not show up in the links
to choose from .. or should I say worksheets to choose
from.. (Excel 2002) Thanks!

 

[Debra Dalgleish]

You can't hyperlink to the chart sheet, but Jon Peltier has a macro
workaround in his Charting FAQ article:

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

that you may be able to use.