Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Visio

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-06-2017, 06:19 AM
macleodal macleodal is offline Windows 10 Office 2016
Novice
 
Join Date: Mar 2017
Posts: 1
macleodal is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 03-06-2017, 01:17 PM
JimP JimP is offline Windows 10 Office 2013
Experienced User
 
Join Date: Jun 2010
Location: Virginia Beach, VA
Posts: 691
JimP is on a distinguished road
Default

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.)
Reply With Quote
Reply

Tags
org chart, visio 2016
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Visio 2016 diagrams embeded in word 2016 not drawing properly stubbo66 Visio 2 08-24-2016 05:58 PM
Problem with loading a CDialog-window in a Visio Add-on Visio 2016 tknijff Visio 0 01-08-2016 08:41 AM
How do I lock shape positions in Visio 2010 redwards60 Visio 1 08-11-2015 05:41 AM
[Visio 2007] How to disable predefined data types? fsgs Visio 2 11-25-2010 03:11 AM
VISIO - Formatting Shape Data Details TABLE Lora Visio 0 07-19-2010 12:15 PM


All times are GMT -7. The time now is 09:51 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft