Trying to build a Gantt chart out of Excel

[caliskier]

Hi What I am trying to do here is just put a "bird on a wire" for several projects. I have done this before in a different method using sideways bar charts and hiding (or coloring clear) some of the bars.

We have several projects that all have the same several gates with different dates for each gate for each project. I am trying to get a chart that looks like this:

Dates on the bottom, projects on the left side, and the middle is all the "gates" in the place where their date is for that project.

I have included an excel file that shows you what I am trying to do on one tab, and two attempts on another tabs. (BTW one tab has a random number generator, that is just to get a bunch of data in there quickly, the fact that it keeps changing isn't important)