Gantt-Chart-Project-Management-Template

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 3

Project Management using Excel - Gantt Chart Template

Pointy Haired Dilbert http://chandoo.org/wp

Planned Actual % Show Gantt for Actual Show Status?


# List of Start Dur Start Dur Done 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
1 Activties
Activity 1 1 5 1 2 0%
2 Activity 2 1 5 1 6 58%


███
██

3 Activity 3 2 4 2 5 35%
4 Activity 4 4 8 2 6 10%
5 Activity 5 4 1 3 8 0%
6 Activity 6 4 3 4 6 0%
7 Activity 7 5 4 4 3 0%
8 Activity 8 5 2 4 5 0%
9 Activity 9 5 2 4 6 0%
10 Activity 10 6 5 6 7 0%
11 Activity 11 6 1 7 8 0%
12 Activity 12 9 3 8 3 0%
13 Activity 13 9 6 8 6 0%
14 Activity 14 9 3 9 1 0%
15 Activity 15 9 4 9 4 0%
16 Activity 16 10 5 10 2 0%
17 Activity 17 11 2 10 5 0%
18 Activity 18 12 6 11 7 0%
19 Activity 19 12 1 11 5 0%
20 Activity 20 14 5 11 6 0%
21 Activity 21 14 8 11 1 0%
22 Activity 22 14 7 11 3 0%
23 Activity 23 15 4 12 8 0%
24 Activity 24 15 5 14 3 0%
25 Activity 25 15 8 14 5 0%
26 Activity 26 16 8 15 1 28%

██
27 Activity 27 17 2 15 2 60%

████
28 Activity 28 17 1 16 8 25%


29 Activity 29 17 5 16 3 5%
30 Activity 30 18 1 16 3 16%
31 Activity 31 18 1 17 4 3%
32 Activity 32 19 6 18 7 41% █



33 Activity 33 19 6 21 5 31%
34 Activity 34 21 8 22 7 0%
35 Activity 35 21 1 23 3 0%
36 Activity 36 23 4 24 6 0%
37 Activity 37 24 1 24 3 0%
38 Activity 38 24 6 24 5 0%
39 Activity 39 24 7 24 8 0%
40 Activity 40 24 3 24 2 0%

4 Sign up for e-mail updates and get more charting tutorials


4 Add my RSS to your reading list
4 Follow PHD on Twitter

4 Visit Pointy Haired Dilbert Excel Tips Blog 4


te

What is current week? 3

21 22 23 24 25 26 27 28 29 30 31 32


Symbols to be used
Types of Gantt for % complete
Planned █
Actual ↓

You might also like