Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 780
  • Last Modified:

Link Excel Sheet Data to Visio Graphics

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
-Polak
Asked:
-Polak
1 Solution
 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperCommented:
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
 
-PolakAuthor Commented:
Thanks Again Scott. "Automatic linking" and "Show this dialog box on open" were key in doing what I needed.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now