You can use the data in your Excel workbooks to analyze past performance, but you can also have Excel make its best guess as to future performance if current trends continue. For example, if you create a chart that represents your company’s sales for the past five years, you can have Excel analyze the data and add a trendline to the chart to represent how much sales would increase if the current trend holds true for the next year.
Click Linear Forecast Trendline.
If you’d like more control over your trendline, such as by choosing a different mathematical procedure to extend the line (although the default Linear option works the vast majority of the time) or by choosing the number of units by which to extend the line, click Trendline and then click More Trendline Options to display the Format Trendline dialog box.
3.145.174.253