Solved

Automating Org Charts in Visio 2003

Posted on 2009-05-12
1
715 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
1 Comment
 
LVL 30

Accepted Solution

by:
Scott Helmers earned 500 total points
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Visio 2010 - 4 357
SharePoint Visio 1 176
How to default an arrow head  connector in Visio 2 413
Visio configuration 2 12
Periodically someone asks me whether there’s a way to automatically convert all of the pages in a Visio drawing to PowerPoint slides. There have even been a few times when I’ve wanted to do that myself but I never really had enough incentive to figu…
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…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video discusses moving either the default database or any database to a new volume.

762 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now