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 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 |
All times are GMT +1. The time now is 08:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com