Create Gantt Charts in Excel
The Excel Gantt Chart Template Deluxe Edition makes it
easy to create professional-looking Gantt charts in Microsoft Excel.
Three separate Gantt chart templates are included with
your purchase:
Daily: Manage projects and tasks from one day to 255 days in
duration.
Weekly: Manage projects and tasks from one week to four
years in duration.
Monthly: Manage projects and tasks from one month to 20
years in duration.
Most Flexible Excel Gantt Chart Template On The
Market
The Excel Gantt Chart Template Deluxe Edition is
extremely flexible and easy to use.
The newly-designed interface makes it easy to change
display options, colors, dependent task reporting, percent complete calculation
and more.
Non-US users can easily switch from US to UK/Australia
date formats using a simple drop-down menu.
Easy To Use and No Learning Curve
The Excel Gantt Chart Template Deluxe Edition is very easy to use.
To get started with your first Gantt chart, you simply need to enter a few
pieces of information:
1. Enter the start and end dates for the overall project
and for each task.
2. Assign a responsible person or team
member to each task (Optional).
3. Enter dependent tasks
(Optional).
4. Customize your options. (Choose your color
scheme and indicate whether to show dependent tasks and calculate percent
complete percentages for your tasks.)
5. Choose how many tasks to show on your Gantt chart. (Users may choose to
show 25, 50, 75 or 100 tasks using a specially-designed drop-down list.)
That's it. Your Excel Gantt charts are created automatically based on the
information you entered. The entire process takes just minutes to complete.
Best of all, there is virtually no learning curve. If you
know how to use Microsoft Excel, you can use the Excel Gantt Chart Template
Deluxe Edition to create Gantt charts immediately.
The Excel Gantt Chart Template Deluxe Edition is the perfect
solution for quickly and easily creating Gantt charts in Excel.
The Excel Gantt Chart Template Deluxe Edition requires Excel 2003 or 2007 to run on Windows or Excel 2004 or 2008 to run on a Mac.
Be sure to select the appropriate file type and license when making your
purchase.
It is fully compatible with Windows 7, Vista, Windows XP, and Mac OSX.
About Gantt Charts
Many people are not aware of what a Gantt chart is, the history of Gantt charts,
why Gantt charts are used, how to make a Gantt chart, and why
you should be using Gantt charts to manage
projects. This page is dedicated to answering some of those questions.
What is a Gantt chart?
The Gantt Chart definition from the American Heritage® Dictionary of the English
Language, Fourth Edition
is:
A chart that depicts progress in relation to time, often used in
planning and tracking a project.
MSN Encarta, an online encyclopedia from Microsoft, provides a slightly
different definition:
scheduling chart; a chart in which horizontal
lines show the actual and projected amounts of time involved in completing a
particular task or reaching specific levels of production.
Both definitions are accurate and useful. The Gantt chart definition
provided by American Heritage is more descriptive of the purpose of a Gantt
chart while the MSN Encarta definition is more interested in the nuts and bolts
of how Gantt charts are presented.
Gantt Chart History
The Gantt chart was conceived and developed by Henry L. Gantt, an American
engineer and inventor who pioneered the fields of project management and
management consulting.
Henry Gantt was very interested in worker productivity and industrial
efficiency, and developed charts to help him measure these qualities. Gantt was
the inventor of the task and bonus system of paying employees and supervisors.
Managers were paid more for effectively training their employees to do tasks
more efficiently and a chart similar to the one we now know as a Gantt chart was
used to measure worker productivity. Specific tasks were measured over specific
time frames, much like the Gantt charts we use today.
Gantt used his talent to help Bethlehem Steel become dominant in steel
production and distribution. He later worked with the U.S. government, helping
them to streamline their shipbuilding process in preparation for World War I.
The US government later used Gantt charts in its major construction projects,
such as the Hoover Dam and the Interstate Highway System. Most branches and
departments in the US government still use Gantt charts today.
Born in Calvert County Maryland, Gantt attended Johns Hopkins University and
lived from 1861-1919.
Why Use a Gantt Chart?
The best reason to use a Gantt chart is clarity.
Rather than writing down your tasks and trying to visualize in your mind what
tasks need to be done and when, creating a Gantt chart allows you to take that
picture from your mind and make it tangible. It is literally a picture of your
project plan from start to finish.
A timeline is stretched across the top of the page.
Tasks are listed down the left side of the page.
Horizontal lines extend from left to right across the page. The horizontal line
for each task starts below the timeline value that corresponds with the start
date/time of the task. The length of the line grows as the length of time
allocated for completing the task grows. It ends below the timeline value that
corresponds with the end date/time of the task.
A picture of a Gantt chart is below. Click on the image for a larger view:
Isn't it much easier to conceptualize a project using a chart like the one above
rather than using text notes and task details?
Text notes and detailed task descriptions have their place (mainly when it comes
time to do the individual task) but Gantt charts are invaluable for visualizing
your project plan.
How To Make a Gantt Chart
There are several ways to create a Gantt chart:
1. Drawing - This is the most simple solution. Simply draw the chart by creating
a time line across the top of the page and listing each individual task down the
left side of the page. Extend horizontal lines from left to right for each task.
Begin the horizontal line under the timeline value that corresponds with the
start date/time of the task. End the horizontal line under the timeline value
that corresponds with the end date/time of the task.
2. Microsoft Project (or similar comprehensive project software) - Software
programs like MS Project allow you to manage complex projects and create charts.
These programs are very detailed and extremely expensive (hundreds to thousands
of dollars). They also take a very long time to learn. If you are technically
inclined and money is no object, you may want to look at a solution like MS
Project.
3. Microsoft Excel - This is an often overlooked tool that can be very useful
for managing a project. You can set up the dates across the top of the page,
list your tasks in the left margin and fill in the intersecting cells depending
on each task length. You can also use conditional formatting, which was
introduced in Excel 2003, to set up smart logic that will allow you to
automatically create Gantt charts. The advantages of this option are its low
price and wide compatibility. In addition to using Excel to create Gantt charts,
you may wish to consider purchasing a commercial
Excel Gantt chart template that
would confer the benefits of low-cost and compatibility but would also save you
time.
Why You Should Use Gantt Charts To Manage Projects
Clarity: Never wonder what needs to be done and when it needs to be
done. Having lots of loose notes or even a text outline can lead to doing tasks
in the wrong order or spending more time on tasks than you should. When you use
a Gantt chart, your entire project plan is presented visually. You will always
know what you should be doing, when you should be doing it, and how long you
should be spending on each task.
Communication: Sometimes we need to share our project plans
with other stakeholders. These stakeholders could be management, employees,
vendors, contractors or anyone else involved in creating and managing your
project. Presenting them with a visual depiction of your project plan is much
easier than trying to explain the project verbally or in writing. Gantt charts
are invaluable communication tools, especially since we now live in a very
visual and media-driven society.
Organization: A Gantt chart can help you stay organized.
Creating a Gantt chart forces you to plan a project from start to finish. This
causes you to get organized and gets you thinking about each individual task and
how they relate to the project as a whole. The organizational benefit of going
through the Gantt chart creation process can not be overstated.
Reduced Stress: When you are able to see your entire project
plan in front of you and can visualize each individual task as it relates to the
overall project, you will not feel stressed or overwhelmed. You will see a
finite start and end date for each task and for the overall project. You will
feel organized and in control of the project in a way that you might not
otherwise feel.
Impressive: If you have a boss, investors or anyone else who
you wish to "buy in" to your project plan, creating a Gantt chart can do wonders
for your cause. It is always impressive when someone walks in with a visual
depiction of a project plan in the form of a Gantt chart. It shows that you are
organized, serious, and committed to the project management process. No amount
of text communicates your project plan better than showing someone a Gantt
chart.
Conclusion
We hope you have enjoyed reading about Gantt charts. If there is any information
that you feel we should add to this page, please let us know. We firmly
believe in the value of Gantt charts in managing projects and communicating your
project plans to others.
Happy Gantt Charting!
Related Terms:
Excel
Gant Chart Templates
Excel
Gannt Chart Templates
Gant
Chart Excel Templates
Gannt
Chart Excel Templates
