In this tutorial, you will learn how to plot an equation in Excel.
There are many different ways to define an equation. The definition of an equation in algebra is a mathematical statement that demonstrates the equality of two mathematical expressions. For instance, the equation 3x + 5 = 14 consists of the two equations 3x + 5 and 14, which are separated by the ‘equal’ sign. Mathematical algebraic equations typically have one or more variables.
Once you are ready, we can get started by using real-life scenarios to help you understand how to plot an equation in Excel.
Table of Contents
Plot an Equation
Before we begin we will need a group of data to be used to plot an equation in Excel.
Step 1
Make sure your group of data is displayed in a clean and tidy manner in the first sheet.
Step 2
In this example, we will find the value Y using this equation =2*X – 5. To find the value Y, we will put this formula =2*A2 – 5.
Step 3
Once you are done, your excel will look like this.
Step 4
Now we can plot the values into a scatter chart.
