Happy New Year Everyone!
I am having an issue with my report and I am not sure how to go about it. I have an excel report with 20 tabs and the 1st Tab is the summary overview tabs which has a few pivot charts. What I would like to do is when you click on the pivot chart on the summary page it should take you to the tab where the pivot table is located for that chart. E.g. first pivot chart summarises shoes sales in FY16, the pivot table that houses that information is on tab 3, so if someone clicks on this pivot chart on the summary page, they will be taken to tab 3.
Thank you so much in advance for your help
Kind regards
Zeni
I am having an issue with my report and I am not sure how to go about it. I have an excel report with 20 tabs and the 1st Tab is the summary overview tabs which has a few pivot charts. What I would like to do is when you click on the pivot chart on the summary page it should take you to the tab where the pivot table is located for that chart. E.g. first pivot chart summarises shoes sales in FY16, the pivot table that houses that information is on tab 3, so if someone clicks on this pivot chart on the summary page, they will be taken to tab 3.
Thank you so much in advance for your help
Kind regards
Zeni