View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default How do you create a hyperlink to a chart within an Excel 2007 docu

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