Typically, attaching your current work is far more informative than a description.

If I understand correctly, you have 8 inputs. These are ceiling form, ceiling material, lightshelf shape, and 5 others. Each of these may have two or more values of some sort e.g. lightshelf shape has two values (i.e. is binary). These 8 inputs lead to one output: daylight performance.

At any rate, such analysis is best suited to a "design of experiment" (DOE). IMHO, graphical analysis using Excel will be difficult since it is basically 8 dimensions of independent variables leading to the 9th dimension dependent variable. Statistical software (e.g. Minitab) would give the precise answer for optimizing the inputs.

Less precisely, perhaps there is some way to use Excel. But again, your sheet would be helpful.

Gebbos, Thanks for the response, you understood me correctly, also I uploaded a sample file , all variables are explained at the top , the number of the configurations will be the product of all variables 2x3x3x3x3xx2x2x2= 1296. the sample file I uploaded has two rows only, however my real file will have 1296 rows. I couldn't upload the real file because I'm still working on it.

Attached Files

Sample file.xlsx (10.2 KB, 10 views)

I forgot to mention that I prefer to divide the data into two groups. One group with flat lightshelf, and the other group with curved lightshelf. then put each group in some kind of a graph or plot.