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.