Solved

Link Excel Sheet Data to Visio Graphics

Posted on 2010-08-17
2
769 Views
Last Modified: 2012-06-22
I'm currently using Visio to import an Org. Chart via an excel sheet that is correctly formatted to do so.

Is there any way that I can make the org chart data dynamically link to the excel sheet after importing? Effectively "Link" the cells to the graphics so that when I make a change in excel it is reflected in Visio?
0
Comment
Question by:-Polak
2 Comments
 
LVL 30

Accepted Solution

by:
Scott Helmers earned 500 total points
ID: 33459634
Yes, you can link each org chart shape to the data in Excel. You just need to ensure that each person has a unique value that you can use for linking. This might be the person's full name, or even better, an employee number of other guaranteed-unique ID.

You can check out the data linking feature in several ways  via online demos and tutorials at Microsoft. Demo:

Look for Data Linking I and IV  tutorials here:

One  more useful link with concise instructions for using data linking:
Regards,
Scott
 
0
 
LVL 1

Author Comment

by:-Polak
ID: 33477707
Thanks Again Scott. "Automatic linking" and "Show this dialog box on open" were key in doing what I needed.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

David Parker’s latest book, Microsoft Visio 2010: Business Process Diagramming and Validation, will give you the tools to turn flowcharts and other business diagrams into valuable, data-driven corporate assets. Armed with the knowledge you’ll gain f…
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 containers. We’ll explore lists (http://www.experts-exchange.com/Microsoft/Applications/M…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

785 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