Hello All,
I have set up an excel dashboard for staffing. I inserted a form control scroll bar and need it to scroll left to right to view previous months but I can get it to only scroll up and down. My formula to gather my data is: =OFFSET('Staffing Data'!B3,Financials!$R$40,,) with R40 being the linked cell to the scroll bar. How can I change the scroll bar to go from left to right to read previous months?
I have set up an excel dashboard for staffing. I inserted a form control scroll bar and need it to scroll left to right to view previous months but I can get it to only scroll up and down. My formula to gather my data is: =OFFSET('Staffing Data'!B3,Financials!$R$40,,) with R40 being the linked cell to the scroll bar. How can I change the scroll bar to go from left to right to read previous months?
| Nov-13 | Oct-13 | ||||||||
| Dept. # | Description | E | S | T | TOTAL | E | S | T | TOTAL |
| 21290 | Contract | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 1 |
| 21400 | Trim | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 4 |
| 21401 | Mini-Shift Inventory Control | 6 | 1 | 2 | 9 | 6 | 1 | 4 | 11 |