0
I have a phone calls list divided by phone line with call start and end time like this:
+-------+-------+-------+
| LINE1 | 08:01 | 08:03 |
+-------+-------+-------+
| LINE2 | 08:02 | 08:50 |
+-------+-------+-------+
| LINE1 | 08:04 | 08:07 |
+-------+-------+-------+
| LINE2 | 08:55 | 09:00 |
+-------+-------+-------+
I want to graphically analize line usage during the day to find overlaps between lines, I expect a timeline for each phone line with their busy slots.
I really cannot understand if this is possible with Excel, because the horizontal bar chart seems not good for this purpose.
Tobia
Posted 2017-06-07T12:06:05.570
Reputation: 2 022
Is this SuperUser question of any help?
– Jeff Zeitlin – 2017-06-07T12:10:53.3833
Possible duplicate of Creating GANTT Chart (Timeline) From Start Time and Duration
– CharlieRB – 2017-06-07T12:56:22.377The duplicate is a good clue but not a complete solution. This problem needs the ability to have multiple periods for each line with each period similarly colored. That part isn't obvious from the other solution. – fixer1234 – 2017-06-09T05:25:53.927
Then I think you need to update your post and focus just on that part of the question so we can see why it isn't a dupe. As it is, the question (alone) is a dupe I think. – Dave – 2017-06-12T14:15:29.173