In the Forecast End box, pick an end date, and then click Create.Įxcel creates a new worksheet that contains both a table of the historical and predicted values and a chart that expresses this data. In the Create Forecast Worksheet box, pick either a line chart or a column chart for the visual representation of the forecast. On the Data tab, in the Forecast group, click Forecast Sheet. Tip: If you select a cell in one of your series, Excel automatically selects the rest of the data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |