Omer_K

Board Regular
Joined
Apr 9, 2017
Messages
76
Hello everyone
I have 2 columns
Timeline column - for this purpose, each period indicates a number of days
The second column is the name of the employee who works during that period.
It can be as you can see that the employee works for several periods of time.
So I create a pivot table that count each period and employee.


I would like to display a timeline so that on the x-axis I will see the periods (column of the time axis) while on the Y axis I will see the workers.


I tried everything,
I will be happy to help you friends ...

Omer

Excel 2016 (Windows) 32 bit
A
B
C
D
E
F
G
H
I
J
K
L
1
Person
TimeLine
2
3
Period 4
4
TimeLine TimeLine
5
Period 4 PersonPeriod 1Period 2Period 3Period 4 Period 5Period 6Empty
6
Period 3
2​
1​
3​
1​
7
Period 3Adam Nguyen
1​
8
Harry SmithAlexander Thompson
2​
9
Oliver JohnsonAlfie Brown
1​
10
Jack WilliamsPeriod 4 Archie White
4​
5​
2​
11
Alfie BrownPeriod 4 Benjamin Harris
5​
1​
12
Oliver JohnsonCallum Rivera
1​
1​
13
Oliver JohnsonCharlie Jones
1​
14
Jack WilliamsConnor Mitchell
2​
15
Oliver JohnsonDaniel Wilson
1​
10​
1​
16
Charlie JonesPeriod 4 Dylan Lee
2​
17
Oliver JohnsonEdward Flores
1​
18
Thomas GarciaEthan Hernandez
1​
19
Jacob MillerFinley King
1​
20
Oliver JohnsonFreddie Adams
1​
1​
1​
21
Oliver JohnsonHarrison Torres
3​
2​
1​
22
James DavisPeriod 4 Harry Smith
1​
23
Joshua RodriguezHarvey Phillips
1​
24
Oliver JohnsonHenry Ramirez
4​
2​
1​
25
William MartinezPeriod 5Isaac Allen
2​
2​
26
Jack WilliamsJack Williams
5​
14​
27
Jack WilliamsJacob Miller
1​
28
Joshua RodriguezPeriod 3Jake Lewis
2​
29
William MartinezPeriod 5James Davis
1​
30
Jack WilliamsJamie Carter
1​
31
William MartinezPeriod 5Jayden Young
3​
1​
32
Jack WilliamsPeriod 4 Joseph Moore
2​
33
Jack WilliamsPeriod 4 Joshua Rodriguez
1​
1​
2​
34
Jack WilliamsLeo Clark
2​
3​
2​
1​
35
Ethan HernandezLewis Hill
5​
36
Period 4 Liam Baker
1​
37
Joshua RodriguezPeriod 4 Logan Robinson
2​
38
Oliver JohnsonLucas Sanchez
1​
7​
39
Luke Green
1​
1​
1​
40
Thomas GarciaMason Wright
1​
1​
41
Thomas GarciaMatthew Nelson
1​
42
Joshua RodriguezPeriod 4 Max Martin
3​
2​
43
Jack WilliamsPeriod 4 Michael Evans
1​
44
Riley GonzalezMohammed Jackson
2​
1​
45
Daniel WilsonPeriod 3Muhammad Perez
2​
46
Daniel WilsonPeriod 3Nathan Turner
1​
47
Daniel WilsonPeriod 3Noah Thomas
11​
2​
1​
48
Daniel WilsonPeriod 3Oliver Johnson
9​
49
Daniel WilsonPeriod 3Oscar Taylor
1​
2​
50
Daniel WilsonPeriod 3Riley Gonzalez
1​
51
Daniel WilsonPeriod 3Ryan Scott
1​
52
Daniel WilsonPeriod 3Samuel Anderson
1​
53
Daniel WilsonPeriod 4 Sebastian Campbell
1​
54
Samuel AndersonTheo Roberts
1​
55
Noah ThomasThomas Garcia
3​
56
Noah ThomasToby Gomez
1​
57
Noah ThomasTyler Walker
3​
2​
58
Noah ThomasWilliam Martinez
1​
21​
59
Noah ThomasZachary Hall
1​
1​
60
Noah ThomasEmpty
1​
2​
2​
61
Noah Thomas
62
Noah ThomasPeriod 5
63
Noah Thomas
64
Noah Thomas
65
Noah Thomas
66
Noah Thomas
67
William MartinezPeriod 5
68
William MartinezPeriod 5
69
Oscar TaylorPeriod 4
70
Oscar TaylorPeriod 3
71
Oscar TaylorPeriod 4
72
Joseph MoorePeriod 5
73
Joseph MoorePeriod 5
74
Mohammed JacksonPeriod 3
75
Mohammed JacksonPeriod 3
76
Jack WilliamsPeriod 4
77
Jack WilliamsPeriod 4
78
Jack WilliamsPeriod 4
79
Jack WilliamsPeriod 4
80
Jack WilliamsPeriod 4
81
Mohammed JacksonPeriod 5
82
Max MartinPeriod 3
83
Max MartinPeriod 3
84
Max MartinPeriod 4
85
Max MartinPeriod 4
86
Dylan Lee
87
Dylan Lee
88
89
Muhammad Perez
90
Max MartinPeriod 3
91
Alexander ThompsonPeriod 4
92
Archie WhitePeriod 3
93
Benjamin HarrisPeriod 5
94
Daniel WilsonPeriod 3
95
Daniel WilsonPeriod 3
96
Period 1
97
Archie WhitePeriod 1
98
Archie WhitePeriod 1
99
Lucas SanchezPeriod 5
100
Leo ClarkPeriod 5
101
Henry RamirezPeriod 5
102
Jake LewisPeriod 4
103
Logan RobinsonPeriod 5
104
Tyler WalkerPeriod 3
105
Logan RobinsonPeriod 5
106
Jake LewisPeriod 4
107
Jack WilliamsPeriod 4
108
Archie WhitePeriod 1
109
Archie WhitePeriod 1
110
Archie WhitePeriod 2Period 3
111
Lucas SanchezPeriod 5
112
Lucas SanchezPeriod 5
113
Archie WhitePeriod 2Period 3
114
Period 3
115
Lucas SanchezPeriod 5
116
Archie WhitePeriod 2Period 3
117
Lucas SanchezPeriod 5
118
Lucas SanchezPeriod 5
119
Lucas SanchezPeriod 5
120
Archie WhitePeriod 2Period 3
121
Lucas SanchezPeriod 4
122
Archie WhitePeriod 2Period 3
123
Benjamin HarrisPeriod 3
124
Benjamin HarrisPeriod 3
125
Jayden YoungPeriod 1
126
Jayden YoungPeriod 1
127
Benjamin HarrisPeriod 3
128
Benjamin HarrisPeriod 3
129
Benjamin HarrisPeriod 3
130
Period 3
131
Period 3
132
Archie WhitePeriod 3
133
Alexander ThompsonPeriod 4
134
Isaac AllenPeriod 4
135
Henry RamirezPeriod 2Period 3
136
Finley KingPeriod 4
137
Henry RamirezPeriod 2Period 3
138
Leo ClarkPeriod 2Period 3
139
Leo ClarkPeriod 4
140
Leo ClarkPeriod 3
141
Jack WilliamsPeriod 4
142
Leo ClarkPeriod 3
143
Tyler WalkerPeriod 3
144
Henry RamirezPeriod 2Period 3
145
Jack WilliamsPeriod 4
146
Jack WilliamsPeriod 4
147
Mason WrightPeriod 1
148
Jack WilliamsPeriod 4
149
Ryan ScottPeriod 4
150
Noah ThomasPeriod 4
151
Harrison TorresPeriod 5
152
Harrison TorresPeriod 4
153
Harrison TorresPeriod 4
154
Mason WrightPeriod 3
155
Noah ThomasPeriod 4
156
Leo ClarkPeriod 3
157
Harrison TorresPeriod 5
158
Harrison TorresPeriod 4
159
Isaac AllenPeriod 4
160
Adam NguyenPeriod 4
161
Lewis Hill
162
Lewis Hill
163
Lewis Hill
164
Lewis Hill
165
Lewis Hill
166
Edward FloresPeriod 1
167
Luke GreenPeriod 3
168
Luke GreenPeriod 4
169
Luke GreenPeriod 5
170
Freddie AdamsPeriod 6
171
Leo ClarkPeriod 2Period 3
172
Jayden YoungPeriod 1
173
Isaac AllenPeriod 1
174
Isaac AllenPeriod 1
175
Freddie AdamsPeriod 3
176
William MartinezPeriod 2Period 3
177
William MartinezPeriod 5
178
William MartinezPeriod 5
179
William MartinezPeriod 5
180
William MartinezPeriod 5
181
William MartinezPeriod 5
182
William MartinezPeriod 5
183
William MartinezPeriod 5
184
William MartinezPeriod 5
185
William MartinezPeriod 5
186
William MartinezPeriod 5
187
William MartinezPeriod 5
188
William MartinezPeriod 5
189
William MartinezPeriod 5
190
William MartinezPeriod 5
191
William MartinezPeriod 5
192
Matthew Nelson
193
William MartinezPeriod 5
194
Liam BakerPeriod 2Period 3
195
Muhammad Perez
196
Henry RamirezPeriod 4
197
Tyler WalkerPeriod 2Period 3
198
Tyler WalkerPeriod 2Period 3
199
Tyler WalkerPeriod 2Period 3
200
Freddie AdamsPeriod 2Period 3
201
Jayden YoungPeriod 3
202
Henry RamirezPeriod 2Period 3
203
Daniel Wilson
204
Zachary HallPeriod 3
205
Zachary Hall
206
Callum RiveraPeriod 4
207
Sebastian CampbellPeriod 3
208
Callum RiveraPeriod 5
209
Harrison TorresPeriod 6
210
Henry RamirezPeriod 4
211
Connor Mitchell
212
Connor Mitchell
213
Leo ClarkPeriod 4
214
Jamie CarterPeriod 3
215
Theo RobertsPeriod 3
216
Toby Gomez
217
Harvey Phillips
218
Michael EvansPeriod 4
219
Nathan Turner
Sheet: Data
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Watch MrExcel Video

Forum statistics

Threads
1,108,986
Messages
5,526,065
Members
409,685
Latest member
Davetom

This Week's Hot Topics

Top