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.
Buckskinner wrote:
Help!
I have a sprawling Excel spreadsheet.
All my charts are on their own sheets.
I have created a summary page with links to various areas of the file.
When I try to put an internal hyperlink in for a chart on its own sheet
I can't! The standalone charts don't come up in the browser window
from which you add the hyperlink address/location.
Is there any way to get a cell reference for a chart that was created
by selecting the "As a New Sheet" option?
Kris
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html