Explanation

To create a Forecast Sheet:

  1. Select the historical Date and Sales
  2. Go to Data → Forecast Sheet.
  3. Choose a Line Chart or Column Chart.
  4. Set the Forecast End Date.
  5. Review the preview.
  6. Click Create.

Excel creates a new worksheet containing the forecast and chart.

Example

Historical period:

January–December 2026

Forecast period:

January–June 2027

The forecast worksheet displays:

  • Historical values
  • Forecast values
  • Forecast chart
  • Upper confidence boundary
  • Lower confidence boundary

Practice

Create a forecast for the next six months.

PreviousNext