Graph 1.(measurement)
(1,3), (3,5), (5, 9), (7, 13)

Graph 2.(measurement)
(2,3), (4,7), (6, 11), (8, 19)


Graph 3.(calculation)
(1, y1/y2), (2, y1/y2), (3, y1/y2), (4, y1/y2)

where y1 and y2 is obtained by first drawing a trendline, finding it's
equation and then substituting the x value to find the corresponding y
value. The two y values corresponding to a particular x is then found.
The ratio of the two y values is then calculated. Finally a third graph
is drawn.

The whole process is tedious. Is there a simpler way?


--
labview1958
------------------------------------------------------------------------
labview1958's Profile: http://www.excelforum.com/member.php...o&userid=32123
View this thread: http://www.excelforum.com/showthread...hreadid=542878