how do you automate an Org chart drawing?

[pablofonto]

Hello,
Does anyone know how to automate an org chart drawing that has more than one
executive (report to)?
I tried using the wizard running it from an Excel file, but it only allows
you to have one executive (report to). I've asked quite a few people already
and no one seems to know how to do this. Please help!

thanks,

Pablo

 

[Mark Nelson [MS]]

The Organization Chart Wizard supports only one superior reporting
relationship.

 

[jamclash]

True. And I'm not sure I'm helping address your question but, I found you can
"trick" Visio into allowing more than one reporting relationship.
It's not anything amazing but what I do is change, ever so slightly, the
name of the person that Reports to more than one superior. For example, say
you have 1 person that reports to 3 different "superiors." Give each of the 3
people a unique name: Such as, Jane Doe1 (reports to superior X), Jane Doe2
(reports to superior Y), and Jane Doe3 (reports to superior Z). Of course,
Jane Doe 1, 2, and 3 are the same person.
Once the excel document is complete, save and close it. Open Visio
Organization Wizard, choose "Information I have already stored on a
database," go through the prompts to finish.