Hello Everyone,

I am new to the forum, so please accept my apologies if I am not posting on the correct section.

I am working on a Scatter chart that has 2 sets of data (x1,y1) and (x2,y2). At some point this 2 curves will meet. I have used google, youtube and all forums (including this one, but couldn't find any solution for this (I must confess that don't really know if this is possible.

So basically these 2 curves will be represented by for instance:

First Set of data:

x2 y2
0.06 1.5
0.09 3.375
0.12 6
0.15 9.375
0.18 13.5
0.21 18.375
0.24 24
0.27 30.375
0.3 37.5
0.33 45.375
0.36 54
0.39 63.375
0.42 73.5
0.45 84.375
0.48 96
0.51 108.375
0.54 121.5
0.57 135.375
0.6 150
0.63 165.375
0.66 181.5
0.69 198.375
0.696 201.84
0.72 216
0.75 234.375
0.78 253.5
0.81 273.375
0.84 294
0.87 315.375
0.9 337.5
0.93 360.375
0.96 384
0.99 408.375
1.02 433.5

Second set of data:

x1 y2
0.00 947
0.10 878
0.20 797
0.30 716
0.40 613
0.50 491
0.60 331
0.70 110
0.80 -93
0.85
0

Now, by looking at the scattered graph, where I can see the 2 lines crossing, I can easily see that both curves will meet each other on (0.665,184)

But, is there a way of finding this point by the use of some formulas?

I have attached an image showing these 2 lines.
image forum.PNG

Thank you very much for your help with this.

Kind regards,
Trevor