Hey,

I'm trying to make a custom 24 hour Gantt-type chart in Excel but it keeps giving me problems. I have things that happen over a 24 hour period, i.e from for Baking Unit 1, 07:40 to 08:10 mechanical failure, from 08:10 to 12:20 all good, from 12:20 to 12:50 electrical failure, from 12:50 to 1:15 mech. failure, etc.

How do I make this appear on one bar (one row) for each unit while have a color for each type of failure? Also, I don't want each type of failure bunched up together, but separated according to the time they occurred. (Y-axis: unit #, X-axis: Time).

Thanks,
- shinigami