Exploring trends and developments
in project management today.

Project Smart Logo

Subscribe  Follow Project Smart on Twitter!

How to Create a Gantt Chart Using Microsoft Excel

A Gantt chart is a popular bar chart that aims to show the timing of tasks or activities as they occur across time. Although the Gantt chart did not initially show the relationships between activities, this has become more common in current use as both timing and interdependencies between tasks can be identified.

Since the initial introduction of Gantt charts, they have become an industry standard as a key project management tool for showing the phases, tasks and activities that are scheduled as part of a project over time.

This video presentation is a step by step guide to creating a Gantt chart using Microsoft Excel 2007.

Please Install Flash Player

Comments page 2 of 2
Click here to add a comment
Jolie
Posted 11 days ago
Brilliant, it was very straightforward, you showed all the key things one should be concerned with when quickly pulling together a simple but meaningful Gantt chart. Thanks much!
SaMtHEoVERmiND
Posted 13 days ago
thx so much
Ki
Posted 22 days ago
Brilliantly explained. Thank you.
Wendy
Posted 32 days ago
This was extremely helpful. Saved me heaps of time! Thanks.
Shana-Kaye
Posted 46 days ago
The example of how to create the ghant was amazing becaues i had no idea the first thing i was suppose to do thanks for the help alot
Karen
Posted 51 days ago
FINALLY!!! A website with great instructions!
Jennifer Mason
Posted 106 days ago
Brilliant. Just what I needed. Despite using Excel 2008 for Mac (menu items located differently), I had no problems at all and found everything I needed with minimal searching. Thanks so much!
Bill Gates
Posted 107 days ago
Fantastic and really well explained, Thank you very much.
Kirk Trewin
Posted 141 days ago
Really good and clear to understand and very well presented. The graphics were excellent and easy to follow. I adapted the demo for Excel 2003 version and it works a treat. Best on the net.....and i have tried a few.
James
Posted 142 days ago
Thanks for the video. Good pace and clearly explained.
Mark
Posted 162 days ago
Thanks!

The explanations clearly stated what needed to be done.
This is exactly the type of instructions I was looking for in order to set up a proper Gantt chart
Jon
Posted 164 days ago
wow, the expanding uses of excel.
Cheers though v useful
peter Isiko Waiswa.,ACCA
Posted 203 days ago
This is very helpful in managing a project.
Chris Bishop
Posted 238 days ago
I was not familiar with a Gantt chart until I started this project so many thanks.
 

Article Categories

Related Articles

Project Planning A Step by Step Guide
The key to a successful project is in the planning. Creating a project plan is the first thing you should do when undertaking any kind of project. Often project planning is ignored in favour of getting on with the work. However, many people fail to realise the value of a project plan in saving time, money and many problems.

How to Plan and Schedule More Complex Projects
Gantt charts are useful tools for analysing, planning and controlling projects. When a complex or multi-task project is under way, Gantt charts assist in monitoring whether the project is on schedule, or not. If not, the Gantt chart allows you to easily identify what actions need to be taken in order to put the project back onto schedule.

17 "Must Ask" Questions for Planning Successful Projects
Why do some projects proceed without a hitch, yet others flounder? One reason could be the type and quality of the questions people ask at the very start. This article suggests 17 insightful queries that can expose the uncertain aspects of your project, and thereby help you avoid expensive surprises later. You can thus achieve your project goals with much less guesswork and far fewer problems than you may have experienced in the past.

21 Ways to Excel at Project Management
The popular project management e-book now fully updated and available as a website for the first time.