+ Reply to Thread
Results 1 to 4 of 4

How to determinate intersection of two points

  1. #1
    Registered User
    Join Date
    10-10-2018
    Location
    Ljubljana
    MS-Off Ver
    2019
    Posts
    1

    How to determinate intersection of two points

    Hello!

    I've created the graph with two series. Each of them have their own trend line. I've extended the trend line, but i don't know how can I calculated the intersection of the trend lines. Yo can see below the image.
    Untitled-1.jpg
    Can anyone help me? I need it for school.

    Thanks!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: How to determinate intersection of two points

    Hi, welcome to the forum

    Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

    We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

    If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: How to determinate intersection of two points

    Two straight lines -- it should be a simple "solve a system of linear equations" type of problem that you learned in secondary algebra. I would suggest that you review a tutorial such as this one: https://www.purplemath.com/modules/systlin1.htm
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: How to determinate intersection of two points

    Thanks MrShorty, my algebra is really rusty lol

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 01-25-2021, 04:07 PM
  2. [SOLVED] Intersection of 2 Perpendicular Lines - Apparent Error in Intersection Coordinates
    By Paddy_Bear in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 10-03-2018, 03:36 AM
  3. Replies: 10
    Last Post: 09-09-2015, 10:07 AM
  4. Need Help Regarding Points of intersection in graph.
    By rajiv3888 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-05-2012, 09:50 AM
  5. Plot Values at Points of Intersection (x, y1, y2)
    By AlvaroSiza in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-14-2012, 04:20 PM
  6. Excel 2007 : Intersection points
    By mvfelice in forum Excel General
    Replies: 1
    Last Post: 12-12-2009, 10:04 AM
  7. [SOLVED] How to find intersection points between lines using Excel?
    By Saurabh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-16-2006, 12:55 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1