This content has been marked as final. Show 7 replies
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 ?