Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-06-2017, 06:19 AM
macleodal macleodal is offline Correctly importing shape types Visio 2016 org chart Windows 10 Correctly importing shape types Visio 2016 org chart Office 2016
Novice
Correctly importing shape types Visio 2016 org chart
 
Join Date: Mar 2017
Posts: 2
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 Correctly importing shape types Visio 2016 org chart Windows 10 Correctly importing shape types Visio 2016 org chart Office 2013
Experienced User
 
Join Date: Jun 2010
Location: Virginia Beach, VA
Posts: 742
JimP will become famous soon enough
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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Correctly importing shape types Visio 2016 org chart 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
Correctly importing shape types Visio 2016 org chart How do I lock shape positions in Visio 2010 redwards60 Visio 1 08-11-2015 05:41 AM
Correctly importing shape types Visio 2016 org chart [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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:12 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft