I have a plot of two lines using excell which intersect at a point. I want to
locate the point of their intersection using excell and show the co-ordinates
of that point so that any body can see that i read that point from it.
Step by step procedurewould be helpful and i am using microsoft excel 2007.
Thanks.

I will assume you have two straight lines - if not please tell me what they
are.

Let the lines follow the two functions
y1=m1x1+b1 and y2=m2x2+b2
Let the point of intersection be Y and X
Then m1X+b1=m2X+b2, giving X=(b2-b1)/(m1-m2)

In Excel terms,
X=(INTERCEPT(y-values2,x-values2)-INTERCEPT(y-values1,x-values1))/(SLOPE(y-values1,x-values1)-SLOPE(y-values2,x-values2))
and Y =SLOPE(y-values1,x-values1)*X+INTERCEPT(y-values1,x-values1)

Put these two formulas in cell A100 and B100
Select A1:B100 and Copy
Click chart; use Edit |Paste Special| specify New Series with X-value in
first cell
Click OK
Now the chart has the point of intersection as a marker.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Nana Adwoa" wrote in message
...
I have a plot of two lines using excell which intersect at a point. I want
to
locate the point of their intersection using excell and show the
co-ordinates
of that point so that any body can see that i read that point from it.
Step by step procedurewould be helpful and i am using microsoft excel
2007.
Thanks.

How can I find the intersection between a logarithmic curve and a straight line?

Thanks.



Bernard Liengme wrote:

I will assume you have two straight lines - if not please tell me what they
30-Aug-07

I will assume you have two straight lines - if not please tell me what they
are.

Let the lines follow the two functions
y1=m1x1+b1 and y2=m2x2+b2
Let the point of intersection be Y and X
Then m1X+b1=m2X+b2, giving X=(b2-b1)/(m1-m2)

In Excel terms,
X=(INTERCEPT(y-values2,x-values2)-INTERCEPT(y-values1,x-values1))/(SLOPE(y-values1,x-values1)-SLOPE(y-values2,x-values2))
and Y =SLOPE(y-values1,x-values1)*X+INTERCEPT(y-values1,x-values1)

Put these two formulas in cell A100 and B100
Select A1:B100 and Copy
Click chart; use Edit |Paste Special| specify New Series with X-value in
first cell
Click OK
Now the chart has the point of intersection as a marker.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Nana Adwoa" wrote in message
...

Previous Posts In This Thread:

On Thursday, August 30, 2007 2:34 PM
NanaAdwo wrote:

How do i locate the point of intersection of two lines graphs
I have a plot of two lines using excell which intersect at a point. I want to
locate the point of their intersection using excell and show the co-ordinates
of that point so that any body can see that i read that point from it.
Step by step procedurewould be helpful and i am using microsoft excel 2007.
Thanks.

On Thursday, August 30, 2007 2:48 PM
Bernard Liengme wrote:

I will assume you have two straight lines - if not please tell me what they
I will assume you have two straight lines - if not please tell me what they
are.

Let the lines follow the two functions
y1=m1x1+b1 and y2=m2x2+b2
Let the point of intersection be Y and X
Then m1X+b1=m2X+b2, giving X=(b2-b1)/(m1-m2)

In Excel terms,
X=(INTERCEPT(y-values2,x-values2)-INTERCEPT(y-values1,x-values1))/(SLOPE(y-values1,x-values1)-SLOPE(y-values2,x-values2))
and Y =SLOPE(y-values1,x-values1)*X+INTERCEPT(y-values1,x-values1)

Put these two formulas in cell A100 and B100
Select A1:B100 and Copy
Click chart; use Edit |Paste Special| specify New Series with X-value in
first cell
Click OK
Now the chart has the point of intersection as a marker.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Nana Adwoa" wrote in message
...


Submitted via EggHeadCafe - Software Developer Portal of Choice
Dr. Dotnetsky's Cool .NET Tips & Tricks # 12
http://www.eggheadcafe.com/tutorials...-cool-net.aspx

What is the equation of the logarithmic line? Different people use different
expression - what do you use?

--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"Maria F" wrote in message ...
How can I find the intersection between a logarithmic curve and a straight
line?

Thanks.



Bernard Liengme wrote:

I will assume you have two straight lines - if not please tell me what
they
30-Aug-07

I will assume you have two straight lines - if not please tell me what
they
are.

Let the lines follow the two functions
y1=m1x1+b1 and y2=m2x2+b2
Let the point of intersection be Y and X
Then m1X+b1=m2X+b2, giving X=(b2-b1)/(m1-m2)

In Excel terms,
X=(INTERCEPT(y-values2,x-values2)-INTERCEPT(y-values1,x-values1))/(SLOPE(y-values1,x-values1)-SLOPE(y-values2,x-values2))
and Y =SLOPE(y-values1,x-values1)*X+INTERCEPT(y-values1,x-values1)

Put these two formulas in cell A100 and B100
Select A1:B100 and Copy
Click chart; use Edit |Paste Special| specify New Series with X-value in
first cell
Click OK
Now the chart has the point of intersection as a marker.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Nana Adwoa" wrote in message
...

Previous Posts In This Thread:

On Thursday, August 30, 2007 2:34 PM
NanaAdwo wrote:

How do i locate the point of intersection of two lines graphs
I have a plot of two lines using excell which intersect at a point. I want
to
locate the point of their intersection using excell and show the
co-ordinates
of that point so that any body can see that i read that point from it.
Step by step procedurewould be helpful and i am using microsoft excel
2007.
Thanks.

On Thursday, August 30, 2007 2:48 PM
Bernard Liengme wrote:

I will assume you have two straight lines - if not please tell me what
they
I will assume you have two straight lines - if not please tell me what
they
are.

Let the lines follow the two functions
y1=m1x1+b1 and y2=m2x2+b2
Let the point of intersection be Y and X
Then m1X+b1=m2X+b2, giving X=(b2-b1)/(m1-m2)

In Excel terms,
X=(INTERCEPT(y-values2,x-values2)-INTERCEPT(y-values1,x-values1))/(SLOPE(y-values1,x-values1)-SLOPE(y-values2,x-values2))
and Y =SLOPE(y-values1,x-values1)*X+INTERCEPT(y-values1,x-values1)

Put these two formulas in cell A100 and B100
Select A1:B100 and Copy
Click chart; use Edit |Paste Special| specify New Series with X-value in
first cell
Click OK
Now the chart has the point of intersection as a marker.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Nana Adwoa" wrote in message
...


Submitted via EggHeadCafe - Software Developer Portal of Choice
Dr. Dotnetsky's Cool .NET Tips & Tricks # 12
http://www.eggheadcafe.com/tutorials...-cool-net.aspx

Here's a step-by-step guide on how to locate the point of intersection of two line graphs in Microsoft Excel 2007:

1. First, make sure that you have plotted both lines on the same graph. If you haven't done so already, select both sets of data and create a line graph.
2. Next, click on one of the data points on the first line. This will select the entire data series.
3. Right-click on the selected data series and choose "Add Trendline" from the drop-down menu.
4. In the "Format Trendline" window that appears, select the "Options" tab.
5. Check the box next to "Display Equation on Chart" and click "Close".
6. Repeat steps 2-5 for the second line.
7. Now, you should see two equations displayed on your chart, one for each line. These equations will be in the form of
   Code:

   "y = mx + b"

   , where "m" is the slope of the line and "b" is the y-intercept.
8. Set the two equations equal to each other and solve for "x". This will give you the x-coordinate of the point of intersection.
9. Once you have the x-coordinate, plug it back into one of the original equations to find the y-coordinate.
10. Finally, add a text box to your chart and type in the coordinates of the point of intersection.

That's it! You should now have the coordinates of the point of intersection displayed on your chart. Let me know if you have any questions or if there's anything else I can help you with.