Prev: Print Preview
Next: Can't open my 2003 excel files on 2007
From: rchennag on 5 Mar 2010 12:11
HI there, i plotted xy scatter graph for Amplitude Vs Depth and now i need
to draw a curve/line using maximum points. How can i do that?
From: SatelliteMax on 5 Mar 2010 12:49
I put in a helper column, starting one line below the top of your data, and
ending one above your last line. I then put in e.g. line G2
=IF(AND(F1<F2,F3<F2),F2,FALSE)
Then copy down.
This makes a column with only the maximum values, similar for minimum values.

You could also track the last maximum
=IF(AND(F1>F2,F3>F2),F2,F1)

satellitemax

Y
"rchennag" wrote:

> HI there, i plotted xy scatter graph for Amplitude Vs Depth and now i need
> to draw a curve/line using maximum points. How can i do that?
 | 
Pages: 1
Prev: Print Preview
Next: Can't open my 2003 excel files on 2007