Solved

Link Excel Sheet Data to Visio Graphics

Posted on 2010-08-17
2
774 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
[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
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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

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 I’ll describe a mashup of containers and lists that meet a real-world need. Prior to reading this ar…
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…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

628 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