![]() Here we discuss the Forecast Formula and how to use the Forecast function along with practical examples and a downloadable excel template. This has been a guide to the Excel Forecast function. Commonly used in all FMCG, Financial and Investment companies to determine the growth of future sales.Useful in predicting month wise and year wise sales.In the above graph, we can see the difference where the blue line shows the previous year sales and the orange line shows the future forecasting sales, which denote that growth will be get increased for the next three months compared to the previous year 2018 So you will get the below forecasting chart as shown below. In order to display the forecast graph, select the forecast column along with the month and sales data. Now select the month and sales data column for graph selection after that, we need to choose the line chart type, then the line graph chart has been displayed as shown below. To insert the line chart, follow the below steps. The above sales and forecasting data can be displayed in a dynamic line chart format to reach the management easily. ![]() We can see that forecast in excel has predicted some sales values for the year 2019 month-wise, which shows that sales will be increased for the corresponding month. In-Line chart option select first option.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |