My blog post on how to create a half decent Gantt Chart using Excel is one of the most visited pages on this blog.
You can now download my demo spreadsheet here and a new fully automated version (2014). Instructions on how to edit the chart are included in the spreadsheet. There’s a “Simple” version and one with separate Milestones and Activities (pictured above). If you need help e-mail me.