Excel Create Gantt Chart 1 Select the data you want to chart. In our example, that’s A1:C6. If your data’s in a continuous range of cells, select any cell in that range ... 2 Click Insert > Insert Bar Chart > Stacked Bar chart. 3 Next, we’ll format the stacked bar chart to appear like a Gantt chart. In the chart, click the first data series (the Start part of the bar in ... 4 If you don’t need the legend or chart title, click...