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.
