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 2016

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

A simple Gantt Chart in Excel 2016

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

The Gantt Chart with progress data in Excel 2016

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

A Gantt Chart with progress in Excel 2016

   3.   Add an events table to the Excel spreadsheet:

The Gantt Chart with events data in Excel 2016

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

A Gantt Chart with events in Excel 2016

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

The Gantt Chart with a vertical line data in Excel 2016

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

A Gantt Chart with a vertical line in Excel 2016

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

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.