How do I create a Gantt chart with subtasks in Excel?

Also asked, can you create a Gantt chart in Excel?

To create a Gantt chart like the one in our example that shows task progress in days:

• Select the data you want to chart.
• Click Insert > Insert Bar Chart > Stacked Bar chart.
• Next, we'll format the stacked bar chart to appear like a Gantt chart.
• If you don't need the legend or chart title, click it and press DELETE.

One may also ask, how do I create a dependency in Excel?

Creating a Task Dependency Click on the drop-down under Predecessor – Task name and select the predecessor task. Set the dependency type and lag. Click the Add button to add the dependency. Click Ok to finish.

How to make a Gantt chart in Excel

1. List your project schedule in an Excel table.
2. Begin making your Excel Gantt by setting it up as a Stacked Bar chart.
3. Add the start dates of your Tasks to the Gantt chart.
4. Add the durations of your Tasks to the Gantt chart.
5. Add the descriptions of your Tasks to the Gantt chart.