Create Gant Chart

Project Planning and Gantt Charts
W. Durfee, Oct-08
Project Planning Basics
A “Project” is a set of activities which ends with specific accomplishment and which has (1) Non-routine
tasks, (2) Distinct start/finish dates, and (3) Resource constraints (time/money/people/equipment).
“Tasks” are activities which must be completed to achieve project goal. Break the project into tasks and
subtasks. Tasks have start and end points, are short relative to the project and are significant (not “going to
library”, but rather, “search literature”). Use verb-noun form for naming tasks, e.g. "create drawings" or
"build prototype". Use action verbs such as "create", "define" and "gather" rather than "will be made".
Each task has a duration. Very difficult to estimate duration accurately. Doubling your best guess usually
works well.
“Milestones” are important checkpoints or interim goals for a project. Can be used to catch scheduling
problems early. Name by noun-verb form, e.g. "report due", "parts ordered", "prototype complete".
Your plan will evolve so be flexible and update on a regular basis. It also helps to identify risk areas for
project, for example things you don't know how to do but will have to learn. These are risky because you
may not have a good sense for how long the task will take. Or, you may not know how long it will take to
receive components you purchased for a project.
Gantt Chart Basics
Gantt charts are a project planning tool that can be used to represent the timing of tasks required to
complete a project. Because Gantt charts are simple to understand and easy to construct, they are used by
most project managers for all but the most complex projects.
In a Gantt chart, each task takes up on row. Dates run along the top in increments of days, weeks or
months, depending on the total length of the project. The expected time for each task is represented by a
horizontal bar whose left end marks the expected beginning of the task and whose right end marks the
expected completion date. Tasks may run sequentially, in parallel or overlapping.
As the project progresses, the chart is updated by filling in the bars to a length proportional to the fraction
of work that has been accomplished on the task. This way, one can get a quick reading of project progress
by drawing a vertical line through the chart at the current date. Completed tasks lie to the left of the line
and are completely filled in. Current tasks cross the line and are behind schedule if their filled-in section is
to the left of the line and ahead of schedule if the filled-in section stops to the right of the line. Future tasks
lie completely to the right of the line.
In constructing a Gantt chart, keep the tasks to a manageable number (no more than 15 or 20) so that the
chart fits on a single page. More complex projects may require subordinate charts which detail the timing
of all the subtasks which make up one of the main tasks. For team projects, it often helps to have an
additional column containing numbers or initials which identify who on the team is responsible for the
task.
Often the project has important events which you would like to appear on the project timeline, but which
are not tasks. For example, you may wish to highlight when a prototype is complete or the date of a design
review. You enter these on a Gantt chart as “milestone” events and mark them with a special symbol, often
an upside-down triangle.
A sample Gantt chart, made in Excel, appears at the end of this document. If today’s date were May 13,
Task A would be behind schedule, Task B ahead and Task C right on schedule. The events marked by ‘-M-
’ are milestones.
Computer-based Gantt charts
There are many software packages dedicated to project planning. One of the most popular is Microsoft
Project. If you have access to Project (for IT students at the University of Minnesota, Project is installed on
PCs in the ITlabs ), you should try it out because it is very easy to use, making simple Gantt charts is a
breeze, and you can add it as a skill on your resume.
Here is how to make a Gantt chart.
On a piece of scrap paper, make a list of tasks and assign each task tentative start and stop dates (or
duration) and the people responsible for the task. Also list important milestones and their dates. If you have
more than 15 or 20 tasks, split your project into main tasks and subtasks, then make an overall Gantt chart
for the main tasks and separate Gantt charts for the subtasks which make up each main task.
Decide what resolution to use in the timeline. For projects of three months or less, use days, for longer
projects use weeks or months, and for very short project use hours. For these instructions, we will assume
you have chosen a resolution of days.
Enter the information in MS-Project.
Or, as a last resort, use Excel. After starting Excel, under Page Setup, select landscape orientation, center
the chart horizontally and vertically on the page and activate the “fit to one page” button. (Note that if the
text comes out too small, you may have to print your chart on two pages and paste together. Even better,
adjust the resolution of your date scale or drop less important tasks to make your chart fit comfortably on
one page.) Set up the cells using the sample as a guide. Enter appropriate data.
As the project progresses, fill in the light colored bars with solid to denote the fraction of a task that is
completed.
Sample Gantt chart in MS Project