Hi,

You can not hyperlink to a chartsheet without resorting to vba code.
See Jon Peltier's page on the subject.
http://peltiertech.com/Excel/Hyperlinks.html

Cheers
Andy

ashfire wrote:
hi

i have a spreadsheet that has the tabs Front Page, Graphs, S1 Graphs, S2
Graphs.

On the front page i have headings (with this weeks totals in a cell
underneath) that represent the graphs. I would like to click this heading and
then be directed straight to the coressponding graph.
I tried Hyperlink but that didnt work
Is this easliy possible or do i need to make a macro ?

--

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