Julia has attended:
Excel Advanced course
PowerPoint Intermediate Advanced course
Hyperlinking to Charts in Excel
Hello,
I am trying to create a contents page in a rather large and consequently ungainly report I create monthly in excel.
I use a Nielsen piece of software called Nitro to generate charts in this report. This creates charts which sit on a page as if you had made a chart normally in excel and used the 'move' function to give it its own page with no accessibility to the actual cells on that sheet.
Excel will not allow me to hyperlink to this page.
Any ideas for how to get round this to be able to allow for a contents page to improve navigation?
Any suggestions will be very gratefully received. Do let me know if you need clarification.
Regards,
Julia
RE: 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
