From the course: Advanced Visio Desktop: Working with Data

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Link to multiple data sources

Link to multiple data sources

From the course: Advanced Visio Desktop: Working with Data

Start my 1-month free trial

Link to multiple data sources

- [Instructor] In many cases, linking a Visio diagram to a single data source is sufficient. But if the data you want to incorporate into your diagram resides in multiple locations, or even in multiple types of data sources, Visio is up to the task. Let's start by looking at two different data sources. First is server data in Excel. Notice column A, the network name. That's the key that we'll use to link these rows of data to the shapes in the Visio diagram. Let's close this workbook. And look at network equipment data in Access. You see data for a wireless access point and a one gigabit router. Here's the diagram to which we'll link data. At the moment, the shapes in the diagram contain just one data field with a value in it, the network name. On the data tab is the custom import button in Visio 2016. In previous versions of Visio, this button was labelled link data to shapes. Either way, when you click it, you see the data selector wizard. We will choose Excel as our data source…

Contents