Excel Graphing Help

[ScottulusMaximus]

Hello geniuses of myBB, need some help. I have a csv file of all the Quick Estimates submitted on our site ordered by date and time:

July 12th 2017, 16:48
July 12th 2017, 16:53
July 12th 2017, 16:57
July 12th 2017, 18:43
July 12th 2017, 18:52
etc
etc
etc

I want to be able to turn this into a graph that shows me how many times a day the form was submitted, so I need to count how many times for example August 3rd shows up, and then put that value onto a graph.

Any idea how I can do this? The csv if 2600 rows so doing it manually isn't an option.

 

[creeper]

Pull the data into a pivot table, set the grouping to days/ weeks / months and creeate a pivot graph.

 

[ScottulusMaximus]

Thank you!