Forecasting current sales according to ongoing trend and history data

manchoon

New Member
Joined
Feb 17, 2016
Messages
8
Hello everyone, hope you'll be able to help me
smile.gif


I have everyday sales data of this month and I need to forecast daily sales till the end of this month. I have to take into consideration the ongoing trend and also the history sales of the same month of previous year. The solution has to be refreshable, I mean after I refresh the data and new daily sale is added in current month, the forecast should update too.
This is my chart. Blue line is current sales, red one is previous year (the same month) sales. I need blue line to be continued with for example orange line which will show forecasted everyday sales.
538206d1505457851-forecasting-current-sales-according-to-ongoing-trend-and-history-data-ag.png

I tried to do it with forecast sheet (from data tab), which does the instant forecast, but it either does linear forecasting which is not correct or I have to indicate seasonality, but I don't have seasonality, it's one month and every day sales are different. It doesn't show prev year sales too. So I guess it won't be useful for me.

Could you please tell me which tool to use or any formula?
Any ideas?

please help
Thank you in advance.
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Forum statistics

Threads
1,214,943
Messages
6,122,370
Members
449,080
Latest member
Armadillos

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top