| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| answer to odd results when comparing hyperlink addresses | Links and Linking in Excel | |||
| Bar graph and line graph overlayed | Charts and Charting in Excel | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Hyperlinkage of one graph with another graph or Drill down graph | Charts and Charting in Excel | |||
| Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
Linear Mode
