Defining the options for a new line chart that shows historical and projected sales in the Create a Forecast Worksheet dialog box.By default, Excel selects a line chart to visually depict the trends in its forecast, but, if you wish, you can have the program use a column chart instead. Simply click the Column Chart icon to the immediate right of the Line Chart icon at the top of the Create Forecast Worksheet dialog box.In addition to selecting the type of chart to be used in the forecast worksheet, you can also control the date at which the forecast chart ends. You do this by selecting a new date in the Forecast End text box that appears below the preview of the embedded line or column chart. For example, the historical data table includes annual sales for the years 2000 through 2015, and Excel automatically uses this data to extend the forecast end date out four years to 2019.
“The cloud” is a friendly way of describing web-based computing services that are hosted outside of your home or organization. When you use cloud-based services, your IT infrastructure resides off your property (off-premises), and is maintained by a third party (hosted), instead of residing on a server at your home or business (on-premises) that you maintain. With Office 365, for example, information storage, computation, and software are located and managed remotely on servers owned by Microsoft. Many services you use every day are a part of the cloud—everything from web-based email to mobile banking and online photo storage. Because this infrastructure is located online or “in the cloud,” you can access it virtually anywhere, from a PC, tablet, smartphone, or other device with an Internet connection.
On the Data tab, in the Forecast group, click Forecast Sheet. In the Create Forecast Worksheet box, pick either a line chart or a column chart for the visual representation of the forecast. In the Forecast End box, pick an end date, and then click Create. Excel tutorial on how to use the Forecast Sheet in Excel. The Forecast Sheet button does a quick analysis of data on your sheet and also creates a chart of what it’s forecasting.