Gantt Chart Template

	A	B	C	D	E	F	G	H	I
1	Simple Gantt Chart Template					How to use this Template?
2	Here is the simple Gantt Chart Template in Google Sheets Format. You can copy and use this template for creating Gantt Chart. Please note, the format of x axis in he chart. It is date value as the google sheets not supporting the custom formats in the charts axis.					You can create a copy of this template by Clicking on Make a Copy command from File Menu
3	You can download free and premium from Analysistabs templates from the below page:
4		https://analysistabs.com/project/management/templates/
5	You can move the Chart to see the complete Gantt Chart Data and Formulas.
6
7		Task	Start Date	End Date	Progress	StartNumber	Total Days	Completed	Pending
8		Your Task 1	1/1/2017	5/21/2017	50%	0	141	70.5	70.5
9		Your Task 2	1/10/2017	9/21/2017	50%	9	255	127.5	127.5
10		Your Task 3	2/3/2017	8/6/2017	71%	33	185	131.35	53.65
11		Your Task 4	2/23/2017	6/20/2017	45%	53	118	53.1	64.9
12		Your Task 5	4/2/2017	7/11/2017	40%	91	101	40.4	60.6
13		Your Task 6	2/7/2017	6/1/2017	40%	37	115	46	69
14		Your Task 7	3/25/2017	10/1/2017	40%	83	191	76.4	114.6
15		Your Task 8	3/25/2017	6/20/2017	35%	83	88	30.8	57.2
16		Your Task 9	1/8/2017	10/24/2017	30%	7	290	87	203
17		Your Task 10	3/7/2017	7/23/2017	70%	65	139	97.3	41.7
18		Your Task 11	2/11/2017	7/16/2017	100%	41	156	156	0
19		Your Task 12	3/18/2017	5/24/2017	80%	76	68	54.4	13.6
20		Your Task 13	2/19/2017	6/18/2017	50%	49	120	60	60
21		Your Task 14	1/14/2017	8/10/2017	45%	13	209	94.05	114.95
22		Your Task 15	1/5/2017	6/24/2017	50%	4	171	85.5	85.5
23		Your Task 16	3/2/2017	7/14/2017	100%	60	135	135	0
24		Your Task 17	3/28/2017	7/10/2017	60%	86	105	63	42
25		Your Task 18	4/3/2017	7/1/2017	60%	92	90	54	36
26		Your Task 19	5/3/2017	9/24/2017	70%	122	145	101.5	43.5
27		Your Task 20	6/25/2017	9/19/2017	50%	175	87	43.5	43.5
28		Overall Status	1/1/2017	10/24/2017	54.10%	Completed		Pending
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100