Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
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   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: How do i locate the point of intersection of two lines graphs

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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4,393
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.



  #4   Report Post  
Posted to microsoft.public.excel.charting
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
  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4,393
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Intersection of two lines akr Charts and Charting in Excel 3 April 4th 23 12:39 PM
intersection of 2 graphs utopian_sorceror Charts and Charting in Excel 6 October 31st 08 03:13 PM
Intersection point return data tvtime Excel Worksheet Functions 20 July 27th 06 07:20 PM
Marking point of intersection on double y axis chart? TheBigLoofah Charts and Charting in Excel 1 February 23rd 06 12:06 AM
Intersection point in graphs rk0909 Excel Discussion (Misc queries) 4 October 28th 05 09:44 PM


All times are GMT +1. The time now is 10:40 AM.

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

About Us

"It's about Microsoft Excel"