Hi All,

What I would like to accomplish is to graph 1-3 data sets on the same graph (w/ fixed scale), with the data sets chosen by two drop-down lists. The first list selects a "material", the second chooses an "experiment" which was performed on the material. The chosen selections of the two lists will point to a unique data set, which feeds into the graph. The size of the matrix for materials/experiments is 3x3 at this point, but will grow over time as we add data.

I found this thread, which seems to be close to the last half of what I need (identifying and plotting the data set): http://www.excelforum.com/excel-gene...f-formula.html

I have attached a sample workbook to help visualize. As always, thanks in advance for the help.

sample.xlsx