Excel users are frequently interested in how to graph a linear equation or a function in Excel. Fortunately, this is simple to accomplish using Excel’s built-in formulae. This lesson shows you how to visualize equations/functions in Excel.
Download Practice Workbook
You can download the practice workbook from the following download button.
What Is a Linear Equation?
A linear equation is a two-variable equation that produces a straight line when plotted on a graph. A one-degree equation is another name for it. A linear equation with two variables is of the following form:
Steps to Graph a Linear Equation in Excel
Step 1: Find Value of Dependent Variable
Assume we would like to graph the following equation: y = 3x + 5. The figure below explains how to produce the values of dependent variables for this linear equation in Excel, using an x-value range of 1 to 10:
- Imagine we were assigned the x values shown in the illustration. We have now input the following equation to obtain the y values that correspond to the supplied x values:
- Now, we have to drag the fill handle to complete the data range.
Read More: How to Get Y Equation on Excel Graph (6 Ways)
Step 2: Select Range and Choose a Suitable Graph Type
- Then, select the values from B4 to C9. And choose the Insert tab. Select the Scatter plot option from the Charts category.
- The corresponding plot will be generated automatically:
Read More: How to Graph Two Equations in Excel (with Easy Steps)
How to Plot a Linear Equation in Excel Starting from No Data
Sometimes, we may create a graph in Excel without utilizing data to observe the behavior of that graph. In this section, we have discussed that.
📌 Steps:
- Now we will plot an equation that has the following general formula:
- Now, in cell E5, type the formula:
=(B5*C5)+D5- Next, press Enter.
- Because we haven’t yet entered the cell values, it will return 0.
- First of all, select the range C4:C9.
- Then, press and hold down the Ctrl key.
- After that, select the range E4:E9.
- The following figure will make it clear for you.
- Subsequently, go to the Insert tab.
- After that like the below image go to Scatter plot.
- As a result, you’ll obtain the graph. However, because we have an empty dataset, there will be no plotting for the time being.
- First of all, place the value of m as 5 for all the cases.
- Then, type your desired values for the independent variable x.
- Similarly, insert the value of c as 3.
- At last, apply the AutoFill tool for getting the outcomes of the range E5:E9.
- Hence, it’ll return the accurate outputs for the y variable.
- Look at the below dataset to realize better.
Read More: How to Create Equation from Data Points in Excel
How to Add Equation to a Linear Graph of Excel
Using the excel equation of a line, we may add an equation to a plot in Excel. Excel graph equation is simple to plot, and this article will lead all categories of Excel users through the procedure of displaying a linear equation and integrating it into a plot.
📌 Steps:
- Our data will be tabulated in two columns. We will next pick the “scatter chart” button to display a graph after selecting our complete table and clicking “insert.”
- To edit our graph, we will now click on the “+” symbol next to the chart and then Trendline to More Options…
- After the sidebar appears in Excel, we will now add the chart’s equation finally by selecting “Display Equation on Chart.“
- Now the equation of the formula appears in the graph shown in the red box. This usually helps the users when they are bound to demonstrate only graphs in their projects.
Read More: How to Display Equation of a Line in Excel Graph (2 Easy Ways)
Conclusion
Follow these steps and stages to graph a linear equation in Excel. You are welcome to download the workbook and use it for your own practice. If you have any questions, concerns, or suggestions, please leave them in the comments section. For more such articles, you can visit our blog ExcelDemy.
