• 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


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

Dashboard in Excel


New Member
I was on the excel dashboard training course in January and I am trying to re-create the dashboard – Helpdesk efficiency. Although I have the solution I cannot see how the scroll bar formulas have been done using the ‘helper sheet’. As the numbers change in the helper sheet and I cannot see a formula. I remember there was a hidden formula in the actual dashboard sheet – but I cannot see it to replicate.

Scroll bar output: 1
Drop down output: 1
Maximum drop down: 711
Team drop down output: 4
Period drop down 1
Forecast Drop down 3

Many thanks for pointing me in the right direction.