Unable to move forward with the Dashboard

[rush2rajen]

Hi Excel Gurus,

Please help in creating this dashboard
Given the attached file.



Thanks
Raj

 

[Hui]

See attached
You forgot to setup a ValSelOption named formula as well as use some simple VBA which is required
See the original post description at:
http://chandoo.org/wp/2011/07/20/interactive-dashboard-using-hyperlinks/

 

[rush2rajen]

Hi Hui,

Thanks a lot. I was trying to make it on my own but unable as I dont know VBA. I Thought that by using simple formula I can do so.

Is there any other way ?

Thanks
Raj

 

[Hui]

No
But its very simple VBA
You don't need to understand it too much

 

[rush2rajen]

Hi Hui,

Can you please help with the VBA. And whats the procedure to use and where the code should be written.


Thanks
Raj

 

[Hui]

Open the file I sent you, Enable Content & Macros if asked
Press Alt+F11
Your now in VBA
The code is in
Click on Module 1


This module is what gets ran when you hover over the Arrows in Excel
It sets a Named Range "velSelOption" to the name of the series eg: Pat, PBT etc

To go back to Excel Alt+F11

You can copy / paste this code to another worksheet if required.

There is also a Named Formula "valSelOption" which must be setup in the Name Manager
valSelOption: =Sheet1!$O$8

 

[rush2rajen]

Thanks a lot Hui