Andy, this worked great for spreadsheet 1. Then, I made spreadsheet 2, as a
copy of 1, but with different data. Now, when I click the hyperlink in
spreadsheet 2, it takes me to a completly different place in the workbook. I
have tried deleting and recreating the link. The link dialog has the correct
references. It just doesn't work. It's weird. Spreadsheet 1 still works fine.

Any thoughts?


"Andy Pope" wrote:

Hi,

Jon Peltier has information on hyperlinks and charts.
http://peltiertech.com/Excel/Hyperlinks.html

Cheers
Andy

Roney wrote:
I know there must be a simple way to do this.. I'm just not all that good at
excel.

I have a pre-created chart. I want to put that chart on a sheet and, when
the user clicks a "show chart" link, in another sheet in the same workbook,
simply have that chart display. How can I do that?

Thanks a lot

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info