Click on cell to take you to chart

B

BStrandberg

I have a table of contents cover page (in excel) and 20 charts (each in it's
own worksheet within the same document). I need to have the person be able
to click on the cell indicating the chart title on the title page and have it
take them to the corresponding chart. Is this possible?
 
I

InternJessica

Right click on your cell that contains the title that you want to be able to
click on, click on hyperlink...where it says Link To: choose Place in this
Document...then it shows you the sheets that you can have it bring you to.
Then you can type the Cell that you want it to jump to as well.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking chart title to a cell 2007 2
Chart title variable 4
Chart title text linked from a cell? Possible? 2
How to use hyperlink to chart? 5
Format Chart Area 1
Chart autoexpand after legend/title removed 1
Chart to foreground 1
Can I have a value in a chart title that references a cell? 1

Top