#Excel trendline for part of graph series#
Right-click the series line for the Actual column. Notice that the thick line is not quite above the progress line. The top chart in Figure 3.31 shows the chart before the trendline is complete. The actual line is formatted as a thick line. The trendline is formatted as a lighter gray. The chart is created as a line chart with the gridlines and legend removed. Column D, which is labeled Actual, is where I record the daily progress toward the goal.įigure 3.31 In the top chart, the actual line is running behind the target line, but it seems close. In this particular month, I am assuming that I will write an equal number of pages six days per week. Column C shows the writing progress I should make each day. Therefore, Excel draws a straight line across the chart showing the goal at the end of the project. In Figure 3.31, Column A contains the days of the month and Column B contains 125 for each data point. The easiest way to add a trendline is to build a data series that includes all the days that the project is scheduled to run. 
I regularly use these charts to track my progress toward a goal or trendline. If your data series contains blank points that represent the future, Excel can automatically add the trendline. You can ask Excel to extrapolate the trendline into the future. In these situations, Excel offers a trendline feature in which Excel draws a straight line that fits the existing data points. However, sometimes you might want to allow Excel to make a prediction based on past results. In the previous example, an analyst had created a forecast for the next two quarters. Learn More Buy Adding an Automatic Trendline to a Chart
0 kommentar(er)
