Let’s refer to article in the following thread which discusses about a similar and see if it helps: http://www.excel-easy.com/examples/gantt-chart.html