Solved

Automating Org Charts in Visio 2003

Posted on 2009-05-12
1
747 Views
Last Modified: 2012-05-06
Hi we are trying to get Visio 2003 to automatically create our companies org charts using an extract from our HR system.

We have googled the solution to death and have changed our data numerous times to try and solve this problem.  but to no avail.

When we get the error message, we can either pick yes or no, picking yes, gives us just one box on the org chart for the managing director.  If we pick no, we get a blank chart.

The Spreadsheet with the data in has 907 rows of data.
Visio1.jpg
screenshot159.jpeg
0
Comment
Question by:Martyn1971
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 30

Accepted Solution

by:
Scott Helmers earned 500 total points
ID: 24373965
The Visio 2007 help text is reasonably straightforward on this subject:
   http://office.microsoft.com/en-us/visio/HA101057641033.aspx?pid=CH100985551033#3

I think the key is these three bullet points:
  • Employee name  The way that employee names appear in  this field is the way that they appear on the organization chart shapes.  
  • Unique identifier If each name is not unique,  include a column with a unique identifier, such as an employee ID number, for  each employee.  
  • Whom the employee reports to  This field must contain  each manager's unique identifier, whether that identifier is a name or an ID  number. For the employee at the top of the organization chart, leave this field  blank.
In your case, the employee name field is unique so you don't need a separate unique ID field. It looks to me like the problem with your data is that the entries in the Reports To column don't match the unique employee names.

For example, the Reports To entry for "Sales & Service Manager" should be "Post - 1" (assuming that he/she reports to the MD). Does that make sense?
0

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The ability to add structure to Visio diagrams using containers, lists and callouts is one of my favorite features in Visio 2010. In this article we’ll examine lists. We’ll explore containers and callouts in separate articles. Prior to reading th…
Book Review: Using Microsoft Visio 2010 by Chris Roth   Disclaimer: The author of Using Visio 2010 is a friend and fellow Visio MVP. Whether you’re new to Visio or are upgrading to Visio 2010 from a previous version, you will find a lot to like…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question