Hyperlinking to Charts in Excel

Hi Julia

Thanks for getting in touch. This is one of those weird quirks of Excel that has been around for a long time. The short answer is you can't do it via Hyperlinks, but you can do it with a macro.

Furthermore, you can't do it with just text - you will have to create a shape. If you need it to fit in with your existing menu / control panel you could create a rectangle and then format it to the same as the background of your worksheet.

Right-click the shape and choose Assign Macro. Choose New.

You will get a screen that says something like this:

Sub AutoShape1_Click()

End Sub

And in the gap in between the two lines you will need to enter a line of code like this:

Charts("Chart1").Activate

...replacing Chart1 with the name of your sheet.

Back the other way, you will need to create a further object on your chart to get back to other sheets.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector