I have made hundreds of runs with a computer model. With every run, two of the variables are changed, resulting in a new number (third variable). I want to make a chart, with the first variable on the x-axis and the second variable on the y-axis. The point in the chart needs to have, besides the x and y-value, the value of the third variable. Through the points with the same third variable, a trendline has to be drawn. Because there are several hundreds of model runs, I don't want to sort the data manually on the third variable and make a separate series of all data with the same third variable. Is there an easier way to create such a chart.
Bookmarks