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. If const is FALSE, b is set equal to 0 (zero), and the m-values are adjusted so that y = mx.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.ġ. If const is TRUE or omitted, b is calculated normally.

If known_x's is omitted, it is assumed to be the array that is the same size as known_y's.Ī logical value specifying whether to force the constant b to equal 0 If more than one variable is used, known_y's must be a vector (that is, a range with a height of one row or a width of one column). If only one variable is used, known_y's and known_x's can be ranges of any shape, as long as they have equal dimensions.

The array known_x's can include one or more sets of variables. If the array known_y's is in a single row, then each row of known_x's is interpreted as a separate variable.Īn optional set of x-values that you may already know in the relationship y = mx + b

If the array known_y's is in a single column, then each column of known_x's is interpreted as a separate variable. The set of y-values you already know in the relationship y = mx + b The TREND function syntax has the following arguments:

Using the trendline equation from excel