Hi guys,
I have a simple dashboard with four worksheet tabs. The first tab is the dashboard with many different charts that I would like to link to many different tables in two hidden sheets. I would like to have from the Dashboard, all the individual project doughnut charts linked to its corresponding tables in Planned Project List worksheet and all the individual initiative doughnut charts linked to its corresponding Planned Initiative List worksheet.
As a simple dashboard, once completed I would like to hide all tabs except for the Dashboard and have the hyperlinks to the Planned Project List worksheet and Planned Initiative worksheet still working.
I have Googled and tried several different macros found in forums but it still does not seem to work. I could be doing things wrongly as this is my first Excel attempting any macros, would appreciate any advise, thanks!
I have a simple dashboard with four worksheet tabs. The first tab is the dashboard with many different charts that I would like to link to many different tables in two hidden sheets. I would like to have from the Dashboard, all the individual project doughnut charts linked to its corresponding tables in Planned Project List worksheet and all the individual initiative doughnut charts linked to its corresponding Planned Initiative List worksheet.
As a simple dashboard, once completed I would like to hide all tabs except for the Dashboard and have the hyperlinks to the Planned Project List worksheet and Planned Initiative worksheet still working.
I have Googled and tried several different macros found in forums but it still does not seem to work. I could be doing things wrongly as this is my first Excel attempting any macros, would appreciate any advise, thanks!