EXCEL 制作的甘特图

[Project Name]

[Company Name]

Today's Date:Thursday

(vertical red line)

Project Lead:Start Date:Wednesday

[42]

First Day of Week (Mon=2):

2

WBS Tasks

Task Lead Start

End

D u r a t i o n (D a y s )

% C o m p l e t e

W o r k i n g D a y s

D a y s C o m p l e t e

D a y s R e m a i n i n g

1Task Category 1John

1-05-091-06-0920%2021.1Sub Task level 21-05-091-05-0910%1011.2Sub Task level 21-05-091-05-0910%1011.2.1Sub Task level 31-05-091-06-0920%2021.2.2Sub Task level 31-05-091-05-0910%1011.3Sub Task level 21-05-091-05-0910%1011.4Sub Task level 21-05-09

1-05-0910%1012Task Category 2Jane 1-05-091-11-09725%5162.1Sub Task level 21-05-091-11-09725%5162.2Sub Task level 21-05-091-11-09725%5162.3Sub Task level 21-05-091-11-09725%5162.4Sub Task level 21-05-09

1-11-09725%5163Task Category 3Bill 1-05-092-07-093450%2517173.1Sub Task level 21-12-091-17-09650%5333.2Sub Task level 21-19-091-24-09650%5333.3Sub Task level 21-26-091-31-09650%5333.4Sub Task level 22-02-09

2-07-09650%5334Task Category 4Bill 1-05-091-05-0910%1014.1Sub Task level 21-05-091-05-0910%1014.2Sub Task level 21-05-091-05-0910%1014.3Sub Task level 21-05-091-05-0910%1014.4

Sub Task level 2

1-05-09

1-05-09

1

0%

1

1

17 - O c t - 11

2011-8-25

23 - M a y - 11

30 - M a y - 11

25 - A p r - 11

02 - M a y - 11

09 - M a y - 11

16 - M a y - 11

28 - N o v - 11

31 - O c t - 11

07 - N o v - 11

14 - N o v - 11

21 - N o v - 11

19 - S e p - 11

24 - O c t - 11

26 - S e p - 11

03 - O c t - 11

10 - O c t - 11

12 - D e c - 11

20 - J u n - 11

27 - J u n - 11

04 - J u l - 11

11 - J u l - 11

08 - A u g - 11

15 - A u g - 11

12 - S e p - 11

05 - S e p - 11

22 - A u g - 11

2011-1-5

John Doe 05 - D e c - 11

06 - J u n - 11

18 - J u l - 11

25 - J u l - 11

01 - A u g - 11

29 - A u g - 11

13 - J u n - 11

Gantt Chart Template by https://www.360docs.net/doc/7314068208.html,

? 2008 Vertex42 LLC