Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Nancy
 
Posts: n/a
Default Graphing Linear Equations

I am soo sorry and I feel stupid but I can not figure out how to get excell
to just graph a plain Y=mX+b line. I have been trying to figure it out for
hours... please help.
  #2   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

Excel does not directly plot functions, instead it plots data points
consisting of x-y pairs. Put x values in one column and calculate the
relevant y-values in the next column. Since 2 points determine a
straight line, it is sufficient to enter just the desired endpoints of
the line.

Select both columns and Insert|Chart. Select the "XY (Scatter)" chart
type with a chart subtype that connects data points with lines.

Jerry

Nancy wrote:

I am soo sorry and I feel stupid but I can not figure out how to get excell
to just graph a plain Y=mX+b line. I have been trying to figure it out for
hours... please help.


  #3   Report Post  
Tushar Mehta
 
Posts: n/a
Default

As Jerry pointed out, XL doesn't do equations. An add-in I wrote,
however, does. Check
PLOT manager
http://www.tushar-mehta.com/excel/so...ger/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I am soo sorry and I feel stupid but I can not figure out how to get excell
to just graph a plain Y=mX+b line. I have been trying to figure it out for
hours... please help.

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
Graphing Database Growth Rate DavidM Charts and Charting in Excel 1 February 2nd 05 12:01 AM
Graphing Woze? Arlen Excel Discussion (Misc queries) 4 January 26th 05 10:19 PM
Working with array equations OkieViking Excel Discussion (Misc queries) 2 January 23rd 05 07:43 AM
calculate non linear equation lines using excel Dawn Excel Discussion (Misc queries) 3 January 10th 05 01:09 PM
trendline - request power --> get linear CR Optiker Excel Worksheet Functions 1 October 28th 04 11:02 PM


All times are GMT +1. The time now is 06:04 AM.

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

About Us

"It's about Microsoft Excel"