# How to Find the Equation of a Trendline in Excel (3 Suitable Ways)

Get FREE Advanced Excel Exercises with Solutions!

In this tutorial, I am going to show you 3 suitable ways to find the equation of a trendline in Excel. A trendline equation is basically a formula of a line that represents the best trend in your data. There are many options available in Excel to add a trendline. You should try your best to choose a suitable type of trendline that best fits your dataset.

## How to Find the Equation of a Trendline in Excel: 3 Suitable Ways

### 1. Find Equation with Single Trendline in Excel

For simple ExcelÂ datasets, you can use a single trendline to fit your data and then find its equation. This type of trendline is applicable to various real-life cases. Let us see how to find the equation from a single trendline.

Steps:

• First, select the dataset with the help of the mouse.
• Next, go to the Insert tab and click on the Insert Scatter (X, Y) or Bubble ChartÂ dropdown.
• Then, from the available options select Scatter.

• As a result, you will see a scattered chart of your selected dataset.
• Now, right-click on any of the points of the chart and select Add Trendline.

• Next, a window will open with the name Format Trendline.
• Here, from the Trendline Options select Linear.

• Then, from more options below select Display Equation on Chart.

• After doing the previous steps properly, you should see a trendline on your chart with the equation.

### 2. Use Double Trendline

When you have an Excel dataset that has different categories of data points, then you can definitely try this method to find the equation of a trendline. For instance, you might have data points for various time ranges. In that case, you can easily pass a suitable trendline through each time period. Let me take you through the steps to make things clear.

Steps:

• To begin with, select the dataset and create a scatter plot from them as we did just a while ago.
• Here, you should see a scatter plot similar to the one I have shown below.

• Next, right-click on any part of the chart and choose Select Data.

• Now, in the new Select Data Source window, select the data series Y and click Remove.
• Then, click on the AddÂ button.

• Consequently, a new Edit Series window will open.
• Now, in this window, set the Series name to Linear.
• Next, select cells B5 to B7 as the Series X values.
• Similarly, select cells C5 to C7 for the Series Y valuesÂ field.
• After that press OK.

• Here, you will see a new data series called Linear.
• Likewise, create another dataset with the name Polynomial.
• Also, for the Series X values select cells B8 to B10, and for Series Y values select cells C8 to C10.

• After that, you will see a scatter plot of the two data series we just created.

• Now, right-click on any of the blue data points and select Add Trendline.

• Then, following the steps I showed in the first method, create a Linear trendline and display the equation.
• Again, create another trendline for the orange data points using the Polynomial option and also display the equation.

Read More: How to Add Multiple Trendlines in Excel

### 3. Find Equation from Excel Column Chart Trendline

Although a trendline is not fitted to Excel column charts generally, you can try adding one and find its equation. Follow the steps below to add a trendline to the column chart.

Steps:

• Firstly, select your data dataset and go to the InsertÂ tab.
• Next, click on the Insert Column or Bar Chart dropdown and select the Clustered ColumnÂ option.

• Thus, Excel will generate a 2-D clustered column chart with your dataset.

• Now, right-click on any of the orange-colored columns and select Add Trendline.

• Then, in the new Format Trendline window, set Polynomial as the Trendline Options.

• Also, check the Display Equation on chartÂ option.

You can download the practice workbook from here.

## Conclusion

I hope that you fully grasped the techniques I demonstrated in this tutorial to find the equation of a trendline in Excel. Indeed a trendline equation is a powerful tool for making predictions with your dataset. I would encourage you to extend your trendline to a future period of your interest and see what results it gives.

## 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.
Nazmul Hossain Shovon

Hello, I am Nazmul Hossain. I am currently working full-time in Exceldemy as an Excel & VBA Content Developer. I have completed my bachelors in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. I am interested in working with MS Excel. I also like coding web applications a lot.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF