MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Hyperlink from a spreadsheet to a chart in the workbook.


Posted by Mike Clemens on November 21, 2001 4:59 PM

How do you setup a hyperlink to from a cell in one
spread sheet to chart in the same workbook. It easy to
do for other spreadsheets but I can figure out how to
this for chart. Thanks for you help.


Posted by Lewis on November 23, 2001 3:38 PM

Try Using the Excel Help
"Create a hyperlink to a specific location in a workbook"

Posted by Mike Clemens on November 25, 2001 6:42 AM

That's exactly what I do to link to a spreadsheet
in a workbook. But, the names of the charts in a
workbook do not appear in the list of cell
references and as far as I can tell there is no
way to add a defined name to a chart.

Posted by Lewis on November 25, 2001 4:31 PM

Hi,

You could try naming a cell under the top left hand corner of the chart and linking to that.

Lewis