EXCEL Hyperlink to Charts Questions.. URGENT.. =(

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 xl2002>ctrl+k>select "place in this document">select your chart.

Or you could use a double click event macro

--
Don Guillett
SalesAid Software
[email protected]
"kaci" <[email protected]> wrote in message
news:[email protected]...
> 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 xl2002>ctrl+k>select "place in this document">select your chart.
>
> Or you could use a double click event macro
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "kaci" <[email protected]> wrote in message
> news:[email protected]...
> > 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 xl2002>ctrl+k>select "place in this document">select your chart.
>
> Or you could use a double click event macro
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "kaci" <[email protected]> wrote in message
> news:[email protected]...
> > 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