Bar Graph/Gantt Chart

[BobSmith9]

Hi everyone,

I'm wondering if anyone can offer some insight into a conundrum I am having with Excel. I wish to create a bar graph/gantt chart, which displays months along the X axis, and each point in the Y axis represents a dataset.
The dataset represents stages, which I wish to colour code.

I've attached a very rough example, though I'm having trouble with the majority of it.

\1

Although there will be more sets of data, this serves as an example of what I am after. In order to do this one, I had to select each chunk and colour code them accordingly. However, the legend was incorrect.

From the example, I would like the X axis to represent months. From October 2010, to October 2012.
And each coloured block represents a stage (though I am after 5 stages/colours).

Not all data rows begin and end on the same month, however. Is it possible for me to create what I am after?

If you require any more details, please feel free to ask. And, thank you for taking the time to help.