| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
hyperlink to Chart
Dear experts,
I would like to reference a chartsheet(S) where you can click to go directly on that charts). I have done it for some worksheets with the "hyperlink" function, but this does not work for charts... I want do this for many charts (at many sheets) , but want the hyperlinks resident at one sheet (like indexing) |
|
#2
|
|||
|
|||
|
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 Chetoos wrote: Dear experts, I would like to reference a chartsheet(S) where you can click to go directly on that charts). I have done it for some worksheets with the "hyperlink" function, but this does not work for charts... I want do this for many charts (at many sheets) , but want the hyperlinks resident at one sheet (like indexing) -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
|
|||
|
|||
|
I donno why it doesnt work ? :S
"Andy Pope" wrote: 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 Chetoos wrote: Dear experts, I would like to reference a chartsheet(S) where you can click to go directly on that charts). I have done it for some worksheets with the "hyperlink" function, but this does not work for charts... I want do this for many charts (at many sheets) , but want the hyperlinks resident at one sheet (like indexing) -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
|
|||
|
|||
|
It doesn't work because it's not been built to. You have to use code to
mimic the action of a hyperlink. Or do you mean you tried the code and it didn't work? Cheers Andy Chetoos wrote: I donno why it doesnt work ? :S "Andy Pope" wrote: 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 Chetoos wrote: Dear experts, I would like to reference a chartsheet(S) where you can click to go directly on that charts). I have done it for some worksheets with the "hyperlink" function, but this does not work for charts... I want do this for many charts (at many sheets) , but want the hyperlinks resident at one sheet (like indexing) -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#5
|
|||
|
|||
|
Hello Andy;
Yea , the second one , i tried the code and doesn work ; donno why "Andy Pope" wrote: It doesn't work because it's not been built to. You have to use code to mimic the action of a hyperlink. Or do you mean you tried the code and it didn't work? Cheers Andy Chetoos wrote: I donno why it doesnt work ? :S "Andy Pope" wrote: 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 Chetoos wrote: Dear experts, I would like to reference a chartsheet(S) where you can click to go directly on that charts). I have done it for some worksheets with the "hyperlink" function, but this does not work for charts... I want do this for many charts (at many sheets) , but want the hyperlinks resident at one sheet (like indexing) -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#6
|
|||
|
|||
|
becouse i have many chart sheets , and i wanna make hyperlink to each chart
sheet at the one sheet , is that possible , and if possible would you olease give me example for; Many Thx for your time; "Chetoos" wrote: Hello Andy; Yea , the second one , i tried the code and doesn work ; donno why "Andy Pope" wrote: It doesn't work because it's not been built to. You have to use code to mimic the action of a hyperlink. Or do you mean you tried the code and it didn't work? Cheers Andy Chetoos wrote: I donno why it doesnt work ? :S "Andy Pope" wrote: 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 Chetoos wrote: Dear experts, I would like to reference a chartsheet(S) where you can click to go directly on that charts). I have done it for some worksheets with the "hyperlink" function, but this does not work for charts... I want do this for many charts (at many sheets) , but want the hyperlinks resident at one sheet (like indexing) -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent Chart Assistance | Charts and Charting in Excel | |||
| Urgent Chart Questions | Excel Discussion (Misc queries) | |||
| Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
| HELP required: Insert -> Hyperlink -> ???(no CHART sheet name)!!! | Excel Worksheet Functions | |||
| Hyperlink to a chart... | Excel Discussion (Misc queries) | |||
Hybrid Mode
