Hi,

You can not hyperlink directly to chart sheets. You can use VBA code
though. Jon Peltier has more information on the subject.
http://peltiertech.com/Excel/Hyperlinks.html

Cheers
Andy

kaci wrote:
I have an excel file which consists of many charts. I would like to set up a
directory to link to different charts in the table of contents.

Is there any ways to do it? Thank you so much.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info