I want to find the lowest point on the plotted line in a graph.

[Edwin]

Hi,

I want to find the lowest point on the plotted line in XY
(Scatter) graph. I have many points scattered above and below the line. I
need the lowest point on the line and not the lowest point on the graph.

 

[Andy Pope]

Hi,

We need more detail about the line and your data points?
Is the line a simple horizontal line, a slope or a undulating line?

Cheers
Andy

 

[Edwin]

My data goes like this....


Wavelength Reflectance
1.41031100 1.00000000
1.41456030 1.00730900
1.41880900 1.00271200
1.42305520 0.99717342
1.42730020 0.99491340
1.43154400 1.00421100
1.43578510 1.00572700
1.44002500 1.00555100
1.44426220 1.00190800
1.44849800 0.99687270
1.45273120 1.00728200
1.45696230 1.00442400
1.46119100 1.00411700
1.46541730 0.99875330
1.46964130 1.00069700
1.47386240 1.00720710
1.47808100 0.99957090
1.48229700 1.00256000
1.48651000 0.99874401
1.49072000 0.99349150
1.49492640 0.99516420
1.49913030 0.99254720
1.50333100 1.00190200
1.50752840 1.00502500
1.51172240 0.99433310
1.51591320 1.00179130
1.52010040 0.99739682
1.52428400 1.00302800
1.52846400 1.00278430
1.53264000 1.00130640
1.53681300 0.99739370
1.54098110 1.00198130
1.54514600 1.00109940
1.54930630 1.00035210
1.55346300 1.00454110
1.55761530 1.00712400
1.56176340 1.00456720
1.56590730 1.00159230
1.57004700 0.99807912
1.57418200 0.99814963
1.57831230 0.99496573
1.58243840 0.99337870
1.58656000 0.99022901
1.59067640 0.98909032
1.59478830 0.99581230
1.59889530 0.99047020
1.60299800 0.99668043
1.60709500 0.98920792
1.61118700 0.99033260
1.61527400 0.98805690
1.61935600 0.98469364
1.62343300 0.94975160
1.62750410 1.00184000
1.63157030 0.98318564
1.63563120 0.99386334
1.63968700 0.99652410
1.64373630 0.99543590
1.64778100 0.99885170
1.65181940 0.99255073
1.65585240 1.00103130
1.65988000 0.99659730
1.66390140 0.99383740
1.66791720 0.98416334
1.67192700 0.98946360
1.67593100 0.99612760
1.67992910 0.98815292
1.68392100 0.98895263
1.68790700 0.99256130
1.69188700 1.00024600
1.69586030 0.98420830
1.69982800 0.97677791
1.70378900 0.99096232
1.70774400 0.97930340
1.71169230 0.98352211
1.71563500 0.98155832
1.71957010 0.97911640
1.72350000 0.97440160
1.72742210 0.97632170
1.73133800 0.98802983
1.73524800 0.98454934
1.73915100 0.97637010
1.74304700 0.99241250
1.74693630 0.98723512
1.75081900 0.98950920
1.75469500 0.98729133
1.75856400 0.98296993
1.76242600 0.98035842
1.76628130 0.98106050
1.77013000 0.97978280
1.77397100 0.98077052
1.77780600 0.97373992
1.78163300 0.97427833
1.78545330 0.97317171
1.78926620 0.97411102
1.79307210 0.97496032
1.79687110 0.97482722
1.80066300 0.97658640
1.80444720 0.98265391
1.80822500 0.97973072
1.81199440 0.97553801
1.81575720 0.99108612
1.81951230 0.97638520
1.82326010 0.97590250
1.82700100 0.99264103
1.83073410 0.98182612
1.83446000 0.99608150
1.83817820 0.99160403
1.84188900 0.96485800
1.84559240 0.98213320
1.84928820 1.01379100
1.85297640 1.00362710
1.85665800 0.98655414
1.86033100 0.99347030
1.86399620 0.98808340
1.86765430 1.00362120
1.87130500 0.98086380
1.87494800 0.98435312
1.87858300 0.97569500
1.88221010 1.00361830
1.88583010 1.02838700
1.88944230 0.99473154
1.89304700 0.98222994
1.89664400 0.99874621
1.90023300 0.99554961
1.90381410 0.99708843
1.90738800 0.99296860
1.91095320 0.98097872
1.91451200 1.00458600
1.91806200 0.98774182
1.92160500 0.98181040
1.92514000 0.97863572
1.92866640 0.97229130
1.93218600 0.98009461
1.93569730 0.97511830
1.93920100 0.98462021
1.94269700 0.98836700
1.94618500 0.98922070
1.94966600 0.98729592
1.95313810 0.99808820
1.95660300 0.99180352
1.96006010 0.98311600
1.96350920 0.98257064
1.96695100 0.99595890
1.97038420 0.97459420
1.97381010 0.97006770
1.97722840 0.98190990
1.98063900 0.97310382
1.98404140 0.97836380
1.98743640 0.98073190
1.99082330 0.97218173
1.99420300 0.97618484
1.99757500 0.98695150
2.00093840 0.97614110
2.00429500 0.96935300
2.00764340 0.97647452
2.01098410 0.97575521
2.01431800 0.98111800
2.01764300 0.97415840
2.02096100 0.95497010
2.02427120 0.96043074
2.02757400 0.97136241
2.03086900 0.97177630
2.03415700 0.96666570
2.03743640 0.97628873
2.04070900 0.98258841
2.04397400 0.98076772
2.04723100 0.97407311
2.05048100 0.98324882
2.05372330 0.98370230
2.05695840 0.97949880
2.06018610 0.97883552
2.06340620 0.98932272
2.06661910 0.98822400
2.06982440 0.97535230
2.07302230 0.96722970
2.07621330 0.97328920
2.07939700 0.98046790
2.08257310 0.97845941

2.08890500 0.98697550
2.09205900 0.98003390
2.09520640 0.97351741
2.09834700 0.98936010
2.10148000 0.98625770
2.10460710 0.98824411
2.10772600 0.98923093
2.11083810 0.98426630
2.11394420 0.99010664
2.11704300 0.98526580
2.12013430 0.97541280
2.12321920 0.98058650
2.12629700 0.97950590
2.12936830 0.98536372
2.13243300 0.98052300
2.13549100 0.98377010
2.13854240 0.98596614
2.14158700 0.98425600
2.14462500 0.98722732
2.14765620 0.98380994
2.15068100 0.98388330
2.15370030 0.98394060
2.15671200 0.98594150
2.15971800 0.98532490
2.16271820 0.99214142
2.16571110 1.00118100
2.16869800 0.99681103
2.17167940 0.98479050
2.17465400 0.99188820
2.17762300 0.99193320
2.18058530 0.99258450
2.18354220 0.99662512
2.18649330 0.98398420
2.18943800 0.98640644
2.19237700 0.98627221
2.19531030 0.97441060
2.19823800 0.98421174
2.20116100 0.99076533
2.20407700 0.99201640
2.20698710 0.98799043
2.20989340 0.98986550
2.21279310 0.98265171
2.21568800 0.98907180
2.21857710 0.97628861
2.22146100 0.98729110
2.22433940 0.97324400
2.22721330 0.97987320
2.23008200 0.97851010
2.23294600 0.99637790
2.23580400 0.98305690
2.23865800 0.99209934
2.24150630 0.99492472
2.24435010 0.98588901
2.24719040 0.99211943
2.25002500 0.97653140
2.25285500 0.97905534
2.25568100 0.99893190
2.25850220 0.98158430
2.26131900 0.98559640
2.26413200 1.00220530
2.26694000 0.98232000
2.26974410 0.97749870
2.27254430 0.98761940
2.27534030 0.97583030
2.27813300 0.98757050
2.28092100 0.97247254
2.28370540 0.99908800
2.28648610 0.99099332
2.28926300 0.98058384
2.29203740 1.00855500
2.29480700 0.98969820
2.29757330 0.98292400
2.30033800 0.98287272
2.30309720 0.99351733
2.30585430 0.98464330
2.30860800 0.99410420
2.31135820 0.97270834
2.31410640 0.99154890
2.31685200 0.98594552
2.31959400 0.98485034
2.32233400 0.97852212
2.32507010 0.98101884
2.32780500 0.98811650
2.33053700 0.99209451
2.33326600 0.98210930
2.33599420 0.97663750
2.33871900 0.99641841
2.34144200 0.99233450
2.34416400 0.97456830



2.35503000 0.98247563
2.35774230 1.00221000
2.36045400 0.99349200
2.36316340 1.00221300
2.36587230 0.99868920
2.36857900 1.00824600
2.37128600 0.99376980
2.37399100 0.98873984
2.37669500 0.99556332
2.37939900 0.97559350
2.38210200 1.00261900
2.38480400 0.97499160
2.38750700 0.97789931
2.39020800 0.98741412
2.39290920 0.99435310
2.39561100 1.00292500
2.39831100 1.00726420
2.40101210 0.98700910
2.40371400 0.99748190
2.40641540 0.99355804
2.40911800 0.98442430
2.41181900 1.00596600
2.41452210 1.00274000
2.41722600 0.98593230

 

[Andy Pope]

Care to explain your data and what the low point value would be?
Is that xy values or 2 lines with default x values?

There are a few gaps in the data you posted are these true gaps of just
email formatting problems?

Cheers
Andy

 

[Bernard Liengme]

Edwin:
I copied the first block to a worksheet in range A1:B179 (row 1 had labels)
I made an an XY chart of the data
In E2 I used the formula =MIN(B2:B179)
In D2 I used =INDEX(A2:A179,MATCH(E2,B2:B179,0))
This gives me the X and Y values on the minimum point
I selected and copied D2:E2; clicked the chart; used Edit | Paste Special
and specified New Series & X-category in First Column. This plotted the
point on the chart in a different color (on top of the old point)
Send me private email is you wish a file showing this
I am a chemist