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* equations* in an Excel graph. Hence, read the article properly and save time.

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.

**Table of Contents**Expand

## 1. Plotting a Linear Equation in Excel

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 graph of
below.*Linear Equation*

## 2. Generating an Exponential Equation in Excel

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*

## 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*

## 5. Drawing Power Equation

** 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 on the
tab. 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*

## 6. Making an 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*

## How to Plot Multiple Equations on a Single Chart in Excel

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.

**Read More:** How to Graph Two Equations in ExcelÂ

**Download Practice Workbook**

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

## 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.

## Plot an Equation in Excel: Knowledge Hub

**<< Go Back to Excel Charts | Learn Excel**