VBA Code for Excel gantt Chart

[param200]

Hello,

I have an excel data sheet that has the following information:

Project Prj St Prj End Asset ADt Bdt
Project A 01/01/06 05/01/06 Asset1 01/15/06 02/15/06
Asset2 01/15/06 02/15/06
Asset3 01/15/06 02/15/06
Project B 04/01/06 08/01/06 Asset2 04/15/06 06/20/06
Asset4 05/01/06 07/20/06
and so on..

I need this information displayed in a Gantt Chart format, except that all the dates pertaining to particular asset needs to be on one line but different color (i.e for Project A, Asset1 - The ADt should be yellow,BDt should be blue etc..)

Can someone please help.

Thanks.