Closed Thread
Results 1 to 6 of 6

how do I graph a linear equation?

  1. #1
    Throstle
    Guest

    how do I graph a linear equation?

    I want to graph the linear equation y = 2x + 4 in microsoft excel. How do I
    do this? On my TI-83 Plus I could easily do this. I also know I could create
    a data table and use the table of values to chart the line in excel. But I
    want just enter the equation in excel and have excel graph it. Thanks.

  2. #2
    Del Cotter
    Guest

    Re: how do I graph a linear equation?

    On Sun, 9 Jan 2005, in microsoft.public.excel.charting,
    Throstle <[email protected]> said:

    >I want to graph the linear equation y = 2x + 4 in microsoft excel. How do I
    >do this? On my TI-83 Plus I could easily do this. I also know I could create
    >a data table and use the table of values to chart the line in excel. But I
    >want just enter the equation in excel and have excel graph it. Thanks.


    You need only two points to define a straight line. Create a
    spreadsheet that takes the minimum and maximum values of x, and the
    values of a and b, and calculates just two values of y, and you will
    have forever more a spreadsheet that will give you a graph of y=ax+b
    whenever you want.

    --
    Del Cotter
    Thanks to the recent increase in UBE, I will soon be ignoring email
    sent to [email protected]. Please send your email to del2 instead.

  3. #3
    John Mansfield
    Guest

    RE: how do I graph a linear equation?

    Throstle,

    In addition to plotting the points by solving for X and Y, you can also have
    Excel automatically do this via the use of defined names as a data source for
    your chart. This link provides an explanation on how to chart a function:

    http://www.pdbook.com/index.php/exce...rt_a_function/

    ----
    Regards,
    John Mansfield
    http://www.pdbook.com


    "Throstle" wrote:

    > I want to graph the linear equation y = 2x + 4 in microsoft excel. How do I
    > do this? On my TI-83 Plus I could easily do this. I also know I could create
    > a data table and use the table of values to chart the line in excel. But I
    > want just enter the equation in excel and have excel graph it. Thanks.


  4. #4
    Bernard Liengme
    Guest

    Re: how do I graph a linear equation?

    In A1:A10 enter some x-values (say 1,2,.....)
    In B1 enter =2*A1+4
    Copy this down to B10
    Select A1:B10; click the chart wizard, and select an XY (NOT a Line) chart

    best wishes


    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "Throstle" <[email protected]> wrote in message
    news:[email protected]...
    >I want to graph the linear equation y = 2x + 4 in microsoft excel. How do I
    > do this? On my TI-83 Plus I could easily do this. I also know I could
    > create
    > a data table and use the table of values to chart the line in excel. But I
    > want just enter the equation in excel and have excel graph it. Thanks.




  5. #5
    Registered User
    Join Date
    09-09-2004
    Posts
    3

    Re: how do I graph a linear equation?

    i want graph in excel with linear graph but y values fixed. how i can get the linear equation in microsoft excel. Then i have planning this graph can do movement simulation to right.
    Thanks

  6. #6
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: how do I graph a linear equation?

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

Closed Thread

Thread Information

Users Browsing this Thread

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

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