Frequently, we need to plot an ** equation** in Excel. Fortunately, it is quite simple and easy to get this in Excel. In this article, I will show you six easy ways on how to plot

**in an Excel graph. Hence, read the article properly and save time.**

*equations***Table of Contents**hide

## Download Practice Workbook

You can download the workbook used for the demonstration from the download link below.

## 6 Easy Ways to Plot an Equation in Excel

From the Excel graph, you can plot** equations** for various types of equations. Generally, it includes linear equations, exponential equations, logarithmic equations, polynomials, power equations, and moving averages. However, I will demonstrate to you all of them step by step with a sample dataset as below.

### 1. Plotting Linear Equation

Generally, ** linear equations** are the most common type of equation in Excel. We use them on a regular basis. Moreover, it is best for linear data. For the purpose of demonstration, we have used the following equation.

`y = 5x + 3`

Now, follow the steps accordingly.

**Steps:**

- Firstly, write down the following formula into the formula bar according to the sample equation.

`=5*B5+3`

- Now, press
and use the*Enter*tool to apply the formula to the whole column.*AutoFill*

- Secondly, select any cell within the data and click the
tab.*Insert* - Next, click on the
command from the*Scatter*group of commands.*Charts* - After that, a drop-down menu will appear; select the first one, which is simply the
.*Scatter chart*

- As a result, a chart will appear. However, select the chart and click on the
symbol.*+* - After that, click on the
as shown below.*Chart Elements*

- From the
, select*Format Trendline*and*Linear*.*Display Equation on Chart*

- Finally, you will get the
below.*Linear Equation*

**Read More:** **How to Autocomplete Cells or Columns From List in Excel**

### 2. Making Equation in Excel Graph for Exponential

Another type of equation that we can plot in an Excel graph is the ** exponential equation**. It is not only quite simple but also easy to plot. Hence, follow the equation and sample dataset mentioned below, which I have used to plot the

**.**

*exponential equation*`y = e^x`

**Steps:**

- Firstly, put the following formula according to the equation we have taken.

`=EXP(B5)`

- Then, hit
Get the full dataset by using the*Enter*tool.*AutoFill*

- Now, select any cell within the data.
- Similarly, click the
tab and select the*Insert*command from the*Scatter*group of commands.*Charts* - After that, select the first one, simply the
from the drop-down menu.*Scatter chart*

- Then, a chart will appear. However, select the chart and click on the
symbol.*+* - After that, click on the
as mentioned below.*Chart Elements*

- Lastly, select
and*Exponential*from the*Display Equation on Chart*.*Format Trendline option*

- Finally,
will appear as below.*the Exponential Equation*

**Read More: How to Populate a List Based on Cell Value in Excel (6 Ways)**

### 3. Creating Logarithmic Type Equation

In general, **lo**** garithmic **type equations are quite common to plot data that grows or declines quickly before leveling out. Moreover, both positive and negative values may be present while creating

**l**

**. For example, I have used the following equation in order to create**

*ogarithmic equations***.**

*the logarithmic equation*`y = 0.4343ln(x) + 2`

**Steps:**

- Firstly, write the formula below and press
.*Enter*

`=LOG10(B5)+2`

- Now, use the
tool to do the same for the rest of the data.*AutoFill*

- Then, select any cell within the data.
- Secondly, click on the
tab.*Insert* - Thirdly, from the
group of commands, select the*Charts*command.*Scatter* - After that, select the
from the*Scatter chart*command.*Scatter*

- After all, a chart will appear. Again, select the chart and click on the
symbol.*+* - After that, mark the
as shown below.*Chart Elements*

- In addition to this, select
and*Logarithmic*.*Display Equation on Chart*

- Finally, you will get the
in the following image.*Logarithmic Equation*

### 4. Plotting Equation for Polynomials in Excel

A ** Polynomial **is often categorized based on the degree of the biggest exponent. Usually,

**perform better for big datasets that contain multiple rises and falls. Moreover, it has multiple orders. However, we have selected the below equation in order to plot the**

*polynomial equations***.**

*polynomial equation*`y = 3x^2 + 5x - 1`

Similarly, follow the steps mentioned below.

**Steps:**

- First of all, write the following formula in the formula bar and hit the
key.*Enter*

`=3*(B5^2)+5*B5-1`

- In addition to this, use the
tool similarly to generate the total sample dataset.*AutoFill*

- Now, select a cell from the given data.
- Next, click the
tab.*Insert* - Similarly, from the
group of commands, select the*Charts**Scatter command.* - After that, a drop-down menu will appear; select the
.*Scatter chart*

- Hence, a chart will appear. However, click on the
symbol after selecting the chart.*+* - After that, click on the
as shown in the image below.*Chart Elements*

- Select
of*Polynomial*and*Order 2*from the*Display Equation on Chart*accordingly.*Format Trendline Option*

- Lastly, you will find the
in the below picture.*Polynomial Equation*

**Read More: How to Use AutoComplete in Excel (4 Easy Ways)**

### 5. Drawing Power Equation in Excel

** The exponential curve** and

**line are extremely similar. However,**

*the power trend***is more symmetric. But**

*the power curve***will not work if the data contains zero or any negative values. For the purpose of demonstration, I have picked the following equation and sample dataset. Lastly, you have to go through the following steps.**

*p***ower**equation`y = x^3`

**Steps:**

- Firstly, input the formula below according to the sample equation and press the
button.*Enter*

`=B5^3`

- Similarly, use the
tool to complete the dataset.*AutoFill*

- Now, select any cell from the data.
- Secondly, click the
Moreover, click on the*Insert*command from the*Scatter*group of commands.*Charts* - Thirdly, select the
.*Scatter chart*

- Above all, a chart will appear.
- Now, select the chart and click on the
symbol.*+* - After that, click on the
which are mentioned in the below image.*Chart Elements*

- From the
, select*Format Trendline Option*and*Power*.*Display Equation on Chart*

- Finally, you will get the
as in the image below.*Power Y Equation*

**Read More:** **Autocomplete Data Validation Drop Down List in Excel (2 Methods)**

### 6. Equation Based on Moving Average

In some situations, you may have data that contains several fluctuations. In this case, ** the moving average trendline** helps a lot, though it doesn’t contain any equations. But it smooths the extreme ups and downs in the data set and certainly shows a smooth curve. For example, I have created a random sample dataset mentioned below to plot the curve.

**Steps:**

- At first, click on any cell within the data.
- Now, press the
tab.*Insert* - Next, from the
group of commands, select the*Charts*command.*Scatter* - After that, a drop-down menu will appear. Similarly, select the first one, simply the
.*Scatter chart*

- Gradually, a chart will appear. However, click on the
symbol after selecting the chart..*+* - After that, select some of the
as shown below.*Chart Elements*

- Lastly, select
and*Moving Average of Period 2*from the*Display Equation on Chart*.*Format Trendline option*

- Finally, you will get the
as mentioned in the below image.*Moving Average Equation*

## Plotting Multiple Equations on a Single Chart

However, we can combine multiple equations into a single chart. It is as simple and quite easy as before. Just follow the steps mentioned below to plot multiple equations on a single chart. For the purpose of demonstration, I have put three different types of equations in the following picture.

**Steps:**

- Firstly, draw the
by following the steps in Method 5.*power equation* - Now, select the graph and press
from the filter option.*Select Data*

- Now, click on the
option.*Add*

- After that, select the
and*X values*to the range for the other two equations as in the picture below. Hence, press*Y values*.*OK*

- Again, press
.**OK**

- Finally, you will find the three quotations plotted on the same chart.

## Conclusion

These are all the steps you can follow in Excel to **plot an equation in Excel.** Hopefully, you can now easily create the needed adjustments. I sincerely hope you learned something and enjoyed this guide. Please let us know in the comments section below if you have any queries or recommendations.

For more information like this, visit **Exceldemy.com**.