Excel creates a new worksheet that contains both a table of the historical and predicted values and a chart that expresses this data. In the Forecast End box, pick an end date, and then click Create. In the Create Forecast Worksheet box, pick either a line chart or a column chart for the visual representation of the forecast.
All you do is open the worksheet with your historical data, position the cell cursor in one its cells, and then click the Forecast Sheet button on the Data Tab of the Ribbon (Alt.
The new Forecast Sheet feature in Excel 2016 makes it super easy to turn a worksheet containing historical financial data into a remarkable visual forecast worksheet.
