Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting excel sheets with charts | Charts and Charting in Excel | |||
Hyperlink display text maximum in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I disable the auto hyperlink feature in Excel? | Excel Discussion (Misc queries) | |||
Excel hyperlink to another Excel file | Excel Discussion (Misc queries) | |||
How to link a document to a workbook with a hyperlink in excel | Excel Worksheet Functions |