Until now, you have learned how to add trendline in Excel. Simply type the period in the backward box instead of the forward box. You can use trendline to extrapolate the trend of the data into the past. Your project data trend for the next 6 periods is created. STEP 3:Under forecast, type “6” in the forward box. STEP 2: Select the Trendline Options tab. STEP 1:Double click on the trendline to open the Format Trendline pane. Follow the steps below to understand how to forecast data trends. In this example, you want to forecast sales for the next 6 periods. In Excel, you can extend your data and project the data trend into the future or past using the features of Trendline. STEP 3:From the Format Trendline pane, click the Fill & Line category. Or, you can skip STEP 1 & 2 and simply double click on the trendline to open the Format Trendline pane. STEP 2:Select the Format Trendline option. In the example below, you want to change the color of the trendline to blue, increase the width to 2.5, and change the dash type. You can change the color, transparency, width, dash type, compound type, cap type, and more for your trendline. Now that you know how to add trendline in Excel, let’s move forward to understand how to format them.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |