Organizational chart by department rather than individual

[thorntocon]

Hello,

I am creating organizational charts using the wizard, and taking the data
from an excel file I have created with fields containing:

"name"
"reports to"
"department"
"subdepartment"

and I would like to be able to automatically (or semi-manually as a last
resort) construct charts that construct themselves based on the department
first and then focus on users.

I can create a similar effect by adding users named after the departments
and constructing a hierarchy for them (ie have the head of HR report to a
user called "Human Resources" who in turn reports to "OVERHEADS") but this
gives me problems when looking at anyone with a split authority structure
(say someone who was 30% allocated to Human Resourcesn and 70% another part
of the company) as higher up the line the user is reporting in to a different
user.

I hope this makes sense, if anyone needs me to clarify any further please
feel free to ask me to elucidate, look forward to your responses!

Thanks.

 

[David J Parker]

If you are using Visio 2007 Pro, then you can use a PivotDiagram for this.

 

[thorntocon]

sadly i should have mentioned i'm on 2003, but also looking at the function
you've described i'm not entirely sure whether it would do what i'm after.
could you explain exactly how a pivot diagram would make it work. i would
need the reporting line to function as well as being able to group by fields
like department etc.