Free Project Planner Gantt Chart Excel Template

A basic customizable Gantt Chart Excel Template suitable for most projects.

Free Project Planner Gantt Chart Excel Template

That should cover the basics for most projects. But if you need to add more, it’s really easy to customize the template.

Step 1: How to set up new tasks
First, rename existing activities to fit your own project. We’ve set up some example tasks as a default. Just click on any cell in "ACTIVITY" column and rename it.

Step 2: Update your activity start and duration
Next, update your task start and duration within the Excel Gantt chart schedule template.

Step 3: Task durations calculate automatically
The Duration column for each task is automatically calculated within the Gantt chart template by subtracting the start date from the end date. As you enter your start and end dates, the Duration column will populate on its own. Duration shows in days by default.

Step 4: Assign percent complete
Finally, update the Percent Complete column. You’ll see the cell color deepen as a task nears completion.

You’ve now created a basic Gantt chart.

You just have to enter the planned start date, the planned duration and the template will automatically build a Gantt Chart

You may use a Waterfall approach or Agile. As you like.

This Best Practice includes
1 Free Gantt Chart Excel Template + Video guide

Henry Sheykin offers you this Best Practice for free!

download for free

Add to bookmarks



keyboard_arrow_downShow all

More Best Practices from Henry Sheykin

See all

Any questions on Free Project Planner Gantt Chart Excel Template?

The user community and author are here to help. Go ahead!

4.6 / 5 (20 votes)

please wait...