Using Excel 2007
I have a worksheet with multiple columns with rows going into the 11,000's. I am wanting to make drop down boxes for 3 of the columns and one column to pick a date range...and all feed a chart. (it has to be a chart..not a pivot table).
this work sheet has multiple dates ...and craft skill...and area they worked...and type of charge it is....so say I want to pick a date range from 4-1-12 to 4-30-12 for a helper that worked in area LOG FM and was charged to MX07........I could then see this crafts straight time hours divided by over time hours in a percent format.
for example I would like to have a date range plug in cell A1 4-1-12 and in cell A2 4-30-12....which would read the dates in column A3 on down to A11,000
Once the range is picked I could now start picking the critieria in my 3 drop down boxes. One drop down references column C3 thru C11,000 (Craft)....the next drop down reference is N3 thru N11,000 (area)....and the final one O3 thru O11,000 (charge type).
Once I make these choices the results of columns H (straight time hours) & J (overtime hours) show up in a chart in a percent format.
I hope I explained myself well.....its seems complicated when I read it but basically its multiple drop down boxes feeding a chart (i can make drop down boxes and charts....its just figuring out how to set it all up is the hard part for me.)
I would like to point out that column C (craft) has a lot of repeatative values...as does N (area) and O (charge type)
I was thinking I'd have to make a a unique list for the items in column C...and then take it from there...I don't know...I'm just guessing.
I also looked up array formulas to make a unique list of column C but it bogs down my excel....thats as far as I got.
I have a worksheet with multiple columns with rows going into the 11,000's. I am wanting to make drop down boxes for 3 of the columns and one column to pick a date range...and all feed a chart. (it has to be a chart..not a pivot table).
this work sheet has multiple dates ...and craft skill...and area they worked...and type of charge it is....so say I want to pick a date range from 4-1-12 to 4-30-12 for a helper that worked in area LOG FM and was charged to MX07........I could then see this crafts straight time hours divided by over time hours in a percent format.
for example I would like to have a date range plug in cell A1 4-1-12 and in cell A2 4-30-12....which would read the dates in column A3 on down to A11,000
Once the range is picked I could now start picking the critieria in my 3 drop down boxes. One drop down references column C3 thru C11,000 (Craft)....the next drop down reference is N3 thru N11,000 (area)....and the final one O3 thru O11,000 (charge type).
Once I make these choices the results of columns H (straight time hours) & J (overtime hours) show up in a chart in a percent format.
I hope I explained myself well.....its seems complicated when I read it but basically its multiple drop down boxes feeding a chart (i can make drop down boxes and charts....its just figuring out how to set it all up is the hard part for me.)
I would like to point out that column C (craft) has a lot of repeatative values...as does N (area) and O (charge type)
I was thinking I'd have to make a a unique list for the items in column C...and then take it from there...I don't know...I'm just guessing.
I also looked up array formulas to make a unique list of column C but it bogs down my excel....thats as far as I got.
