Skip to main content
Skip to main content
Microsoft 365

Data-linked diagrams: Creating a diagram

Yana Terukhova is a Product Marketing Manager on the Microsoft Visio team.

Visio offers over 60 types of professional templates to build compelling diagrams, and organization charts are among most the frequently created. Visio organization charts are simple and visual, but what if you want to connect them to key business indicators tracked by your organization, such as sales by region, budget by department, vacation status, or training progress? Sometimes this information is located in another source, like Excel or  a complex database. Data-linked diagrams let you add data to Visio diagrams–no code required–and anyone in an organization can quickly create such dashboards to get better insights into data using Visio Professional 2013 or Visio Pro for Office 365.

Build an organization chart from Excel data

We’ll start with an organization chart diagram like this one.

The data you add to the organization diagram can be in an Excel file, populated from Exchange/Active Directory, or constructed manually by dragging shapes on a page.

Tip: if you pull data from Active Directory or Exchange, you must have Outlook installed and configured with an active profile–the requirement is a MAPI connection. Visio uses MAPI to get data, so if you don’t have one, the data import will fail.

In this example, the Excel file has three columns: Name, Title and Reports To. Visio uses this information to determine how to organize the reporting relationships in your organization chart.

From the Visio start screen, select or search for Organization Chart.

Once the wizard starts, select Information that’s already stored in a file or database. Then you can tell Visio what columns have your hierarchy information and where to import pictures from, if you have them.

 You can specify a folder with your pictures, and as long as there is a field that Visio can match to (such as Name). Visio will automatically associate them with the correct organization chart shape.

Once you’re finished, you’ll have an organization chart that looks like this:

Change the design of a diagram

Now you can click the Org Chart tab on the ribbon and make changes to reflect what you’re looking for, including spacing and other variants.

In this case, we used the Coin design to add a splash of color:

Although this example focuses on mapping departments of people, you can use the Organization Chart Wizard to map all sorts of hierarchical data–a website map, for example–as long as you can clearly format that data in Excel.

Yana Terukhova, Product Marketing Manager

You may also like these articles

Image for: Small business professional working on designs using devices running PowerPoint and Microsoft Teams.

Power your digital transformation with insights from Microsoft Productivity Score

Editor’s Note: The Mechanics video embedded in this blog post has been updated to reflect some of the product changes announced on December 1, 2020. For some time now, business leaders have made digital transformation a priority. But when the pandemic hit this spring, adopting and embracing digital technology went from being a matter of…

Image for: A man is using his Lenovo laptop like a tablet while sitting in a comfortable chair in a Modern office setting

Microsoft Productivity Score and personalized experiences—here’s what’s new to Microsoft 365 in October

As I reflect on an action-packed few weeks, I’m struck by how much work has evolved in these past months. And I know our customers feel it too. After quickly moving to remote and hybrid work models this spring, organizations are now seeking sustainable ways to help people collaborate, be productive, and prioritize their wellbeing…

Image for: Microsoft employees working remotely.

Working remotely during challenging times

A Shanghai-based Microsoft employee shares lessons of working remotely during the COVID-19 outbreak.