Hi,
I'm new to this forum and a pretty good Excel user, just not proficient with graphs. I hope someone can help me figure how to graph events over time.
What I have is a spreadsheet that lists the times events occurred - I'd like to plot the events individually according to their times but also group them by shift. An example is below:

Data I have
Shift Time
2P-10P 2:36 PM
10P - 6A 10:17 PM

The graph I have in mind might look something like this:


Time

2:00 P
X
4:00 P

6:00 P

8:00 P

10:00 P
X
12:00 A

Shift 2-10 10P-6A

Is there a way to do this in excel? Or - is there a different way to chart this data that might be a better way to display it? What I'm attempting to show is how events are grouped at the beginning or end of shift (per the data I've collected).

Thanks in advance for any help you all can provide!

India