The dataset shows the Month’s Name, Month numbers, and Credit Card Balance in USD. Let’s say we have the following dataset shown in the B4:D12 cells below. In case you’re wondering, how to extrapolate non-linear data with trendlines? Then you’ve come to the right place. Extrapolate Non-Linear Data with Trendline Read More: How to Find the Equation of a Trendline in Excel (3 Suitable Ways)Ģ. Additionally, you can edit the Axis Titles, Chart Title, and the Legend from the Chart Element option.įinally, the resulting chart should look like the picture shown below.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.ġ.
0 kommentar(er)
