Depending on the data, you might be able to turn the data into a pivot
table, with your X values in the row area, the third variable in the column
area, and the Y values in your data area. If the third variable is a
continuous variable, you may get reasonable results if you group the values
in this field.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
"glasbergenm"
wrote in message
...
I've 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 seperate serie of
all data with the same third variable. Is there an easier way to create
such a chart?
--
glasbergenm