Sales Forecast example Excel

Sales will be graphically displayed on the X-axis and sales on the Y-axis.

These tables show real and forecast sales. The first part of the line (actual row ) must be represented by a full colour (blue) and the remainder of the line (forecast) by a spotted line. There is only one line for sales work. Do not want to create a sales forecast graph with manually work.

We' re going to make a two-series diagram. You can downgrade all the date in columns W and C to a date with spaces at the bottom, the forecast in columns W and C to a date with spaces at the top from that date. Record this information and reformat the two sets as we want them to be (a continuous line, a dotted line).

If we can include new month, simply remove a forecast value and include the real value. As is and predictions are arranged in separated rows, you get two different sets of datasets when you display them. It is possible to generate a line graph and format the forecast row with a format. The sales areas work in a rapidly changing high-pressure environment, in which they must keep abreast of the latest possibilities and challenges.

See our sales dashboard samples for a variety of Dashboard Strategies that can help sales professionals keep track of their organization. In this way, you can present your sales force using either visually modelled sales or a sales forecast of your sales performance. Turnover forecasts are kept up to date by default! Take advantage of our free graphics to achieve your corporate objectives!