See Full Bio Dana MirandaCEPF®, Small Business Expert Writer ... Here’s how to make a Gantt chart in Excel to accommodate complex agile project management within the familiar tool.

The bar graph needs to have a range of data before you can make it. 1. Highlight the range of data you want to represent. You can either click and drag for several neighboring columns. 2.