Click on cell to take you to chart
 

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?

Click on cell to take you to chart
 

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.

"BStrandberg" wrote:

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?