7 Replies Latest reply: Aug 17, 2015 4:52 AM by Andy Weir RSS

    How can I visualize multiple reporting lines and organization levels ?

      I have been trying to graphically represent a data set which has name s of employees in rows with their department and related data in columns. In the columns there is also data on the reporting level (say N is the head of the organization, then N-2 all report to N and N-2 reports to N-1 level and so on. My data is on on single excel file. I was wondering how to build a  pyramidal graph where I can determine the span of control for each level etc., besides a overview of the levels. Can anyone help here  ?