Excel Gantt Chart Template

A gantt chart is a common tool for project planning and keeping track of the status of individual tasks within a project. This type of chart was invented in 1910 by a mechanical engineer named Henry Gantt, and there are now a great many software tools that use gantt charts in project planning. Excel is a popular tool for creating simple Gantt charts, but for more advanced project management activities, you may need a tool such as Microsoft Project or a project management add-in for Excel.

In a time crunch? For simple project schedules and timelines, download the free Excel Gantt Chart Template below and get started planning in a matter of minutes. At the bottom of the page are links to other great Excel gantt charts and resources. While planning a project, you may also find it useful to refer to a yearly calendar.


Excel Gantt Chart Template
Screenshot
Excel Gantt Chart Template

Easily create and print a Gantt Chart with this Excel spreadsheet by entering the start date, duration, and percent complete for any number of tasks and subtasks. Add additional tasks by copying and pasting rows. A single chart displays up to 11 months (weekends excluded). A slider bar allows you to easily adjust the range of dates displayed, so that you can create plans spanning a year or more.

(No Macros)
Download the Excel Gantt Chart Template Download Now

File Type: .xls
Size: ~50 KB
Version: 1.2
Required: Microsoft Excel XP/2003
License: Free for personal and business use (Not for Resale or Distribution)

Help support Vertex42.com
(Not Tax-Deductible)

Other Free Gantt Chart Spreadsheets


Gantt Chart Links - peltiertech.com
A great list of Gantt Chart links, compiled by Jon Peltier's, including links to a lot of other gantt chart spreadsheets.


Gantt Charts in Excel - hyperthot.com, by James Chapman.
This page includes a few free gantt chart downloads for Excel that also calculate spend plan. This is done by including labor costs broken down by employee and the number of hours spent on each task.

Commercial Gantt Chart Software


Microsoft Project 200X - Office.Microsoft.com
Although a bit pricey, this really is the ultimate software for creating gantt charts and project timelines, partly because it is widely used and therefore you can probably find someone in your office that knows how to use it if you have questions.


Easy Gantt Chart Software - SmartDraw.com
Create Gantt charts fast, with the templates in SmartDraw. See their site for examples.

References:



Excel Templates