In a spreadsheet, how do you link from one worksheet to another one which is solely a chart.
Scenario: I'm making a contents page for this spreadsheet. I want to be able to link each one to the relevant page. This is no problem for normal worksheets, just the whole "#'worksheet name'!cell reference" thing. But now because there are no cells in a chart sheet, I can't do this.