Correctly importing shape types Visio 2016 org chart
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
|