M
Moik
I have plotted 2 lines on a graph in Excel 2003 and I want the function that
gives the value of the intersection
gives the value of the intersection
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Curtis
Hi,
if they are trend lines, use the slope and intercept functions to give you
the coefficients for each equation, and then solve for x and y, given that
at the intersection point, x and y will be the same for both lines.
Dave
url:http://www.ureader.com/msg/10296297.aspx
if they are trend lines, use the slope and intercept functions to give you
the coefficients for each equation, and then solve for x and y, given that
at the intersection point, x and y will be the same for both lines.
Dave
url:http://www.ureader.com/msg/10296297.aspx
M
Moik
I have found the slope and the intercept - how do I get excel to solve the
equations?
equations?
D
Dave Curtis
Hi,
If you have the gradient and intercept of the two lines in four cells then
you work out the X coordinate where they cross using
(intercept2-intercept1)/(slope1-slope2)
and the corresponding Y cordinate using
=(Xcoordinate x slope1)+intercept1
Then you can plot these two points as another series on the chart. Let me
know if you get stuck.
Dave
url:http://www.ureader.com/msg/10296297.aspx
If you have the gradient and intercept of the two lines in four cells then
you work out the X coordinate where they cross using
(intercept2-intercept1)/(slope1-slope2)
and the corresponding Y cordinate using
=(Xcoordinate x slope1)+intercept1
Then you can plot these two points as another series on the chart. Let me
know if you get stuck.
Dave
url:http://www.ureader.com/msg/10296297.aspx