Results 1 to 2 of 2

Thread: Span of Control

  1. #1

    Span of Control

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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?

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts