Gantt Chart Using Excel

4545 Words Mar 21st, 2013 19 Pages
Project-Management with Gantt-Charts
OpenOffice.org 2.0 Calc

[Projekt-Management und Gantt-Diagramm mit OpenOffice.org 2.0 Calc and Comment créer un diagramme de Gantt avec OpenOffice.org] [1.1] First editions: [2005-06-06 and 2003-01-03] First English edition: [2005-11-09]

Contents

Contents
Contents..............................................................................................................................................1 Copyright and trademark information................................................................................................2 Feedback........................................................................................................................................2
…show more content…
In this simple example there is the name of the task, the start-date and the duration in calendar days:

Illustration 2: Task list

This simplified project consists of eight subtasks “Task 1” to “Task 8”. Next, begin creating the chart by selecting Insert—Chart:

Illustration 3: Create the chart

From the dialogue “AutoFormat Chart” define the selection range. Neither the first row (containing the column label) nor the first column (containing the task name) should be included as data.

Project-Management with Gantt-Charts

2

Starting the Process

Click “Next >>” , and choose the Chart type:

Illustration 4: Choose chart type

Choose the horizontal bar-chart and click “Columns” to indicate that the data are arranged in columnar form.
Note: This changes the assignment of the axis in OpenOffice.org Calc. Now the horizontal axis is called “Y” and the vertical axis is called “X”.

Click “Next >>” and choose the variant “Stacked”:

Illustration 5: Create chart with stacked bars

Project-Management with Gantt-Charts

3

Starting the Process

Click “Next >>” once again and enter chart and axis titles:

Illustration 6: Adapt chart labeling

The first Gantt Chart appears as follows:

Illustration 7: Bar chart

The task names are on the vertical axis (“Task 1” to “Task 8”) and the time line is on the horizontal axis.

Project-Management with Gantt-Charts

4

Converting the simple bar-chart into a Gantt chart

Converting the simple

More about Gantt Chart Using Excel

Open Document