Regarding Xcel

  • Thread starter Thread starter rchennag
  • Start date Start date
R

rchennag

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?
 
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
 
Back
Top