Skip to main content

I have a set of data for internet usage for two people. For each person I have each time they logged in and out of the internet over a day. I want to make a bar chart/histogram where the x axis is time and the width of the bar is how long each time interval they log in for is. I want the data for each person shown on the same graph with a different colour for each person. How can I do this in excel?

Example data: Person 1 Connected Disconnected 08:54:05 08:56:02 09:16:35 09:18:24 09:31:54 09:35:11

Person 2 Connected Disconnected 08:52:46 08:53:34 09:04:12 09:17:35 09:31:23 09:35:14

Person 1
Connected    Disconnected
08:54:05     08:56:02
09:16:35     09:18:24
09:31:54     09:35:11

Person 2
Connected    Disconnected
08:52:46     08:53:34
09:04:12     09:17:35
09:31:23     09:35:14

I have a set of data for internet usage for two people. For each person I have each time they logged in and out of the internet over a day. I want to make a bar chart/histogram where the x axis is time and the width of the bar is how long each time interval they log in for is. I want the data for each person shown on the same graph with a different colour for each person. How can I do this in excel?

Example data: Person 1 Connected Disconnected 08:54:05 08:56:02 09:16:35 09:18:24 09:31:54 09:35:11

Person 2 Connected Disconnected 08:52:46 08:53:34 09:04:12 09:17:35 09:31:23 09:35:14

I have a set of data for internet usage for two people. For each person I have each time they logged in and out of the internet over a day. I want to make a bar chart/histogram where the x axis is time and the width of the bar is how long each time interval they log in for is. I want the data for each person shown on the same graph with a different colour for each person. How can I do this in excel?

Example data:

Person 1
Connected    Disconnected
08:54:05     08:56:02
09:16:35     09:18:24
09:31:54     09:35:11

Person 2
Connected    Disconnected
08:52:46     08:53:34
09:04:12     09:17:35
09:31:23     09:35:14
Source Link

How to combine time interval data on excel

I have a set of data for internet usage for two people. For each person I have each time they logged in and out of the internet over a day. I want to make a bar chart/histogram where the x axis is time and the width of the bar is how long each time interval they log in for is. I want the data for each person shown on the same graph with a different colour for each person. How can I do this in excel?

Example data: Person 1 Connected Disconnected 08:54:05 08:56:02 09:16:35 09:18:24 09:31:54 09:35:11

Person 2 Connected Disconnected 08:52:46 08:53:34 09:04:12 09:17:35 09:31:23 09:35:14