Here are the steps to quickly create this Gantt Chart in Excel: Get the Data in place. Here we need three data points: Activity Name Start Date Number of Days it takes to complete the activity Go to Insert –> Charts –> Bar Chart –> Stacked Bar. This will insert a blank chart in the worksheet.

Excel does not come with an inbuilt Gantt chart template. Instead, we’ll create one using a stacked bar chart. Select your task information. Next, click on Insert tab > Bar Chart > Stacked Bar Chart. The new chart will be a block of white space, like this:

Now that our data is all set to go, let’s create a Gantt chart. To do that: Select all the data. Click the Insert Column or Bar Chart option from the Insert tab on Ribbon. Select Stacked Bar from 2-D Bar. Chart will appear on the Microsoft Excel worksheet as: It’s beginning to look like a Gant chart already