Hyperlink to a graph.

[Guest]

How do I create a hyperlink to a graph (made from a pivot table and inserted
as a new sheet) in the same excel file.
I know how to make hyperlinks to worksheets in the same document but the
graphs I made and inserted as new worksheets do not show up in the overview
where I can select to which worksheet I want the hyperlink to be assigned.

 

[Jon Peltier]

You can't. But you can fake it with a little macro:

http://peltiertech.com/Excel/Hyperlinks.html

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

 

[Guest]

I was afraid of that.
I know about the macro solution but I was hoping there was another way to do
it...

Thanks anyway!!!

 

[roman]

Would anyone please help me out clearly, how i can set hyperlink on my pie
chart?
Thanks in advance.

roman

 

[Gaurav]

Just insert a new 'worksheet' and paste the graph there. it will then show
up in the list when you try to create a hyperlink.

hope this helps.

 

[Jon Peltier]

Did you read my article on Hyperlinks? If so, which part is giving you
problems?

- Jon