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.
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.