Excel Dashboard

**Krix** · 04-01-2015, 03:22 PM

Hi,

I hope I posted it in the correct page.

Can someone please help me with regards to making in Dashboard Navigations, I'm a complete newbie in making this. I did a draft attached to this.

What I want to happen is that all of the Tabs that I created will be just in 1 Sheet (Summary Tab). I used Hyperlink so that it can go through different tab but I want to happen is that Tab 1, Tab 2, etc... will be hidden and just the Summary tab will be visible below.

Thanks in advance for the help!

**simarui** · 04-01-2015, 03:36 PM

are you totally tied to the idea that 'Summary tab' has to be the tab which is visible..? what if pressing one of the buttons were to unhide only the tab relating to the button you pressed and everything else were hidden...? if it's that important that 'Summary Tab' is "visible", what if we renamed the visible tab 'Summary Tab' ... would that be an issue?

another way I can think to do it would be to copy the chart from the selected sheet and paste it into Summary...

another option - probably the best option i.m.o., would be to consolidate all your underlying data on one tab, and then the buttons would direct the summary chart to the correct data / filters etc... that would be the most flexible option - as your reporting requirements grow it would be pretty easy to keep it all straight, all your updates would be done on one tab, you could easily view multiple criteria simultaneously, adding columns / rows would be as easy as that - rather than adding a new tab and creating new code specifically for that tab, and (probably most importantly) the file size could be cut down pretty significantly (assuming the number of agents and criteria grows from here...)

**Krix** · 04-01-2015, 03:52 PM

Hi simarui,

Thank you very much for the quick reply!

All of your options are completely great!

Please see my responses on each point below:

> Actually not that tied to that idea. It's just that I want to hide to others and just the Summary is visible but yeah this idea "what if pressing one of the buttons were to unhide only the tab relating to the button you pressed and everything else were hidden...?"
I want to hide these tabs because I might have more tabs that will be needed, also making it one tab might not be that possible because there are different sets of data that I will input. But once again your idea for this point will really work for me.

> Yes, I already did that to my other Dashboards and I just want something new and learn new stuff in making such Navigation.

> This option is really a good idea though it won't work on my set of data. I will surely apply this to my other Dashboard.

I think I will prefer taking the first idea that you have said. Can you please help me with that? Does that include adding Macro VBA to my spreadsheet?

Best,
Krix

**simarui** · 04-01-2015, 04:43 PM

i don't know any way to do it w/out a little vba... it's pretty straightforward though:

Please Login or Register  to view this content.

and then each of those buttons is assigned to one of those macros as in the attached.

**Krix** · 04-01-2015, 04:51 PM

Thank you very much for your help!

**worthm** · 04-01-2015, 06:50 PM

Here is another completely different idea. I use this in my dashboard. The link below will walk you through the steps to have all of your charts appear in one place on one tab. You click the dropdown and select a chart and it appears

http://chandoo.org/wp/2008/11/05/sel...art-from-many/