[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 782
  • 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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