I don't post on here very often, but I have tried searching, and I can't seem to find an answer for my issue. I'm going to post a hypothetical, but it matches my real-world situation very closely.

Say I've got the following set of data relating to individual observations of travel delay on a highway segment throughout the course of a day:

DATE; DELAY; TIME
1/22/14; 3.0; 06:00
1/22/14; 3.7; 09:00
1/22/14; 4.4; 11:00
1/23/14; 2.7; 06:45
1/23/14; 1.6; 13:28
1/24/14; 8.9; 05:45
1/24/14; 7.5; 09:34
1/24/14; 3.8; 14:56
1/24/14; 5.0; 15:18

I am interested in splitting this data by date, and plotting a separate series for each day, all on the same graph. So, in this case, there would be a total of 3 series, where Time is plotted on the horizontal axis, and Delay is plotted on the vertical axis.

Is there a way to easily split this data for plotting as multiple series? My problem arises in that my actual data set contains dozens of different days, each of which have hundreds of observations. Copying and pasting each day into a separate column is cost-prohibitive (time-wise), and I can't help but think there's got to be some clever way to use indicators or something to get the plots I need.

I am relatively new to working with large data sets in Excel, so any help or advice is appreciated!