The Visio wizard only recognizes one reporting path, so you could get around
it by creating a John-A and a John-B.
Alternately, you could create an extra field in the users record in Excel
called AlternateBoss. This can then be added to the Shape Data/Custom
Properties of the individual. Now the fun part. You can then write some VBA
code to find individuals that have an alternate boss and create a line
between them and their alternate bosses. You can then export the orgchart
and the AlternateBoss will be preserved. Of course, the next time you import
the list, the alternate boss reporting lines will be gone, but you can
recreate them with the VBA code you used the first time.
I did a blog three years ago about changing the reporting line patterns that
should give you some ideas for the code.
http://msmvps.com/blogs/visio/archi...-Orgchart-with-different-reporting-lines.aspx
I will blog in more detail on how to have an alternate boss.
John...
in message news:
[email protected]...