Determine intersection point of two lines on chart

[doublej41]

Hi All,

I have a chart set up that plots 3 data series'. One is some user input data and the other two are upper and lower tolerances.

Is there an easy way to get the y-axis value at the points where the user data intersects either of the tolerances? They may intersect more than once so I would need all points to be able to determine the maximum y-axis value.

I would preferably like to stay away from VBA.

Thanks

 

[YamahaG22]

ComplexIntersection.xls
	W
13
Sheet1

 

[YamahaG22]

ComplexIntersection.xls
	N	O	P	Q	R	S	T
1	STRAIN	STRESS	OFFSET STRAIN	0.2% OFFSET STRESS	INTERSECTIONS	X	Y
2	0.00000	0.0000	0.00200	0.0000
3	0.01053	12.9404	0.01253	12.9404		#VALUE!	#VALUE!
4	0.01061	12.9404	0.01261	12.9404		#VALUE!	#VALUE!
5	0.01070	12.9404	0.01270	12.9404		#VALUE!	#VALUE!
6	0.01078	12.9404	0.01278	12.9404		#VALUE!	#VALUE!
7	0.01087	12.9404	0.01287	12.9404		#VALUE!	#VALUE!
8	0.01095	12.9404	0.01295	12.9404		#VALUE!	#VALUE!
9	0.01104	12.9404	0.01304	12.9404		#VALUE!	#VALUE!
10	0.01112	12.9404	0.01312	12.9404		#VALUE!	#VALUE!
11	0.01121	12.9404	0.01321	12.9404		#VALUE!	#VALUE!
12	0.01129	12.9404	0.01329	12.9404		#VALUE!	#VALUE!
13	0.01138	12.9404	0.01338	12.9404		#VALUE!	#VALUE!
14	0.01145	12.9404	0.01345	12.9404		#VALUE!	#VALUE!
15	0.01154	12.9404	0.01354	12.9404		#VALUE!	#VALUE!
16	0.01163	12.9404	0.01363	12.9404		#VALUE!	#VALUE!
17	0.01172	15.5285	0.01372	15.5285		#VALUE!	#VALUE!
18	0.01180	15.5285	0.01380	15.5285		#VALUE!	#VALUE!
19	0.01188	15.5285	0.01388	15.5285		#VALUE!	#VALUE!
20	0.01197	15.5285	0.01397	15.5285		#VALUE!	#VALUE!
21	0.01205	15.5285	0.01405	15.5285		#VALUE!	#VALUE!
22	0.01214	15.5285	0.01414	15.5285		#VALUE!	#VALUE!
23	0.01222	15.5285	0.01422	15.5285		#VALUE!	#VALUE!
24	0.01231	15.5285	0.01431	15.5285		#VALUE!	#VALUE!
25	0.01239	15.5285	0.01439	15.5285		#VALUE!	#VALUE!
26	0.01248	18.1166	0.01448	18.1166		#VALUE!	#VALUE!
27	0.01256	18.1166	0.01456	18.1166		#VALUE!	#VALUE!
28	0.01264	18.1166	0.01464	18.1166		#VALUE!	#VALUE!
29	0.01273	18.1166	0.01473	18.1166		#VALUE!	#VALUE!
30	0.01281	18.1166	0.01481	18.1166		#VALUE!	#VALUE!
31	0.01290	18.1166	0.01490	18.1166		#VALUE!	#VALUE!
32	0.01298	18.1166	0.01498	18.1166		#VALUE!	#VALUE!
33	0.01307	20.7047	0.01507	20.7047		#VALUE!	#VALUE!
34	0.01315	20.7047	0.01515	20.7047		#VALUE!	#VALUE!
35	0.01324	20.7047	0.01524	20.7047		#VALUE!	#VALUE!
36	0.01332	23.2928	0.01532	23.2928		#VALUE!	#VALUE!
37	0.01341	23.2928	0.01541	23.2928		#VALUE!	#VALUE!
38	0.01349	23.2928	0.01549	23.2928		#VALUE!	#VALUE!
39	0.01357	25.8808	0.01557	25.8808		#VALUE!	#VALUE!
40	0.01366	25.8808	0.01566	25.8808		#VALUE!	#VALUE!
41	0.01375	25.8808	0.01575	25.8808		#VALUE!	#VALUE!
42	0.01383	28.4689	0.01583	28.4689		#VALUE!	#VALUE!
43	0.01391	28.4689	0.01591	28.4689		#VALUE!	#VALUE!
44	0.01400	28.4689	0.01600	28.4689		#VALUE!	#VALUE!
45	0.01408	31.0570	0.01608	31.0570		#VALUE!	#VALUE!
46	0.01417	31.0570	0.01617	31.0570		#VALUE!	#VALUE!
47	0.01425	31.0570	0.01625	31.0570		#VALUE!	#VALUE!
48	0.01433	33.6451	0.01633	33.6451		#VALUE!	#VALUE!
49	0.01442	33.6451	0.01642	33.6451		#VALUE!	#VALUE!
50	0.01451	33.6451	0.01651	33.6451		#VALUE!	#VALUE!
51	0.01459	36.2332	0.01659	36.2332		#VALUE!	#VALUE!
52	0.01468	36.2332	0.01668	36.2332		#VALUE!	#VALUE!
53	0.01476	36.2332	0.01676	36.2332		#VALUE!	#VALUE!
54	0.01485	38.8213	0.01685	38.8213		#VALUE!	#VALUE!
55	0.01493	38.8213	0.01693	38.8213		#VALUE!	#VALUE!
56	0.01501	38.8213	0.01701	38.8213		#VALUE!	#VALUE!
57	0.01510	41.4093	0.01710	41.4093		#VALUE!	#VALUE!
58	0.01519	41.4093	0.01719	41.4093		#VALUE!	#VALUE!
59	0.01527	41.4093	0.01727	41.4093		#VALUE!	#VALUE!
60	0.01536	43.9974	0.01736	43.9974		#VALUE!	#VALUE!
61	0.01544	43.9974	0.01744	43.9974		#VALUE!	#VALUE!
62	0.01552	43.9974	0.01752	43.9974		#VALUE!	#VALUE!
63	0.01561	46.5855	0.01761	46.5855		#VALUE!	#VALUE!
64	0.01569	46.5855	0.01769	46.5855		#VALUE!	#VALUE!
65	0.01578	49.1736	0.01778	49.1736		#VALUE!	#VALUE!
66	0.01586	49.1736	0.01786	49.1736		#VALUE!	#VALUE!
67	0.01595	49.1736	0.01795	49.1736		#VALUE!	#VALUE!
68	0.01603	51.7617	0.01803	51.7617		#VALUE!	#VALUE!
69	0.01611	51.7617	0.01811	51.7617		#VALUE!	#VALUE!
70	0.01619	54.3498	0.01819	54.3498		#VALUE!	#VALUE!
71	0.01629	54.3498	0.01829	54.3498		#VALUE!	#VALUE!
72	0.01637	54.3498	0.01837	54.3498		#VALUE!	#VALUE!
73	0.01645	56.9378	0.01845	56.9378		#VALUE!	#VALUE!
74	0.01653	56.9378	0.01853	56.9378		#VALUE!	#VALUE!
75	0.01662	59.5259	0.01862	59.5259		#VALUE!	#VALUE!
76	0.01671	59.5259	0.01871	59.5259		#VALUE!	#VALUE!
77	0.01680	62.1140	0.01880	62.1140		#VALUE!	#VALUE!
78	0.01688	62.1140	0.01888	62.1140		#VALUE!	#VALUE!
79	0.01697	62.1140	0.01897	62.1140		#VALUE!	#VALUE!
80	0.01705	64.7021	0.01905	64.7021		#VALUE!	#VALUE!
81	0.01713	64.7021	0.01913	64.7021		#VALUE!	#VALUE!
82	0.01722	67.2902	0.01922	67.2902		#VALUE!	#VALUE!
83	0.01730	67.2902	0.01930	67.2902		#VALUE!	#VALUE!
84	0.01739	67.2902	0.01939	67.2902		#VALUE!	#VALUE!
85	0.01747	69.8783	0.01947	69.8783		#VALUE!	#VALUE!
86	0.01756	69.8783	0.01956	69.8783		#VALUE!	#VALUE!
87	0.01764	69.8783	0.01964	69.8783		#VALUE!	#VALUE!
88	0.01773	72.4663	0.01973	72.4663		#VALUE!	#VALUE!
89	0.01781	72.4663	0.01981	72.4663		#VALUE!	#VALUE!
90	0.01789	75.0544	0.01989	75.0544		#VALUE!	#VALUE!
91	0.01798	75.0544	0.01998	75.0544		#VALUE!	#VALUE!
92	0.01806	77.6425	0.02006	77.6425		#VALUE!	#VALUE!
93	0.01815	77.6425	0.02015	77.6425		#VALUE!	#VALUE!
94	0.01823	80.2306	0.02023	80.2306		#VALUE!	#VALUE!
95	0.01832	80.2306	0.02032	80.2306		#VALUE!	#VALUE!
96	0.01840	82.8187	0.02040	82.8187		#VALUE!	#VALUE!
97	0.01848	82.8187	0.02048	82.8187		#VALUE!	#VALUE!
98	0.01857	85.4068	0.02057	85.4068		#VALUE!	#VALUE!
99	0.01865	87.9948	0.02065	87.9948		#VALUE!	#VALUE!
100	0.01874	87.9948	0.02074	87.9948		#VALUE!	#VALUE!
101	0.01882	90.5829	0.02082	90.5829		#VALUE!	#VALUE!
102	0.01891	90.5829	0.02091	90.5829		#VALUE!	#VALUE!
103	0.01899	93.1710	0.02099	93.1710		#VALUE!	#VALUE!
104	0.01908	95.7591	0.02108	95.7591		#VALUE!	#VALUE!
105	0.01917	95.7591	0.02117	95.7591		#VALUE!	#VALUE!
106	0.01925	98.3472	0.02125	98.3472		#VALUE!	#VALUE!
107	0.01934	100.9353	0.02134	100.9353		#VALUE!	#VALUE!
108	0.01942	103.5233	0.02142	103.5233		#VALUE!	#VALUE!
109	0.01950	103.5233	0.02150	103.5233		#VALUE!	#VALUE!
110	0.01959	106.1114	0.02159	106.1114		#VALUE!	#VALUE!
111	0.01967	108.6995	0.02167	108.6995		#VALUE!	#VALUE!
112	0.01976	111.2876	0.02176	111.2876		#VALUE!	#VALUE!
113	0.01985	111.2876	0.02185	111.2876		#VALUE!	#VALUE!
114	0.01993	113.8757	0.02193	113.8757		#VALUE!	#VALUE!
115	0.02001	116.4638	0.02201	116.4638		#VALUE!	#VALUE!
116	0.02009	119.0518	0.02209	119.0518		#VALUE!	#VALUE!
117	0.02018	121.6399	0.02218	121.6399		#VALUE!	#VALUE!
118	0.02027	124.2280	0.02227	124.2280		#VALUE!	#VALUE!
119	0.02035	126.8161	0.02235	126.8161		#VALUE!	#VALUE!
120	0.02043	129.4042	0.02243	129.4042		#VALUE!	#VALUE!
121	0.02052	131.9923	0.02252	131.9923		#VALUE!	#VALUE!
122	0.02061	134.5803	0.02261	134.5803		#VALUE!	#VALUE!
123	0.02069	137.1684	0.02269	137.1684		#VALUE!	#VALUE!
124	0.02077	139.7565	0.02277	139.7565		#VALUE!	#VALUE!
125	0.02086	142.3446	0.02286	142.3446		#VALUE!	#VALUE!
126	0.02095	144.9327	0.02295	144.9327		#VALUE!	#VALUE!
127	0.02103	147.5208	0.02303	147.5208		#VALUE!	#VALUE!
128	0.02111	150.1088	0.02311	150.1088		#VALUE!	#VALUE!
129	0.02120	152.6969	0.02320	152.6969		#VALUE!	#VALUE!
130	0.02128	157.8731	0.02328	157.8731		#VALUE!	#VALUE!
131	0.02137	160.4612	0.02337	160.4612		#VALUE!	#VALUE!
132	0.02145	163.0493	0.02345	163.0493		#VALUE!	#VALUE!
133	0.02154	165.6373	0.02354	165.6373		#VALUE!	#VALUE!
134	0.02162	168.2254	0.02362	168.2254		#VALUE!	#VALUE!
135	0.02170	173.4016	0.02370	173.4016		#VALUE!	#VALUE!
136	0.02179	175.9897	0.02379	175.9897		#VALUE!	#VALUE!
137	0.02188	178.5778	0.02388	178.5778		#VALUE!	#VALUE!
138	0.02196	181.1658	0.02396	181.1658		#VALUE!	#VALUE!
139	0.02204	186.3420	0.02404	186.3420		#VALUE!	#VALUE!
140	0.02213	188.9301	0.02413	188.9301		#VALUE!	#VALUE!
141	0.02221	191.5182	0.02421	191.5182		#VALUE!	#VALUE!
142	0.02229	196.6943	0.02429	196.6943		#VALUE!	#VALUE!
143	0.02238	199.2824	0.02438	199.2824		#VALUE!	#VALUE!
144	0.02247	201.8705	0.02447	201.8705		#VALUE!	#VALUE!
145	0.02255	207.0467	0.02455	207.0467		#VALUE!	#VALUE!
146	0.02264	209.6348	0.02464	209.6348		#VALUE!	#VALUE!
147	0.02272	214.8109	0.02472	214.8109		#VALUE!	#VALUE!
148	0.02281	217.3990	0.02481	217.3990		#VALUE!	#VALUE!
149	0.02289	222.5752	0.02489	222.5752		#VALUE!	#VALUE!
150	0.02297	225.1633	0.02497	225.1633		#VALUE!	#VALUE!
151	0.02306	230.3394	0.02506	230.3394		#VALUE!	#VALUE!
152	0.02314	232.9275	0.02514	232.9275		#VALUE!	#VALUE!
153	0.02323	235.5156	0.02523	235.5156		#VALUE!	#VALUE!
154	0.02331	240.6918	0.02531	240.6918		#VALUE!	#VALUE!
155	0.02340	243.2798	0.02540	243.2798		#VALUE!	#VALUE!
156	0.02348	248.4560	0.02548	248.4560		#VALUE!	#VALUE!
157	0.02357	251.0441	0.02557	251.0441		#VALUE!	#VALUE!
158	0.02365	256.2203	0.02565	256.2203		#VALUE!	#VALUE!
159	0.02373	258.8083	0.02573	258.8083		#VALUE!	#VALUE!
160	0.02382	263.9845	0.02582	263.9845		#VALUE!	#VALUE!
161	0.02391	266.5726	0.02591	266.5726		#VALUE!	#VALUE!
162	0.02399	271.7488	0.02599	271.7488		#VALUE!	#VALUE!
163	0.02408	274.3368	0.02608	274.3368		#VALUE!	#VALUE!
164	0.02416	279.5130	0.02616	279.5130		#VALUE!	#VALUE!
165	0.02425	282.1011	0.02625	282.1011		#VALUE!	#VALUE!
166	0.02433	287.2773	0.02633	287.2773		#VALUE!	#VALUE!
167	0.02441	289.8653	0.02641	289.8653		#VALUE!	#VALUE!
168	0.02450	292.4534	0.02650	292.4534		#VALUE!	#VALUE!
169	0.02458	297.6296	0.02658	297.6296		#VALUE!	#VALUE!
170	0.02467	300.2177	0.02667	300.2177		#VALUE!	#VALUE!
171	0.02475	305.3938	0.02675	302.8057		#VALUE!	#VALUE!
172	0.02484	307.9819	0.02684	307.9819		#VALUE!	#VALUE!
173	0.02492	310.5700	0.02692	310.5700		#VALUE!	#VALUE!
174	0.02501	315.7462	0.02701	315.7462		#VALUE!	#VALUE!
175	0.02509	318.3343	0.02709	318.3342		#VALUE!	#VALUE!
176	0.02517	320.9223	0.02717	323.5104		#VALUE!	#VALUE!
177	0.02526	326.0985	0.02726	326.0985		#VALUE!	#VALUE!
178	0.02535	328.6866	0.02735	331.2747		#VALUE!	#VALUE!
179	0.02543	331.2747	0.02743	333.8627		#VALUE!	#VALUE!
180	0.02552	333.8628	0.02752	336.4508		#VALUE!	#VALUE!
181	0.02560	336.4508	0.02760	341.6270		#VALUE!	#VALUE!
182	0.02568	341.6270	0.02768	344.2151		#VALUE!	#VALUE!
183	0.02577	344.2151	0.02777	346.8031		#VALUE!	#VALUE!
184	0.02585	346.8032	0.02785	351.9793		#VALUE!	#VALUE!
185	0.02594	349.3913	0.02794	354.5674		#VALUE!	#VALUE!
186	0.02602	351.9793	0.02802	359.7436		#VALUE!	#VALUE!
187	0.02611	354.5674	0.02811	362.3316		#VALUE!	#VALUE!
188	0.02619	357.1555	0.02819	367.5078		#VALUE!	#VALUE!
189	0.02628	359.7436	0.02828	370.0959		#VALUE!	#VALUE!
190	0.02636	362.3317	0.02836	375.2721		#VALUE!	#VALUE!
191	0.02645	364.9198	0.02845	377.8601		#VALUE!	#VALUE!
192	0.02653	367.5078	0.02853	380.4482		#VALUE!	#VALUE!
193	0.02662	367.5078	0.02862	385.6244		#VALUE!	#VALUE!
194	0.02670	370.0959	0.02870	388.2125		#VALUE!	#VALUE!
195	0.02678	372.6840	0.02878	390.8005		#VALUE!	#VALUE!
196	0.02687	375.2721	0.02887	395.9767		#VALUE!	#VALUE!
197	0.02695	375.2721	0.02895	398.5648		#VALUE!	#VALUE!
198	0.02704	377.8602	0.02904	403.7410		#VALUE!	#VALUE!
199	0.02713	380.4483	0.02913	406.3290		#VALUE!	#VALUE!
200	0.02721	380.4483	0.02921	411.5052		#VALUE!	#VALUE!
201	0.02729	383.0363	0.02929	414.0933		#VALUE!	#VALUE!
202	0.02738	383.0363	0.02938	419.2695		#VALUE!	#VALUE!
203	0.02746	385.6244	0.02946	421.8575		#VALUE!	#VALUE!
204	0.02754	385.6244	0.02954	424.4456		#VALUE!	#VALUE!
205	0.02763	388.2125	0.02963	429.6218		#VALUE!	#VALUE!
206	0.02772	388.2125	0.02972	432.2099		#VALUE!	#VALUE!
207	0.02780	390.8006	0.02980	434.7979		#VALUE!	#VALUE!
208	0.02789	390.8006	0.02989	439.9741		#VALUE!	#VALUE!
209	0.02797	390.8006	0.02997	442.5622		#VALUE!	#VALUE!
210	0.02805	393.3887	0.03005	447.7384		#VALUE!	#VALUE!
211	0.02814	393.3887	0.03014	450.3264		#VALUE!	#VALUE!
212	0.02823	393.3887	0.03023	455.5026		#VALUE!	#VALUE!
213	0.02831	393.3887	0.03031	458.0907		#VALUE!	#VALUE!
214	0.02839	395.9768	0.03039	463.2669		#VALUE!	#VALUE!
215	0.02848	395.9768	0.03048	465.8549		#VALUE!	#VALUE!
Sheet1

Cell Formulas
Range	Formula
S3:S215	S3	=Intersectcomplex(N3,O3,N4,O4,LINEB,TRUE)
T3:T215	T3	=Intersectcomplex(P3,Q3,P4,Q4,LINEB,FALSE)