# How to make y=mx+c in Excel

A linear equation in mathematical subjects usually produces a line graph when mapped on a spreadsheet. The equation takes the form y = MX + b, where m is the gradient of the line and b is the y-intercept. In this case, C can also apply. Microsoft 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 mathematical equation/function already labeled in two X and Y columns with column headers. You will then follow the following simple steps in this article that prepare you to make the graph in Excel.

1. Insert a set of values in column A.

2. Insert another set of values in column B.

3. Select all boxes containing the data without including the titles. This is in order to set the data range.

4. Click on Insert then click on Scatter.

5. Select the opening option.

6. Right-click on your mouse in the graph then click Series 1>Edit. Ensure that Xand Y values are properly selected.

7. Go to the Chart Tools and click on Layout Tab.

8. Click on Axis Titles and type the titles on both axes. The units of these titles MUST be correctly indicated.

9. Click on Chart Title in order to add the title for the whole worksheet.

10. Right-click on your datapoints> Select 'Add Trendline'. This will drag a straight line through your data.

11. Click on 'Linear Regression'. Click on 'Set intercept' and add zero 0 on the box if your plots go through the origin.

12. Click on 'Show equation' in order to ensure your equation is in the form y=mx+c.

13. In order to adjust the axis, right-click on the axis the select "Format axis'

ALTERNATIVELY, you may also follow the simple steps laid out below.

1. Open a blank spread/ worksheet on Excel.

2. Enter the data in columns A and B.

3. Highlight the data points.

4. Click on 'Insert'.

5. Click 'Chart' >Chart Wizard >Click XY (scatter)

6. Click 'Finish'. At this point, a plotted graph or chart will appear.

7. Right-click on the blue slope then Add Trendline.

8. Go to Options Tab and click OK.