stanl
05-01-2014, 02:05 PM
I am creating an Excel tab from an Access crosstab query that indicates call dispositions by hour, i,e,
Hour Dispo1 Dispo2 Dispo3
8-9am 10 4 29
9-10am 22 22 6
etc....
The dispositions are generic and perhaps one might be missing or added on a given day.
I have a separate tab with a simple bar chart showing say Dispo3 numbers per hour. What I would like to do given the Hours are constant, is create some sort of dropdown so the user could select the Dispo and the chart would be re-drawn. I'm hoping someone has done something similar and can give me pointers.
TIA
Stan
Hour Dispo1 Dispo2 Dispo3
8-9am 10 4 29
9-10am 22 22 6
etc....
The dispositions are generic and perhaps one might be missing or added on a given day.
I have a separate tab with a simple bar chart showing say Dispo3 numbers per hour. What I would like to do given the Hours are constant, is create some sort of dropdown so the user could select the Dispo and the chart would be re-drawn. I'm hoping someone has done something similar and can give me pointers.
TIA
Stan