You probably need a Gantt chart. This can be fudged by using a stacked bar
chart. Look at this article for detail.

Alternatively you could use Visio or a specialised business graphics package
like Harvard or ABC but not in Excel. I have also seen charts prepared by
colouring cells on a spreadsheet but they are usually quite clumsy.