Archive of Mr Excel Message Board
Back to Hyperlinks in Excel archive index
Back to archive home
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.
Re: Hyperlink from a spreadsheet to a chart in the workbook.
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"
Re: Hyperlink from a spreadsheet to a chart in the 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.
Re: Hyperlink from a spreadsheet to a chart in the workbook.
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
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.