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.

In xl2002ctrl+kselect "place in this document"select your chart.

Or you could use a double click event macro

--
Don Guillett
SalesAid Software

"kaci" wrote in message
...
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.

How about if i am using a Excel 2003 version?

"Don Guillett" wrote:

In xl2002ctrl+kselect "place in this document"select your chart.

Or you could use a double click event macro

--
Don Guillett
SalesAid Software

"kaci" wrote in message
...
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.

I have tried already, but under 'place in this document', there is no choice
for my chart.

How can I use macro instead?
Thanks for advice.

"Don Guillett" wrote:

In xl2002ctrl+kselect "place in this document"select your chart.

Or you could use a double click event macro

--
Don Guillett
SalesAid Software

"kaci" wrote in message
...
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.

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