Excel does not offer Gantt as chart type, but it's easy to create a Gantt chart by customizing the stacked bar chart type. Below you can find our Gantt chart data. To create a Gantt chart, execute the following steps. 1. Select the range A3:C11. 2. On the Insert tab, in the Charts group, click the Column symbol.

How to Make a Gantt Chart in Excel Download the Gantt Chart Excel template if you haven’t done so already. Open the template. The Gantt Menu tab in the excel ribbon will instantly load (see image below). Create a New Gantt Chart Click on the Add New Gantt Chart button to bring up the Project Details window.

The simplest kind of Excel Gantt chart involves a worksheet range, with the tasks listed in the first column, and dates (for example, week beginning or ending dates) in the top row. If a date along the top falls between the start and end dates for that task, the cell in the same row as the task is shaded a different color.

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 📈

Select cells C4:C11 (the start dates). Go to the Insert tab and choose Stacked Bar Chart. This will create a Stacked Bar Chart representing the start dates. Right-click on the chart area and choose Select Data. Click Add and enter Duration as the series name. Select cells E5:E11 as the series values and click OK.