Gantt Chart

Currently I have following data in excel and would like to create a pictorial gantt chart project wise and show the various phases (with overlapping if any) under the date range.

Any help or pointers would be appreciated

Thanks
spiderman1

EDIT: Link to cross-post at Mr. Excel: http://www.mrexcel.com/forum/showthread.php?t=332779

Spiderman,

Please read the forum rules (links at the top of most forums, as well as in my signature), paying specific attention to the rule about cross-posting your question on multiple forums.

Since this is your first time posting here at Excel Forum, I've provided a link to your cross-post at Mr. Excel. In the future please be kind enough to do so if you plan to cross-post.

http://www.mrexcel.com/forum/showthread.php?t=332779

Also, if you receive a resolution at either site, please be courteous enough to share it at all sites you have posted.

Thank you.