View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You can't hyperlink to the chart sheet, but Jon Peltier has a macro
workaround in his Charting FAQ article:


http://pubs.logicalexpressions.com/P...?ID=209#jon016


that you may be able to use.




me wrote:
Hi, I can hyperlink to cell A1 in a worksheet using this format:
Book1.xls#Sheet1!A1
byt I can't figure out how to name a chart or create a bookmark to a chart
"worksheet" or chart object so I can hyperlink to either. Is this possible
and, if so, how do you do it?

Thanks,
Mike




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html