Hi,
I've attached a file as example.
The low-down is that I want users to be able to,
1) Open "Data"-sheet, and paste variable-data for multiple persons in columns U-AY.
2) Open "Results"-sheet, and select either one or a multiple set of "Factors" from "Data"-sheet (columns C-T), via e.g. drop-down lists, which then would automatically populate a scatter plot in the "Results"-sheet (based on the selection of Factors).
Any ideas? Or would it be simpler to just pre-make separate graphs for every possible combination and fetch these based on the drop-down selections (please no...)?
Thanks for your input!
Bookmarks