A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do i locate the point of intersection of two lines graphs



 
 
Thread Tools Display Modes
  #1  
Old August 30th, 2007, 07:34 PM posted to microsoft.public.excel.charting
Nana Adwoa[_2_]
external usenet poster
 
Posts: 1
Default 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.
  #2  
Old August 30th, 2007, 07:48 PM posted to microsoft.public.excel.charting
Bernard Liengme
external usenet poster
 
Posts: 4,085
Default How do i locate the point of intersection of two lines graphs

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.



  #3  
Old December 12th, 2009, 02:48 PM posted to microsoft.public.excel.charting
Maria F
external usenet poster
 
Posts: 1
Default Not straight lines

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
  #4  
Old December 12th, 2009, 10:09 PM posted to microsoft.public.excel.charting
Bernard Liengme
external usenet poster
 
Posts: 4,085
Default Not straight lines

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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:30 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.