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.