Hyperlink Address for Charts in Excel?
 

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

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