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. How to Extrapolate Trendline in Excel: 4 MethodsĬonsidering the dataset in the B4:C9 cells, which contains the US Population data for each decade starting from the Year 1950.ġ. 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.
