Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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(F1F2,F3F2),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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy an XCEL sheet? | Excel Discussion (Misc queries) | |||
Xcel | Setting up and Configuration of Excel | |||
xcel file | Excel Discussion (Misc queries) | |||
colums in xcel | Excel Discussion (Misc queries) | |||
xcel question | Excel Discussion (Misc queries) |