Log In
Register
Home
November 16, 2019
Offline
Hello,
I work as a customer service in an automative company and everyday, I receive the daily and weekly forecasts of my customers. I started to record the figures everyday in order to see how much the demands have increased or dropped. I have two charts:
The first one is more simple and shows the deviation of the forecast taking into account "forecast" and "real" figures.
The second one is a bit more complex because I want to see the evolution of the forecast along three weeks. I want to know if there is a more elegant and automated way to represent this evolution.
I attach the file so that you can see what I mean.
Thanks in advance,
Cristina
July 16, 2010
Offline
Hi Christina,
Thanks for sharing your file, however I don't know which sheet(s) or what to look at in it. I'll assume it's the 'Deviation forecast week 35' chart on the 'Desviacion_demanda' sheet. If not, let me know.
If so, another chart you could try is the Waterfall chart as this shows the evolution of the forecast over time. Hope that helps.
Mynda
November 16, 2019
Offline
Hi Mynda,
Thanks so much for your prompt reply. Yes, I meant that chart. I've explained a little more in the pictures below so that you can see how I introduce the data. I wanted to see If I can do it in a more effective and automated way.
Thanks so much for your recomendation about the waterfall chart. I've been reading the article and I think that it is fantastic but I'm afraid that I don't know how to use it with my data. Any idea of how should I gather the information?
Thanks again 🙂
Cristina
July 16, 2010
Offline
Hi Cristina,
It's not clear from your file or description where exactly the figures are coming from but presumably it's the individual week tabs. If so, you need to consolidate the data on those individual tabs into a single table (you can use Power Query to consolidate data from multiple sheets).
Once the data is consolidated, you should be able to create the table that feeds the chart by classifying each row into the Current Week, Forecast Day, Week Day and Forecast Week. You can then use a PivotTable to summarise the forecast figures and use a Slicer to filter the Week number you want displayed in the chart.
I hope that points you in the right direction. Let us know if you get stuck.
Mynda
1 Guest(s)
