Gantt Chart Project Plan Template

The Excel Gantt Chart is a powerful Project Plan template used by a Project Manager to plan and manage a project, and illustrate it in an easy-to-understand graphic project timeline.

 

on home page

Gantt training video
Download free trial

View Demo

Gantt Chart for Project Management

 

Like every other Systems2win template, the Gantt Chart template comes with a project plan sample containing extensive on-line help and training - so that your Project Manager can devote her valuable time to actually planning and managing the project.

For pop-up help with your Gantt Chart Software, simply click any row or column heading on any Systems2win template.

 

 

 

Use Excel's powerful filtering features to analyze usage of time and money for any given resource or combination of project resources (using filters such as equal to, greater than, begins with, does not end with, contains, does not contain, AND, OR, etc.)

Notice that resource usage analysis is in some ways more powerful than most Project Management software, because you can analyze both Effort (in hours) and Duration (in days).

And the Gantt Chart now features Work Calendar Adjustment factors -
to easily consider holidays and weekends in your project plans.

Why not download a trial version, and see how it works?

 

New features in version 5

Drop-down data validation for People, Resources, Work Calendar Adjustment Factors, and Grid Lines.

Header rows repeat at the top of each printed page.

Chart axis labels at both top & bottom. And chart line shows Today's date.

One-click button to Set Project Start Date and change grid lines.

Many new ease of use features, including easier handling of long comments, easier numbering for Work Breakdown Structure numbers, more & better help...

New Systems2win menu appears when you open Excel.
* Several easy ways to find & open templates.
* New stencil of Link Icons - more icons - easier to use.
* New flag icons - to easily link to multi-language documents.
* Smaller file sizes - because stencils of shapes are no longer duplicated in each workbook.

Code separated from data. Most code has been separated into add-ins (rather than embedded in each workbook). Benefits:
* Easier upgrades. From now on, you will usually be able to take advantage of upgrades without transferring data from your old working documents to your new templates.
* Update anytime. You can update your add-in code at any time, [and upgrade your (personalized) templates when you upgrade].
* Easier for your IT Dept to ensure compliance with your License Agreement, by preventing accidental distribution of templates to unlicensed users.

Easily sync templates in each local PC with master templates in your S2winPortal. Benefits:
* Easily distribute personalized templates to all of your users.
* You can even use our Sync system to distribute your own (non-Systems2win) personalized templates!
* Laptop users can always have access to your company's templates - even when disconnected from your network.

Even better compatibility with more versions of Windows and Excel.
* Better support for Excel 2007.
This template requires Excel 2000 or higher, and has known issues with Excel 2007.
* Better support for International languages, and international versions of Windows and Office.

See more in What's New
and the What's New in Version 5  27 minute video



Drop-down data validation
for People, Resources, and more


One-click button
to set Project Start Date
and change grid lines


Stencil of Link Icons
to easily insert hyperlinks to related documents


Flag icons
to link to Work Instructions
in multiple languages

Gantt chart software comparison
   of Systems2win to other Gantt Chart Software

Comparison Systems2win Other
Written in Excel Unfamiliar language
Cost per user $100 per user
or FREE with CI tools
View pricing
$499 per user
Upgrades As compared with traditional software, Systems2win Excel templates are remarkably cost effective when evaluated from the perspective of lifetime ownership
Ability to share with non-licensed users Printed paper or PDF Printed paper or PDF
Auto-draws Gantt Chart Yes Yes
Line shows "Today" Yes Yes
Analyze filtered data Yes
 Superior to MS Project, because you can analyze both
Effort (in hours) and Duration (in days)
filtered by people, resources, costs, % complete...
Yes
Task Usage
Unlimited comments per line Yes Yes
Unlimited hyperlinks per line Yes Yes
Graphic hyperlinks - easy to see, to understand, and to use Yes
using Link Icons
Either No
or not near as nice
Drop-down list of user-defined codes for unlimited people and resources Yes Yes
Color-coded phases, tasks, milestones, resources, etc. Yes Yes
Percent complete displayed in Gantt bar colors Yes Yes
Calculate start date, end date, or duration for any line item Yes Yes
Define simple or complex predecessor relationships
(e.g. this task starts 5 days after another ends)
Yes
with all the power of Excel's formulas
and even ability to link to outside data sources
Yes
with limited math
Multi-layered levels of details Yes
Easily hide & unhide rows.
All the calculation power of Excel to create
Phase and Milestone summaries.
Yes
Collapsible outline auto-summarizes lower-level tasks
Easily hide excessive details Yes
hide columns & rows
Yes
hide columns
& collapsible outline
Calculate costs Yes
Columns and math for quantity x cost per line item, plus all the power of Excel to define your own math functions
Yes
Practically unlimited size Yes
Excel supports 16,000 rows,
and Gantt Chart can expand to any size
Yes
Adjust schedule for your calendar of working days and holidays Yes
Using Work Calendar Adjustment factors
Download Trial & see how it works
Yes
Most difficult learning curve 1) You can't just Insert Rows.
You need to copy a blank row - so that your new row has all the same formulas and formatting hidden beneath all the
other (apparently) blank rows.

2) If you are using Excel 2007,
you will need to manually resize the chart to line up
when you insert, hide, or unhide rows

Everything else is "just Excel". Everything your people know about Excel they can apply here; everything they learn here, they can apply to anything else they do with Excel

New users must learn an entirely new application
Extensive on-line training Yes (both text and video on-line training - free) Yes

Reasons you might want to step up to more expensive Project Management Software
(or... if you can live without these features, then why spend the extra thousands?)

Comparison Systems2win Other
Define grid lines Yes, but only using whole numbers.
E.g. 7 days = a week. 30 days is close to a month.
Yes. Advanced time-based gridline capabilities
Header rows repeat at top of each printed page Yes
but only for columns - not chart
Chart has axis labels at top and bottom
Yes
Auto-numbering of complex Work Breakdown Structure numbers No
Just use Edit > Fill Series for (automatic) simple numbering,
or manually enter complex numbers
Yes
Auto-number options include outline format
(e.g. 1.1, then 1.1.1)
Select multiple colors for Gantt chart bars All Gantt chart bars will be the same two colors
for complete vs. incomplete.
You can, however define those 2 colors.
Yes
Display predecessor relationships on the chart No Yes
Critical path analysis No Yes
Calendar view No Yes
Earned Value Management No Yes
Manage resources across multiple projects No
Theoretically, you could use Excel formulas to do this, but if you are managing more than a couple projects that need to share resources, you should probably step up to full-featured Project Management software
Yes

 

 

Project Management template software that every team leader can use and every team member can share

Even if your company already owns a few expensive seats of a proprietary project management software application, (like Microsoft Project, or Primavera), wouldn't it be nice to have a Gantt chart that everyone else can use?

This Gantt Chart Excel template and Project Management tools can be purchased separately for...
   $100 a seat (5 seat minimum)
or comes FREE with purchase of 2 or more seats Continuous Improvement tools
 

View pricing

After viewing our Gantt Chart training video,
you can call a live expert to answer your questions
toll free 866-475-4111

International
+615-553-2336

Download free trial

View Demo

Gantt Chart Excel - now that's a good idea!