Intersection of two lines
 

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!

Answer: Intersection of two lines
 

Yes, there is a way to get the exact intersection point of two lines in Excel. Here are the steps:

1. First, make sure that you have the equations for the two lines that you want to find the intersection of. You can do this by adding the trendline equation to the chart. To do this, right-click on the data series and select "Add Trendline". In the "Trendline Options" menu, check the box next to "Display Equation on chart". This will add the equation to the chart.
   
2. Next, you need to find the intersection point of the two lines. To do this, you can use the
   Formula:

   ---

   Solver 


   ---

   add-in in Excel. If you don't have the Solver add-in installed, you can install it by going to "File" "Options" "Add-Ins" "Excel Add-ins" "Solver Add-in" "OK".
   
3. Once you have the Solver add-in installed, select the two cells where you want to display the intersection point. Then, go to "Data" "Solver". In the "Solver Parameters" dialog box, set the "Set Objective" to "Value of" and enter "0" in the box next to it. Then, set the "By Changing Variable Cells" to the two cells you selected earlier. Finally, set the "Subject to the Constraints" to the equations of the two lines. To do this, click on the "Add" button and enter the first equation in the "Cell Reference" box and the second equation in the "Constraint" box. Click "OK" to close the "Add Constraint" dialog box.
   
4. Click "Solve" to find the intersection point. Excel will adjust the values in the two cells you selected until the two equations are equal, which will give you the intersection point.

That's it! You should now have the exact intersection point of the two lines.

Intersection of two lines
 

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/ti...efficients.htm

Cheers
Andy

akr wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

Intersection of two lines
 

By solving equations. This will be simple if the lines are linear - tell us
more
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"akr" wrote in message
...
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!