Hi,
I hope you are all well and safe. Anyone who can help me out in creating a graph in excel that will show how many orders were created in a 7 day rolling period? What formula can I use?
I only have 2 columns on my excel sheet.
Column A - Date order is created
Column B - Number of orders made per day
Any help would be much appreciated.
Thank you,
You need to attach an example workbook.
Hi Roy,
Thanks for your prompt response. Attaching my workbook for reference.
Thank you,
If you use a PivotTable and PivotChart you can group the dates by weeks.
You probably need to adjust the example I've just set it to 7 day groups because I didn't know if you want Mon to Sun or something else.
Check this
Hi Roy,
Thank you so much for your help.
May I ask what formula did you use to calculate the number of orders per 7 days?
Also, if you don't mind how can I see which day (Mon-Sun )and month generated the most number of orders from 2018/2019?
I Grouped the days in the PivotTable. To show by years will need some adjustments, I'll post back later.
It doesn't seem that you can group by weeks and years. I've done this before regularly with months and years.
This is awesome. Thank you, Roy!
Pleased to help.
I would convert the data to a Table so the range will expand as data is added.
To group the dates in the PivotTable, click any cell in the dates column then choose ears and Months. Click OK