Pareto Frontier Chart

Good day,

I would like to ask help in doing a pareto frontier. I have two data sets, one is the load and the other one is the cost. I would like to have a pareto frontier for maximum load and minimum cost. I have attached the data sets I have

I'm not familiar with this kind of chart/analysis, so I'm not sure what to recommend. Most internet searches for Pareto analysis demonstrate a column + line chart type, but I'm not sure that is what you are asking for. I found this old thread https://www.excelforum.com/excel-cha...-frontier.html that shows a Pareto frontier chart as basically an XY scatter chart with two data series -- the main data series plus another series for the "frontier". If this latter is what you are trying to do, it looks like creating the chart should be easy -- create a scatter chart with two data series. You will first need to analyze the data (the chart cannot do it for you) to determine where to draw the frontier. Since you have not explained how you intend to perform that analysis (it isn't obvious to me just looking at the data).

Since you have not performed any analysis in your file, how much of your question is about creating the chart and how much is how to analyze the data?

FYI The OP has seen the old thread as they posted to it before being asked to open this new thread.

@AliGW: I noticed that after I had posted.