linking in Excel

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!

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

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

that you may be able to use.


Steve Kay wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html