Sometimes, we need to draw the ** Y equation** on an Excel graph. Fortunately, it is quite simple and easy to do this in Excel. In this article, we will show you six easy ways to get the

**on an Excel graph. Read the article carefully and save your time.**

*Y equation*From the Excel graph, you can get ** Y equations** for various types of equations. Generally, it includes

**linear equations**,

**Exponential equations**,

**Logarithmic equations**,

**polynomials**,

**Power equations,**and

**Moving averages**. Today we will demonstrate to you all of them step by step. We have selected a random dataset as the following image.

**Table of Contents**Expand

## 1. Creating Linear Y Equation

Generally, ** Linear Y Equation** is 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 random dataset.

Hence, follow the steps.

*Steps:*

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

- 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
as below.*Linear Y Equation*

## 2. Plotting Y Equation on Excel Graph for Exponential

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

**.**

*Exponential Y Equation***Steps:**

- First, 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,
*the*will appear as below.*Exponential Y Equation*

**Read More:** How to Show Equation in Excel Graph

## 3. Making Logarithmic Type Y Equation

In general, ** Logarithmic type Y 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

**. For example, I have used the following random dataset in order to make**

*Logarithmic Y Equations**t*

*he*

**.**

*Logarithmic Type Y Equation***Steps:**

- Firstly, 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
from the*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 Y Equation*

## 4. Plotting Y Equation for Polynomials on Excel Graph

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 dataset in order to get the**

*Polynomial Y Equations***.**

*Polynomial Y Equation***Steps:**

- First of all, select a cell from the given data.
- Next, click the
tab.*Insert* - Similarly, from the
group of commands, select the*Charts*command.*ScatterÂ* - 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
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 Y Equation*

**Read More: **How to Make a Polynomial Trendline in Excel

## 5. Creating Power Y Equation on Excel Graph

*Th**e*** exponential curve** and

*th*

*e*

**line are extremely similar. However,**

*power curve**t*

*he*

**is more symmetric. But**

*Power Curve***will not work if the data contains zero or any negative values. For the purpose of demonstration, I have picked the sample dataset mentioned below. Lastly, you have to go through the following steps.**

*Power Y Equation***Steps:**

- Firstly, select any cell from the data.
- Secondly, click the
Moreover, click on the*Insert*command from the*Scatter*group of commands.*Charts* - Thirdly, select simply 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. Moving Average Based on Y Equation

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 provide any

**. But it smooths the extreme ups and downs in the data set and certainly shows a smooth curve. For example, I have created the sample dataset mentioned below to plot the curve.**

*Y equation***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 Y equation*

**Read More:** How to Create Equation from Data Points 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 get the Y equation on the Excel graph**.** Hopefully, you can now easily make 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.

**Related Articles**

- How to Find the Equation of a Line in Excel
- How to Find the Equation of a Trendline in Excel
- How to Use Trendline Equation in Excel
- How to Find Slope of Trendline in Excel
- How to Find Slope of Polynomial Trendline in Excel
- How to Find Intersection of Two Trend Lines in Excel

**<< Go Back To Trendline Equation Excel | Trendline in ExcelÂ |Â Excel ChartsÂ |Â Learn Excel**