Hi,
I have been given a task to create an organisation chart for over 2,000 employees in Excel because it can then be presented in a specific format (effectively I am using grouping to expand and collapse rows to show how the hierarchy flows).
This is extremely time consuming and inefficient, albeit the final result is easy for people to work through (the first view for instance show the function head and his direct reports; by expanding to level 2 you see all their direct reports and this continues as you get to the lowest level - 8 levels in my case).
Is there anyway that this can be replicated in a more efficient way in Excel? I was looking at Power Pivot, but I am not sure how data would need to be ordered to achieve being able to see someone as an employee, and then in the next level his reports.
Any thoughts or guidance most welcome.
I have been given a task to create an organisation chart for over 2,000 employees in Excel because it can then be presented in a specific format (effectively I am using grouping to expand and collapse rows to show how the hierarchy flows).
This is extremely time consuming and inefficient, albeit the final result is easy for people to work through (the first view for instance show the function head and his direct reports; by expanding to level 2 you see all their direct reports and this continues as you get to the lowest level - 8 levels in my case).
Is there anyway that this can be replicated in a more efficient way in Excel? I was looking at Power Pivot, but I am not sure how data would need to be ordered to achieve being able to see someone as an employee, and then in the next level his reports.
Any thoughts or guidance most welcome.
