Hi,

Trying to import a datafile from Excel to build an org chart. There seems to be little or no documentation on this other than the most trivial.

I started by drawing a dummy org chart using all the position types I need (manager, executive, position, vacancy, assistant, etc) and exporting it; Visio creates a column in the data file called "Master_shape" and gives it a number 1, 2, 3 etc for each type. Since there is no documentation, I created my own x-ref (e.g. 0 = 'executive').

I then used my own staff file (names, reporting lines, department etc) and to this I added a column with the same name exactly.. "Master_shape".. and included the numbers 0-5 as above according to which type of position it should appear as.



However. No matter what I put, the import makes all positions the same. The "top exec" is automatically shown as an exec, any position with reports is shown as a manager, and all others (whether assistant, vacancy, consultant, etc) are shown as a regular position.

If I have to manually change all the non-standard positions, I may as well not have an automated import! So there MUST be a way.

Anyone know how to do this?

Thanks

Because of the limited number of users in this Visio forum, you may want to visit http://visguy.com/vgforum/ to address your issue. (I have no experience beyond the 2010 version.)