How to Plot an Equation in Excel

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.

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.