reference a chart from another worksheet witha hyperlink

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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
 
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/
_______
 
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
 
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
'===================
 
Back
Top