Looking for some help with a good way to visualize data. I have a series of projects with varying start and end dates. Each project has a time stamp for certain phases that are completed. I want to be able to stack several stacked bar charts next to each other, in order to visualize what is being worked on today. Data listed below are the three projects. With the left column being the start time, and the right being the end of the completed project.


Looking for something similar to this chart
j72Vy.jpg


Unit 1 8/15/16 8:00 8/17/16 9:12 8/23/16 11:28 8/27/16 9:11 8/29/16 10:23 8/29/16 12:23
Unit 2 8/15/16 10:20 8/20/16 14:49 8/31/16 10:53 9/6/16 9:53 9/9/16 15:01 9/9/16 17:01
Unit 3 8/17/16 9:41 8/16/16 11:28 8/19/16 14:52 8/21/16 12:35 8/22/16 13:43 8/22/16 15:43

Apologize that the workbook isnt attached, as the forum doesnt seem to be allowing the attachment at this moment.

Thank you for your help!