View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default intersection point

Using both lines as linear the answer is x = 1.35, y = 88.7

I added both lines into a chart and added a trendline to both graphs to get
the following equations

y=80x-20
y=15x + 68.33. this line it was difficult to dtermine if I shoud use a
linear approximation or some other approximation.

then I solved manually for x and y

80x-20 = 15x + 68.33
65x = 88.33
x = 1.3589

y= 80x - 20
y = 80 * (1.3589) - 20
y = 1.35

"pmss" wrote:

Hello

Some one can help me to find the intersection point between two lines. One
line is irregular and another is straight. For example I have given here two
lines here . I have to find out the intersection point between these two
lines. Thank YOu

First Line
x y
0 80
5 105
15 110
25 120
35 160
50 150
Second Line
x y
0 60
25 140

Pmss