• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Unable to move forward with the Dashboard

Hi Excel Gurus,

Please help in creating this dashboard
Given the attached file.



Thanks
Raj
 

Attachments

  • Book1.xlsx
    14.3 KB · Views: 10
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
 
No
But its very simple VBA
You don't need to understand it too much
 
Hi Hui,

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


Thanks
Raj
 
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
upload_2014-11-14_17-55-13.png

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
 
Back
Top