link to charts within spreadsheet

[Kenboy]

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? 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.

 

[earlyd]

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]

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]

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]

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!!