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***Table of Contents**hide

## Download Practice Workbook

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

## 6 Handy Ways to Get Y Equation on Excel Graph

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.

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

**Read More:** **How to Graph Two Equations in Excel (with Easy Steps)**

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

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

**Read More: How to Show Equation in Excel Graph (with Easy Steps)**

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

*the 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
as the following image.*Logarithmic Y Equation*

**Read More: How to Find Unknown Value on Excel Graph (4 Easy Ways)**

### 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 which 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 Display Equation of a Line in Excel Graph (2 Easy Ways)**

### 5. Creating Power Y Equation on Excel Graph

** The exponential curve** and

**line are extremely similar. However,**

*the power curve***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 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**

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

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

**Related Articles**

**How to Find the Equation of a Line in Excel (With Quick Steps)****Determine Protein Concentration from Standard Curve in Excel****How to Calculate Unknown Concentration from Standard Curve in Excel****Graph an Equation in Excel Without Data (With Easy Steps)**

**How to Get Y Equation on Excel Graph (6 Ways)****How to Show Equation in Excel Graph (with Easy Steps)****How to Find Unknown Value on Excel Graph (4 Easy Ways)****How to Find the Equation of a Line in Excel (With Quick Steps)****How to Display Equation of a Line in Excel Graph (2 Easy Ways)****How to Create Equation from Data Points in Excel****How to Determine Protein Concentration from Standard Curve in Excel****How to Graph Two Equations in Excel (with Easy Steps)****How to Calculate Unknown Concentration from Standard Curve in Excel****How to Graph an Equation in Excel Without Data (With Easy Steps)**