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.

Microsoft 365 Copilot can help you in multiple ways in Excel, including creating formulas and charts, mining spreadsheets for insights, and more. Preston Gralla / Foundry ...