This article on demonstrates in detail how to use an Excel stacked bar chart for this. There are already some excellent resources: The good news is that, to create a Gantt Chart in Excel, you do not have to start from scratch. You might look at a dedicated project planning program, like Microsoft Project, instead. It requires a lot of work to create from scratch. The bad news is that, while a Gantt chart is a variety of bar chart, it is not in Excel’s standard charts.
Creating a Gantt Chart in Excel using a Bar Chart Modern Gantt charts also show the dependency relationships between activities and the current schedule status. It was designed and popularized by Henry Gantt around the years 1910–1915. The width of the horizontal bars in the graph shows the duration of each activity.
Time intervals are on the horizontal axis.
This chart lists the project’s tasks on the vertical axis. A Gantt chart is a bar chart that illustrates a project schedule.