# How to Add Trendline Equation in Excel (With Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

A Trendline is a popular way to make predictions in Excel. Often, we need to find the Trendline equation to see the slope and the constant. Excel has a feature that lets us get that equation for different types of trendlines. In this article, weâ€™ll see how easy it is to add a Trendline equation in Excel.

## What is Trendline and Trendline Equation in Excel?

A Trendline is a chart pattern that is made up of a straight line of highs or lows. It is made by putting a straight line between two or more price points. One can use a Trendline to show how prices have moved in the past. Also to show where support and resistance levels are. We use the Trendline equation to determine a line that provides the most accurate fit to a set of data points.

Weâ€™ll need a Trendline on our chart to figure out the Trendline equation. There are different kinds of trendlines in Excel. Weâ€™ll choose the one that gets us the most points. For instance, we have a sample dataset like the one below to show how these things work. Here, we can see how the price of decor has changed over time.

Also, a Scatter Plot of the given dataset is shown below.

Now to add the trendline equation to the plot, we need to follow the steps below.

## Step 1: Creating Chart with Trendline

First, we will need a Trendline on our plot to add a Trendline equation to it. To do so, we will follow these steps:

• To begin with, we need to select the chart. Click on the â€˜+â€™ sign or the Chart Element.

• Additionally, select Trendline from the Chart Element That will instantly add a linear Trendline to the plot.

## Step 2: Adding Trendline Equation to Excel Chart

Now we have our Trendline, we can add an equation to it. To do so, we will follow these steps:

• Firstly, select the Trendline on the plot and double-click on it. This will open the Format Trendline panel like this. From this panel, we can also choose different kinds of trendlines.

• Secondly, we will go to the bottom of the panel and see there is an option â€˜Display Equation on the chartâ€™.

• Finally, selecting that option will immediately insert an equation on the chart like the below image.

• Moreover, we can drag the equation to a suitable place to see it properly and get an image like this.

There we have it. Trendline equation, added to our plot, using Format Trendline panel.

## Things to Remember

• If you have any problem with Linear Trendline, you can choose other options from the Format Trendline.
• Choosing different types of trendlines will give us different Trendline equations. But the method will be exactly the same to obtain that equation.

## Conclusion

In this article, we showed how to insert a Trendline on the scatter plot and how to get a Trendline equation in Excel. We use Trendline equations to show the rise or fall of anything over time in a mathematical way. If youâ€™re still having trouble with any of these steps, let us know in the comments. Our team is ready to answer all of your questions.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.