How to Graph Linear Equations Using Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Excel can graph linear functions.

A linear equation produces a line graph. The equation takes the form y = mx + b, where m is the slope and b is the y intercept. Excel cannot draw linear equations directly; in order to graph a linear equation in Excel, you must have a table of at least two values for the function already preformatted in two (X, Y) columns with column headers.

Advertisement

Excel 2007

Video of the Day

Step 1

Highlight the data you want to graph by clicking at the top left of the data and dragging the mouse to the bottom right.

Video of the Day

Step 2

Click on the "Insert" tab.

Advertisement

Step 3

Select "Line graph" and choose "2-D Line." Excel will draw the graph for the linear equation based on the table of values you input.

Excel 2003

Step 1

Highlight the data you want to graph by clicking at the top left of the data and dragging the mouse to the bottom right.

Advertisement

Advertisement

Step 2

Click on the "Chart Wizard" in the toolbar.

Step 3

Choose "Line."

Step 4

Check the "Chart subtype" box and click "Next" three times to move through the rest of the chart wizard.

Step 5

Click on "Finish." Excel will graph your linear equation using the values from your table.

Advertisement

Advertisement

references