Easy Gantt Chart Template
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Start Date
End DateTimeline
2
Project EagleJan-1Jul-1
Default Color
StatusData Argument: { Array aka "list" of Values } Options Argument: { Key-Value pairs for option parameters }
3
Task 1Jan-1Mar-5tealComplete{ int($B3)-int($B$2),int(C3)-int($B3) }
{"charttype","bar";"color1","white";"color2",if(F3="Complete","lightgrey",if(today()>C3,"orange",E3));"empty","zero"; "max",int($C$2)-int($B$2)}
4
Task 2Mar-10May-10aquaComplete{ int($B4)-int($B$2), int(C4)-int($B4) }
{"charttype","bar";"color1","white";"color2",if(F4="Complete","lightgrey",if(today()>C3,"orange",E4));"empty","zero"; "max",int($C$2)-int($B$2)}
5
Task 3Mar-10Oct-20tealComplete{ int($B5)-int($B$2), int(C5)-int($B5) }
{"charttype","bar";"color1","white";"color2",if(F5="Complete","lightgrey",if(today()>C3,"orange",E5));"empty","zero"; "max",int($C$2)-int($B$2)}
6
Task 4May-10Apr-18purpleOverdue{ int($B6)-int($B$2), int(C6)-int($B6) }
{"charttype","bar";"color1","white";"color2",if(F6="Complete","lightgrey",if(today()>C3,"orange",E6));"empty","zero"; "max",int($C$2)-int($B$2)}
7
Task 5Oct-20Jan-12tealIn Progress{ int($B7)-int($B$2), int(C7)-int($B7) }
{"charttype","bar";"color1","white";"color2",if(F7="Complete","lightgrey",if(today()>C3,"orange",E7));"empty","zero"; "max",int($C$2)-int($B$2)}
8
9
Other ExamplesUpcoming Color >>teal(this one is crazy)
10
Highlight Current Day (Past Task)
Oct-11Nov-11purpleIn ProgressIF(int(today()<B10),SPARKLINE({int(today())-int($B$2),1,int(B10)-int(today()), INT(B10)-1-int(C10)},{"charttype","bar";"color1","white";"color2",if(F10="Complete","grey",E10);"empty","zero"; "max",int($C$2)-int($B$2)})
, IF(today()>C10,SPARKLINE({int(B10)-int($B$2),int(C10)-int($B10),int(today()-int(C10)),1},{"charttype","bar";"color1","white";"color2",if(F10="Complete","grey","orange");"empty","zero"; "max",int($C$2)-int($B$2)})
, SPARKLINE({int(B10)-int($B$2),int(B10)-int(today()),1, int(today())-1-int(C10)},{"charttype","bar";"color1","white";"color2",if(F10="Complete","grey",if(today()>C10,"orange",E10));"empty","zero"; "max",int($C$2)-int($B$2)})))
11
Highlight Current Day (Present Task)
Jul-1Jul-1purpleIn Progress
12
Highlight Current Day (Future Task)
Jan-10Jan-1purpleUpcoming
13
Week Marker{ int(today())-int($B$2)-weekday(today()), 7 }{"charttype","bar";"color1","white";"color2","yellow";"empty","zero"; "max",int($C$2)-int($B$2)}
14
Burndownint(today())-int($B$2){"charttype","bar";"color1","grey";"empty","zero"; "max",int($C$2)-int($B$2)}
15
16
17
Please make your own copy of the spreadsheet.
To copy the spreadsheet, go to File and click, Make a copy...
If you have any questions, feel free to contact me at @realTrevorFaux.
18
19
20
21
22
23
24
25
26
27
28
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
Loading...
Main menu