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.

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 ...

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.