link to charts within spreadsheet

Kenboy

New Member
Joined
Mar 4, 2004
Messages
2
Hi all, Newbie here,

I have a spreadsheet with a data worksheet and 30 charts I have built from the data, all on separate tabs. How do I hyperlink from some text in my data worksheet to the associated chart? :confused: I don't know how to reference these charts. :(

And can I insert a hyperlink that will take me from the chart back to my data sheet? Or, a macro to return to my data sheet would be fine. Thank you. :)
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

earlyd

Well-known Member
Joined
Dec 10, 2002
Messages
1,199
One way is just to create a 'menu' sheet which could be your data sheet or another sheet altogether. You can use the Forms toolbar to add buttons or you can add any drawing object. When you right click on it you can attach a macro to that button or object. All the macro needs is something like this:

Sub GoSalesChart()
Sheets("SalesChart").select
End sub


Then you could have another similar macro to go back to the menu...giving it a control key so that you can just press CTRL M to go back to the menu might be a good idea (tools...macro...options button)

Have fun!
 

MartinK

Active Member
Joined
Oct 30, 2003
Messages
384
Also,
right-click in the bottom-left corner on the sheet navigators (the black arrows). A list with all your sheets will pop up.
Martin
 

AlohaJulio

Board Regular
Joined
Feb 10, 2004
Messages
188
If you use the ASAP Utilities, which you can get for free from www.asaputilities.com, it has a function that gives you a few options of creating an index sheet with the names of all the sheets and or charts in your workbook. If you were to do this, plus use the tips from earlyd you should be all set.

One thing to remember with the index sheet generated by ASAP, is that in order for the links to work the user has to have ASAP installed. One workaround for this is to let ASAP creat the index sheet then replace the links it has generated with your own by Insert>Hyperlink>Place In This Document. Though for the charts, you'll have to use earlyd's macros, as charts as individual tabs don't show up in the hyperlink menu.

Hope this helps.
 

Kenboy

New Member
Joined
Mar 4, 2004
Messages
2
Guys, thanks very much for the answers. Especially EarlyD! I'm going right to work on these. As for this board, I say, UR-RAH!! (y)
 

Watch MrExcel Video

Forum statistics

Threads
1,127,832
Messages
5,627,152
Members
416,224
Latest member
RichardHell

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top