Q. Our company creates seasonally adjusted revenue forecasts in Excel 2016 based on historical data using regression analysis. I would like to also chart the seasonally adjusted upper- and ...

For instance, when you create a forecast, Excel creates a new worksheet that includes both a table of the historical and predicted values. You also see a chart that expresses this data.

Select your data, go to the Data tab, and click Forecast Sheet. Excel will generate a new sheet showing projected prices based on historical data.

Go to Chart | Add Trendline. Click on the Options tab. In the Forecast section, click on the up arrow in the Forecast box until the entry in the box changes to 6. Click OK. Excel will extend the ...