A worksheet is the sheet with cells and rows and columns. Charts can be
embedded on a worksheet. You hyperlink to one of these charts by actually
hyperlinking to a cell under the chart, usually under the top left corner of
the chart. A chart sheet, on the other hand, has no cells, no data other
than the chart. You cannot create a hyperlink to a chart, but you can make a
VBA link that mimics one:
http://peltiertech.com/Excel/Hyperlinks.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Catherine D" wrote in message
...
I am creating a dashboard page to navigate to the sheets in a large Excel
2007 file. How do I create a hyperlink to a chart that is on a separate
worksheet? I cannot find a way to name it or create a cell reference so
that
it appears in the list of linkable items in the Insert Hyperlink dialog
box.
--
BC, Canada