MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Hyperlink to Charts


Posted by Clive on February 13, 2002 7:40 AM

I have a workbook containing lots of sheets, some of which are charts. I would like to be able to set hyperlinks from some of the non charts sheets to specific charts. However when you add a hyperlink you cannot point to one of the chart sheets !. Anyone out there know how you can do it ???

Tks VM

Clive


Posted by Chris D on February 14, 2002 11:38 AM

Hi CLive,

just name the range that sits behind the chart, or if you have a few, name each in turn

(ie chartrange1, chartrange2)

then insert your hyperlinks as normal, choosing the option to go to a "named location in file" and type in the required name range...

I just tested this - popped a simple chart in sheet 1 row 100 and named the range it sat on as "trythis"

then inserted a hyperlink on sheet 2 that pointed to a range named "trythis" and it worked, it jumped straight to the chart on sheet 1, way down the page.

Hope this helps
Chris