Span of Control

jiwolff

New member
Joined
Aug 1, 2013
Messages
1
Reaction score
0
Points
0
Hello - I am trying to figure out how I can take the data I have in a normal excel spreadsheet and gather the span of control for my organziation. So for instance I have Manager 1 who has 12 direct reports of those 12 , 11 of them each have their own direct reports and so on. I need to build this so that I show the span of control for each person who has direct reports. Any idea on how to accomplish this?
 

JeffreyWeir

Super Moderator
Staff member
Joined
Mar 22, 2011
Messages
357
Reaction score
0
Points
0
Location
New Zealand
Do you want to build an org chart? Or just have a table that shows the nested levels underneath? You can build an org chart using the SmartArt option. A pivottable will let you do the 2nd. I suggest you give Google a spin for more detailed instructions.
 
Top