Help graphing login logout times over a 24 hour period

Hello, I have seen similar questions come up in the forums but never quite seem to find an answer that completely answers my question.


I need to graph a time line that shows when a person logged in and logged out. They may login and out several times a day. The X axis would be time from midnight through 11:59pm and the y axis would be binary, either on or off. I am sorry if I am not being clear as it is hard to describe. I am attaching a screenshot that should display what I am trying to do. The Excel specific data is an export from an application showing login and logout times. The chart in the background is from the application itself but does not come as part of the export so I am hoping I can reproduce it in excel and ultimately do a lot more with this data over multiple days etc. Really having trouble getting started which seems like it should be so simple.

Any help would be greatly appreciated!

Thank you for the fast response. Yes it is definitely similar to a gantt chart but I'm trying to stay on one line. I'll look through those other threads you mentioned to see if I can find a solution within them.

In the meantime here is a sample of the export we get from the application. this is the sort of data I'm trying to graph out.

Originally Posted by Kaper

Easy option to start could be stacked bar chart. Data for series shall be prepared in a way showing length of each period - see helper column in attachment.

!YES! Thank you, this looks exactly what I was trying to do. I will review this! THANK YOU!

Thank you MrShorty and Kaper. Those threads from MrShorty had a lot of good info and Kaper's example give me an apples for apples solution. It was fun seeing how it was solved.