How to make a Gantt Chart in Excel

A Gantt chart is popular project management tool, Excel doesn’t have a direct built in Gantt chart maker, but you can manipulate its charts to produce the same results.

You need your data already inputted and highlight it and put it in a bar chart. You will need to go into the Series tab and add each column in as a new Series. Make sure you remove the legend as well.

You will then want to remove the start dates by double clicking on any bar, go to patterns and click on None for Patters and Border. You now have a Gantt chart, it may need slight editing e.g. making it shorter, renaming etc.

Similar Posts:


, , ,
Andy Trainer

Connect with Andy on Google Profile.

View all posts by Andy Trainer

Leave a Comment