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