Solved

Link Excel Sheet Data to Visio Graphics

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A recent Visio zone question asked how to use the data in an Excel file to create a Visio Gantt chart -- and then to dynamically update the Gantt chart. The good news is that the Viso Gantt Chart wizard can be automated. The bad news is that the…
Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

734 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