This probably sounds familiar, but I have been rifling through google and herd all day to find a solution. Here is some background information:
The spreadsheet is for trend analysis on tests. You put in the class number, number of students, and what version of the test they are on(there are 3 versions, A is what they all take, B is what they take if they fail A, etc...). Next you put in what the students put as answers(multiple choice A-D) for each question for each student. When finished you click a submit button that flushes the information to start filling in a data array. The sheet calculates avg class score and what percent of the class got the wrong answer for each question.
Now onto the fun stuff. I am eventually going to have 2 separate charts, one to trend class average, and one to trend the wrong answers. For now let's focus on the class avg as this will be simple.
What I want to do is have the graph be able to show me data for individual classes or every class that has been entered based on two drop down boxes, one selecting the version of the test and one selecting either a specific class or all classes. I already have named dynamic ranges for those scenarios, I just need a way to make the spreadsheet change what named ranges the chart is using based on those drop boxes. Formulas or VBA are fair game. Thanks!
The spreadsheet is for trend analysis on tests. You put in the class number, number of students, and what version of the test they are on(there are 3 versions, A is what they all take, B is what they take if they fail A, etc...). Next you put in what the students put as answers(multiple choice A-D) for each question for each student. When finished you click a submit button that flushes the information to start filling in a data array. The sheet calculates avg class score and what percent of the class got the wrong answer for each question.
Now onto the fun stuff. I am eventually going to have 2 separate charts, one to trend class average, and one to trend the wrong answers. For now let's focus on the class avg as this will be simple.
What I want to do is have the graph be able to show me data for individual classes or every class that has been entered based on two drop down boxes, one selecting the version of the test and one selecting either a specific class or all classes. I already have named dynamic ranges for those scenarios, I just need a way to make the spreadsheet change what named ranges the chart is using based on those drop boxes. Formulas or VBA are fair game. Thanks!
