Unofficial Excel Stuff

Book

Suggestions

Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal

Thursday, June 05, 2008 – Permalink –

Gantt-PERT

Project Charts

The Gantt chart was developed by Henry L. Gantt around 1910. The chart shows a project's status, but not how one task depends on another.

In the 1950's, the Navy developed PERT (Program Evaluation Review Technique) charts. A similar process is called the Critical Path Method (Analysis) or CPM (A).

The terms PERT, PERT/CPM, and CPM are often interchanged.

A PERT chart looks more like a flow chart than a graph.

BaRaN Sytems has some clear examples:
Project for Excel

Here's an example of a Gantt chart being constructed using an open source product called GanttProject :
Flash Demo

John F. Lacher has created a nice example of how to create a Gantt chart.
This one is appropriate for scheduling rooms, resources, and time.

A sample can be downloaded and customized.
Lacher24.XLS

Also see:

Simple Gantt chart
Gantt-type chart on a worksheet using conditional formatting

And

Microsoft Knowledgebase:
How to Create a Gantt Chart Using Hours as the Scale
Visual Basic Module to Create Gantt Chart

Jon Peltier:
Gantt Chart Links
Gantt Googled

You can use Microsoft Project to create PERT and Gantt charts.

See all Topics
excel
Labels: Charts

<Doug Klippert@ 6:11 AM

Comments: Post a Comment