+ Reply to Thread
Results 1 to 6 of 6

Multiple equation graph help

  1. #1
    Registered User
    Join Date
    11-17-2018
    Location
    Canada
    MS-Off Ver
    Office 16
    Posts
    2

    Post Multiple equation graph help

    I have these two formulas:
    x+y=10
    x-y=-1
    I have to graph these two get the point where they intersect (x,y) as the answer. Can anyone help me.
    Thanks

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Multiple equation graph help

    That's an algebra problem, not an Excel problem.

    Add the two formulas to eliminate y, solve for x, and plug that value into either formula to get y.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    11-17-2018
    Location
    Canada
    MS-Off Ver
    Office 16
    Posts
    2

    Re: Multiple equation graph help

    In that case, can you use solver for this equation?

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

    Re: Multiple equation graph help

    I'm sure Solver could be used for solving systems of linear equations, but there are much better algebraic techniques (that can be programmed into Excel). I would suggest a quick review of your secondary math about solving systems of equations. I find these to be decent tutorials: 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.

  5. #5
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Multiple equation graph help

    ...I have to graph these...
    solve each eqn for y
    in Excel, enter a range of values for some -x to +x
    in col's B and C enter the formulas corresponding to the y solutions above with the X cells as y values
    Attached Files Attached Files
    Last edited by protonLeah; 11-18-2018 at 04:08 PM.
    Ben Van Johnson

  6. #6
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Multiple equation graph help

    As the OP asked for a solver solution:

    solv_graph.jpg

    And as the values for X and Y are set by the constraint there is no need to set the objective.

    solv_graph_sol.jpg

    Alf

+ 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. Using an equation in a header for a graph...
    By EverGreen1231 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-24-2015, 12:39 PM
  2. how do I graph a linear equation?
    By Throstle in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-16-2011, 05:04 AM
  3. [SOLVED] Is there a way to display a graph using a equation?
    By pokdbz in forum Excel General
    Replies: 1
    Last Post: 01-12-2006, 10:45 AM
  4. Turning an equation into a graph
    By Steffi in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-29-2005, 09:05 AM
  5. How do I graph an equation?
    By CHEM FEMME in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-15-2005, 03:05 PM
  6. [SOLVED] Graph an Equation
    By Michael Kintner in forum Excel General
    Replies: 2
    Last Post: 01-20-2005, 02:06 PM
  7. [SOLVED] Graph an Equation
    By Michael Kintner in forum Excel General
    Replies: 1
    Last Post: 01-18-2005, 10:06 AM

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