How to create a project timeline in excel with dates

Download the practice workbook 👉 HERE and follow along.

There are two existing tutorials that cover the bulk of this Excel Gantt chart’s construction:

Easy Gantt Chart:

This chart is straightforward to create as it shows only a single view.

You can easily see when a task begins, how long it will take, and when it ends.

For a step-by-step guide, click here to read the detailed article.

Gantt Chart with Progress Bars

This chart is designed to show more than just the start, duration, and end of tasks.

It also displays how much of each task has been completed. We represent the actual progress with a thick gray bar and the percentage completed with a thinner green bar on top.

Additionally, you can switch views between the actual progress and the planned schedule.

The planned schedule, or baseline, represents what you initially expected to happen, compared to the actual progress.

This feature allows you to compare both scenarios in one comprehensive chart, making it easier to read and more detailed than ha

how to make project timeline in excel

how to make project planner in excel