Chart to get sales orders by hour

[newyorknix]

I have orders data like this:

Date Time Qty
05/05/17 12:35 1
07/05/17 13:48 1
08/05/17 17:13 1
10/05/17 10:20 1
12/05/17 11:50 1

I would like to find out at which time of the day customers are active. A chart where x axis is time, y axis is qty, so that I can find out at which time of the day most orders are coming regardless of dates. Kindly help me to understand how to achieve this?

[Pete_UK]

First of all, you need to set up a second table which will list in one column the times of day, say in hourly intervals. In the next column you can have a formula (probably based on SUMIFS, but if you are using Excel 2003 as your profile states then it would need to be SUMPRODUCT) to total the number of sales in each period, and then you can use this second table as the source for your graph.

Hope this helps.

Pete