I have an Microsoft Excel document with two columns, date (mm/dd/yyyy) and time HH:MM(a/p). Each row represents an order (The day it was placed and the time it was placed).
How can I graph this so that the Y-axis is the number of orders and the X-axis is the day of the week? (Monday-Sunday)
How can I graph this so that the Y-axis is the number of orders and the X-axis is the time of day? (Hour0-Hour23)
Is this even possible using MS Excel? I've never done anything this complicated. Is it even possible to convert dates (mm/dd/yyyy) into days of the week?
I don't expect a complete answer (but if you have one please send it). I don't even know where to start or if it is even possible.
WEEKDAYfunction for this but it returns a number (1 - 7). Make a pivot table of your data. Make a scatter plot based on the pivot table.