Creating a Gantt-Like Chart in Excel without using VBA

Good Afternoon,

Thank you all for your help in advance.

I would like to create a gantt-like chart in Excel without using any VB or macros.

Specifically, I am having problems trying to figure out how to get a task to appear with two seperate durations.

For example,

Building 1 will have a Start Date of 5/1/10 and End Date of 5/25/10
as well as a Start Date of 7/1/10 and End Date of 7/7/10

Building 2 will have a Start Date of 6/15/10 and End Date of 6/30/10


How can I display these durations graphically on the same line? Is there a graph in Excel that can do this? I have tried to show the 2-D Bar graph particularly the Stack graph, but I have not had any luck in get the data series to display the information correctly on the graph.

I have attached an excel spreadsheet to show an example of what I would like to display on my graphs