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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |