Modified Gantt

[wiwchar]

I am looking to take information in a spreadsheet and create a modified Gantt chart. The users select a Category from a drop down in Column B, input a title in Column C, and then select a Year - Quarter in Column F for the start and Column G for the end. The cells that represent the start and end under the Year and Quarter would be drawn. The color of the bar is driven by the Category. See the example below. There are more than 2 categories, but no more than 10.

Thoughts?

Thanks in advance.