reference a chart from another worksheet witha hyperlink

[Valeria]

Dear experts,
would like to reference a chartsheet form another worksheet of the same
workbook (to put an explanation of what each chart in the workbook does, put
the name of the chart aside, on which you can click to go directly on that
chart).
I have done it for some worksheets with the "hyperlink" function, but this
does not work for charts...
Could you please help me?
Many thanks in advance!
Best regards,

 

[Jon Peltier]

Valeria -

You can't hyperlink to a chart sheet, as you've discovered. You can fake it with a
simple macro, as described in the Charting FAQ:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon016

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Valeria]

Hi Jon,
many thanks, it works! A very last question, just for the aspect of the
spreadsheet.
Is there a way to have the cursor change its shape to a hand (like for
hyperlinks) when it passes on that cell?

Many thanks!
Best regards,
Valeria

 

[Jon Peltier]

Valeria -

Debra Dalgleish sent me this suggestion, which seems to work just fine:

In the cell that jumps you to the chart, insert a hyperlink to the cell itself.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Valeria]

Hi Jon,
this works really well, many thanks!
Best regards,
Valeria

 

[Jon Peltier]

Thank Debra. I guess she sent it to me because she didn't have time to test it. It's
a pretty neat idea.

- Jon

 

[Debra Dalgleish]

Good guess!

I also changed one line of your code, to move the selection to the cell
below. That ensures the user would have to select the cell again, to
trigger the event code, if they want to follow the fake hyperlink:

'=======
If Not Intersect(Target, Range("C10")) Is Nothing Then
On Error Resume Next
Target.Offset(1, 0).Select 'move to next row
'===================