Hi everyone,
I work in the Architectural design field, and I'm testing about 30 designs/ configurations to optimize the building's thermal, and lighting performance. I have an Excel sheet with three columns, the first column has a configuration name (text), the second column has each configuration's temperature value (number between 30 to 45 C degree, this number should be minimized) and the third column has each configuration's lighting value (number between 0 to 100 lux, which should be maximized ). Is it possible to create a Pareto frontier in Excel (I attached an example image) to pick the most optimized configuration. The ultimate solution should have the lowest temperature and highest lighting value. Here is a quick example

Configuration 1, 30, 80
Configuration 2, 35, 60
configuration 3, 45, 95
pareto frontier Google SearchSearch completed.png

Thanks