Tuesday, September 8, 2015

Gantt Chart Template Excel 2010

A Gantt chart template is included in my Master Project Management Template file that I give away as a free gift for joining my email list. I have a new and improved version that is a bit more user friendly and simply better to look at.
gantt chart template excel 2010

A Gantt chart is a bar chart that shows the tasks of a project, when each must take place, and how long each will take. As the project progresses, bars are shaded to show which tasks have been completed. People assigned to each task can also be represented. Gantt Charts are also called a Milestone Chart, Project Bar Chart, or Activity Chart.

How to Use the Gantt Chart Template

Follow the steps listed below to use the template spreadsheet:

1. Enter up to 30 tasks in the cells provided.
2. Enter the Start Date for each task and the number of days to complete it.
3. Enter the Percent Complete for each task. This is required, even if 0%.

Watch the video below to see the Gantt Chart Template Excel 2010 in action.



When to Use Gantt Chart

The list below shows the ideal time to use a Gantt chart:
  • When scheduling and monitoring tasks within a project.
  • When communicating plans or status of a project.
  • When the steps of the project or process, their sequence and their duration are known.
  • When it’s not necessary to show which tasks depend on completion of previous tasks.
This chart is very easy to use and can be quite helpful when managing a large project. Download the template by clicking the link below:


How often do you use Gantt Charts? I’d love hear about your experience so please let me know in the comments below.