Creating a org chart

[Ashutosh]

In my organisation, one supervisor controls several departments. Example,
John manages Finance, Legal and Purchase departments. I want to generate
separate org charts for each of the departments. When I use the Wizard, it
gives me all of John's reportees together in one sheet without separating
them by function. I have to then manually delete and create separate sheets
for each department. My database is in the form of an Excel spreadsheet, with
a separate field for department. How do I do this? Please help !!

 

[John... Visio MVP]

In my organisation, one supervisor controls several departments. Example,
John manages Finance, Legal and Purchase departments. I want to generate
separate org charts for each of the departments. When I use the Wizard, it
gives me all of John's reportees together in one sheet without separating
them by function. I have to then manually delete and create separate
sheets
for each department. My database is in the form of an Excel spreadsheet,
with
a separate field for department. How do I do this? Please help !!

Create dummy employees (Finance, Legal and Purchase) and have these three
report to John and all the employees in these departments report to these
dummies.

John... Visio MVP