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 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks