Intersection of two lines

[Guest]

Hey. I used the scatterplot to make a chart of 4 trendlines. And now I need
to get the exact intersection of each pair. The only ways I can do it is (1)
go through the data itself and find the exact intersection point - which is
very slow.. or (2) bring my mouse arrow as closet to the intersection point
on the graph and get an estimate.

Is there a way to get the exact intersection point? Perhaps by selecting the
two lines I want the intersection of .. etc?
Thank you!

 

[Andy Pope]

Hi,

I have some information on plotting the intersecting points of lines.
http://www.andypope.info/charts/intersection.htm

If the lines are true chart trend lines then you will need to have a
look that these sites for information on getting trend line points.
Bernard V Liengme's www.stfx.ca/people/bliengme
Tushar Mehta's Trendline coefficients
http://www.tushar-mehta.com/excel/tips/trendline_coefficients.htm

Cheers
Andy

 

[Bernard Liengme]

By solving equations. This will be simple if the lines are linear - tell us
more
best wishes