Progressively create a Gantt chart in Excel

Excel 2016
A Gantt chart is one of the most popular tools in project management. It illustrates project schedules by showing activities, like tasks and events, against time.

Drawing Gantt charts is laborious, and that is why you can find Gantt charts only in professional project management tools, e.g., Microsoft Planner. Professional tools are expensive and limit customizations and overkill for presentation or documentation needs. We show you how to build a very sophisticated Gantt chart in Excel that you will be able to customize to your needs.

   1.   Create a simple project schedule:

The Gantt Chart data in Excel 365

and do a few customizations to Stacked Bar chart to create a simple Gantt chart:

A simple Gantt Chart in Excel 365

   2.   Add the % Complete, Days Complete, and Days Remaining columns to the project schedule:

The Gantt Chart with progress data in Excel 365

and rebuild your Stacked Bar chart to create a Gantt chart with progress status:

A Gantt Chart with progress in Excel 365

   3.   Add an events table to the Excel spreadsheet:

The Gantt Chart with events data in Excel 365

and change the Stacked Bar to a combination chart to add events to your schedule:

A Gantt Chart with events in Excel 365

   4.   Add the current or a custom date cell to your table:

The Gantt Chart with a vertical line data in Excel 365

and add a secondary axis for a vertical line that tracks today's date:

A Gantt Chart with a vertical line in Excel 365

Do any color, shape, or font changes that suit personal taste or company guidelines.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.