Graphically depict durations

[SandsB]

My data file has about 50 rows of data - varies each day. Could also be over a 100 or less than 10. The range of dates could be a few weeks to several months. Table 1 attached.
Somehow, I need to get this data displayed in a graphical format (Chart2 attached) - could be a chart, could be cells with background color like the attached. The graph needs to show the dates from the Create date to the Update date. EX: In row 1 the report was created on 3/11 and updated on 3/28 so those dates and everything in between is color coded. I can't use M$ Project or any other tool - just Excel. Could be formulas or VBA.

 

[SandsB]

There may be a better way to do it but here's what I'm doing. I'm using the same chart I used in the example but using conditional formatting and this formula

=IF(AND(AM21>=$F2,AM21<=$G2),"X","")

Where row 21 is the date row in my chart and F & G have the Create & Update dates in my data.

Then I use conditional formatting if there's an "X" in the cell. Kindof ugly but it works.