ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Purpose
2
The purpose of this dashboard is to see a a glance the overall health of the team. If this is monitored and action taken, you should see reduced voluntary and involuntary turnover, and more engaged teams.
3
4
Instructions
5
1
Check departments to determine which make sense for you. This is a drop down so to edit go to data, data validation, list and edit there, save.
6
2
Fill in employee names. If you're using my employee time tracking list you will have the list there to bring over.
7
3
Add the data for what's there or customize the headings but make sure you do it on the Q tabs and the combined data tab
8
4
This is set up for quarters, but you could copy the tabs and turn it into monthly. You will need to go to the combined data tab and update the formulas to include each tab.
9
5
You can change the icons by going to insert icon and searching and pressing delete on the ones that are there.
10
6
To change chart colors, double click and off to the right you'll see a menu appear, you can choose the paint bucket and change any of the colors.
11
7
If you find the data labels don't show a value it may be the font is too big, you can either click on them and change font size or press delete
12
8
If you need more rows, click in the middle and right click to insert, so that you don't have to update formulas. Always verify but this is a way around that.
13
14
15
16
17
18
Sample
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