Hyperlink in Excel to a Chart?

[tanenterp]

Hello,
I am trying to create a Hyperlink within Excel (XP/2002)to a Chart. I am unable to do so. I can not refer to the chart object. Even when I use the Function Builder, it will not let me select the chart. The closest I can do is to imbed a chart on a worksheet, and create a Hyperlink to that worksheet. If you have any suggestions, please let me know.

 

[ETID]

You can save the chart as it's own seperate sheet.

It will be the only object in the sheet.

 

[tanenterp]

Hi, I tried that (It created a new worksheet called "Chart1", but unfortunately, I can't use a hyperlink to reference that sheet.

 

[ETID]

Well I'll be danged....the kinda sucks but there are ways around it.

one would be as you have done already and hide all cols and rows outside of the chart area.

another would be to use vba to hide/show the chart on a button click