View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
glasbergenm
 
Posts: n/a
Default Chart with three variables


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
------------------------------------------------------------------------
glasbergenm's Profile: http://www.excelforum.com/member.php...o&userid=31001
View this thread: http://www.excelforum.com/showthread...hreadid=506690