charting a project overview

[Joel Nylund]

Is there a simple way to build a chart to show a overview of multiple
projects
including their milestones.

For example I have
Project A, B, C.

Each project has milestones 1, 2, 3, 4, 5, 6 each with start and end
dates.

I would like to chart these projects where each project has a bar (or
set of bars) and each milestone has a subbar (assuming no overlap).
The x axis would
be the dates.

for example:
My Projects:

Project1 (show bar of milestone1) (bar of milestone2) (bar of
milestone 3) ....
project2 (show bar of milestone1) (bar of milestone2) (bar of
milestone 3) ..
project3 (show bar of milestone1) (bar of milestone2) (bar of
milestone 3) ..

--------Jan------FEB-------MAR-------APR--------MAY--------JUN--------JUL---

I can figure out how to do project 1,2,3 with 1 bar for each, but I
cant figure out how to have sub-bar's for each milestone.

(please email reply as well)
thanks in advance
Joel

 

[Jon Peltier]

Joel -

A gantt chart is a floating bar chart, which means a stacked bar chart,
with the first bar formatted to be invisible (no border, no lines).
Stack three series, not two (two visible series). Let the data look
like this (Project and Task show the duration in days of the project and
task level items):

Start Project Task
Project 1 12/10/03 9
Task 1a 12/10/03 6
Task 1b 12/15/03 3
Task 1c 12/16/03 3
Project 2 12/10/03 25
Task 2a 12/10/03 10
Task 2b 12/20/03 12
Task 2c 12/30/03 5

Make yourself a stacked bar chart, and make the Start series invisible.
The Project column will chart the roll ups from the Task column.

- Jon

 

[Tushar Mehta]

If you want to automate the Gantt chart maintenance, check the Gantt
Chart add-in available from my web site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions