Excel Gantt Chart Template Free Download

A Gantt chart is a tool for project management developed originally by Henry Gantt in the early 1900s.

If you use Excel or Google Sheets, you can create this type of project schedule with almost no learning curve by downloading free Gantt Chart Template.

This template contains the core functionality needed to create a simple Gantt chart easily. Each row of the worksheet represents a separate task. All you need to do is define the start date and duration of each task.

To add more tasks, you just copy and paste rows (or insert a row then press Ctrl+d to copy formulas down).

To change the range of dates displayed in the chart area, just slide the scroll bar.
To track the status of a task, edit the % Complete column. The bars in the chart show the % complete for each task.

The vertical red line shows the current date. You can use the TODAY() function in the Today’s Date field to automatically move the red line.

The Start and End dates for a Summary (Level 1) task can be found by using the MIN and MAX functions, such as MIN(range_of_start_dates) or MAX(range_of_end_dates).

To use the automatic work breakdown structure numbering, copy the formula for the appropriate level from the bottom of the worksheet.

DOWNLOAD – For Excel 2010 or later (.xlsx)

DOWNLOAD – 2003 Microsoft Excel xls


Scroll to Top