This time, hold the CTRL key and add the remaining Years to the previous selection.In a similar fashion, go to the Data Source > Edit.Eventually, the trendline for the 3 Years appears but we have to add the Axis Labels for these years.Then, we can choose a Color and the Dash type for the trendline as shown in the picture below.As a result, a Format Trendline Panel appears on the right where we enter a name and assign Forecast periods on our chart.Next, choose the Chart Elements > Trendline > More Options.

Thirdly, go to the Chart Elements > Trendline > Linear.Additionally, confirm your changes by clicking the OK and closing the dialog box.

In the example below, the Series is renamed to Actual Population.

Moreover, rename the series by clicking Edit the button.

Following, select the range of cells for the Years and click OK.

Next, a dialog box appears where we can change the Axis Labels to show Years.

Secondly, select the chart and right-click on the mouse.

Now, choose the 2D Line Chart as shown in the image below.

Next, navigate to the Insert > Line Chart drop-down.

Firstly, insert 3 new rows in the Year column.

So, without further delay, let’s see the process bit-by-bit. Luckily, Excel allows us to extrapolate trendlines using charts. Here, D5 and D6 cells refer to the Sales amount of $1246 and $1783, respectively, whereas the C5 and C6 cells indicate the Month numbers 1 and 2.įinally, use copying the formula to the next cell to obtain the results for April.Ĥ Methods to Extrapolate Trendline in ExcelĬonsidering the dataset in the B4:C9 cells, which contains the US Population data for each decade starting from the Year 1950.ġ.

Find trendline equation excel