Hyperlink to Excel Chart Tab

[Donna]

How do I hyperlink to a chart tab in an Excel file that
contains multiple chart tabs and Sheets. I know you can
hyperlink to a specific sheet by putting a named range in
it, but that doesn't work for Chart tabs

 

[Jon Peltier]

Donna -

You can't do this by a regular Hyperlink, but you can use a simple macro
to activate a chart sheet, as described in my Charting FAQ in the Tech
Trax webzine:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon016

- Jon