Hyperlink to a graph.
 

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.

Hyperlink to a graph.
 

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/
_______

"Steven" wrote in message
...
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.

Hyperlink to a graph.
 

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

Thanks anyway!!!


"Jon Peltier" wrote:

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/
_______

"Steven" wrote in message
...
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.

Hyperlink to a graph.
 

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

roman

"Steven" wrote:

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

Thanks anyway!!!


"Jon Peltier" wrote:

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/
_______

"Steven" wrote in message
...
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.

Hyperlink to a graph.
 

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.


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

roman

"Steven" wrote:

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

Thanks anyway!!!


"Jon Peltier" wrote:

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/
_______

"Steven" wrote in message
...
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.

Hyperlink to a graph.
 

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


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

roman

"Steven" wrote:

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

Thanks anyway!!!


"Jon Peltier" wrote:

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/
_______

"Steven" wrote in message
...
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.