Finally, press ENTER to get the value of the Intercept.This function will return the value of Intercept for the dataset. Here, in the INTERCEPT function, I selected C5:C9 as known_ys and B5:B9 as known_xs. Secondly, in cell G5 write the following formula.Firstly, select the cell where you want to calculate the Slope.Now, I will use Functions to find the Slope and Intercept for the dataset. In the following Image, you can see that from the linear trendline equation I have got the Slope and Intercept. I will also use Functions to find the Slope and Intercept for the dataset to see if it matches the trendline equation. Here, I will use the linear trendline equation to find the Slope and Intercept. I also have a column chart of the dataset with a linear trendline and trendline equation. To explain this example, I have taken a dataset that contains Years and Sales. Employing Linear Trendline Equation in Excel to Find Slope and Intercept Read More: How to Add Trendline Equation in Excel (With Easy Steps)Ĥ. Here, you will see that you have got your Y values for any given X using the trendline equation in Excel. Now, drag the Fill Handle to copy the formula.Now, the formula will return the Y value. Here, In this formula, I used the trendline equation from the chart. Secondly, in cell C10 write the following formula.Firstly, select the cell where you want to forecast the data.Here, I will show you how to use trendline equation in Excel to forecast data. I also have a column chart of the dataset with a Linear Trendline and trendline equation.

To explain this example, I have taken a dataset that contains the Temperature (K) and Volume (Liter) of a gas. Using Trendline Equation in Excel to Forecast Data Read More: How to Create Trend Chart in Excel (4 Easy Methods)Ģ. Secondly, select Display Equation on chart.įinally, you will see the trendline equation on the chart.But you can select any other option you want. Here, I kept it Linear which was set by default. Secondly, select the trendline type you want.Here, you can also change the trendline type. Here, I selected Red.Īfter that, you will see that you have got your desired trendline. Now, you will see a list of colors will appear. Here, you will see that the Format Timeline option will appear on the right side of the screen. Now, you will see a trendline has been added to your chart.Īfter that, you can change the color of the trendline to make it more visible. Firstly, select the chart in which you want to add the trendline.In this first example, I will explain how to add a trendline equation in Excel. I have also taken a column chart of the dataset to show the use of the trendline equation in Excel. To explain this article I have taken the following dataset that contains Years and Sales. 8 Suitable Examples to Use Trendline Equation in Excel

Excel trendline polynomial equation