how do I graph a linear equation?

=?Utf-8?B?VGhyb3N0bGU=?=
Guest
Posts: n/a

 10th Jan 2005
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.

Del Cotter
Guest
Posts: n/a

 10th Jan 2005
On Sun, 9 Jan 2005, in microsoft.public.excel.charting,
Throstle <(E-Mail Removed)> 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

=?Utf-8?B?Sm9obiBNYW5zZmllbGQ=?=
Guest
Posts: n/a

 10th Jan 2005
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.

Bernard Liengme
Guest
Posts: n/a

 10th Jan 2005
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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.

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post BRB Microsoft Excel Misc 3 22nd Aug 2008 07:26 PM Statistical interest Microsoft Excel Misc 2 7th Feb 2008 12:01 AM =?Utf-8?B?VGVyZW5Zb3VuZw==?= Microsoft Excel Charting 1 15th Jun 2006 09:29 AM =?Utf-8?B?U2FuamF5IEt1bWFyIFNpbmdo?= Microsoft Excel Charting 1 3rd Jan 2006 01:22 PM Ebodski Microsoft Excel New Users 1 3rd Mar 2004 05:05 PM

Features