Milestone and task project timeline.xlsx

	B	C	D	E	F	G	J
1
2
3
4							TIMELINE TEMPLATES by Vertex42.com
5							https://www.vertex42.com/ExcelTemplates/timeline.html
6
7
8							Tips for Using this Template
9							• Insert and delete entire rows when editing the data tables
10							• Avoid leaving the label column blank
11							• Format the horizontal axis to set min/max bounds
12							• Enter a vertical position between -100 and 50
13							• Format individual data labels or markers to highlight specific events
14
15
16							Other Notes
17							• Milestone leader lines are Y Error bars
18							• Task leader lines are Y Error bars
19							• Task durations are X Error bars
20
21
22
23
24
25
26
27
28	Tasks
29	Start	End	Duration	Label	Vert. Position	Vert. Line
30
31	3/28/2018	4/11/2018	15	Task 1 Mar 28 - Apr 11	-25	-25
32	4/12/2018	5/1/2018	20	Task 2 Apr 12 - May 1	-40	-15
33	5/2/2018	5/25/2018	24	Task 3 May 2 - May 25	-55	-15
34	4/28/2018	7/12/2018	76	Task Label 4	-80	-80
35	6/15/2018	7/4/2018	20	Task Label 5	-30	-30
36	7/5/2018	8/3/2018	30	Task Label 6	-45	-15
37	8/10/2018	9/10/2018	32	Task Label 7	-20	-20
38	9/11/2018	9/15/2018	5	Task Label 8	-60	-40
39	9/16/2018	10/6/2018	21	Task Label 9	-75	-15
40				Insert new rows above this one
41
42	Milestones
43	Date			Label	Position
44
45	4/2/2018			Start, Apr 2	30
46	5/25/2018			Milestone #1	25
47	8/3/2018			Milestone #2	20
48	10/6/2018			Deliver, Oct 6	15
49				Insert new rows above this one
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