✦Template Printable Ideas Insights

Effortlessly Create an Organization Chart in Visio from Excel

By

Visualizing your organization's structure is crucial for effective communication and understanding of roles and responsibilities. Microsoft Visio's powerful tools allow you to create detailed and informative organizational charts (org charts), and one of the most convenient ways to start is by importing data from Excel. Here's a step-by-step guide on how to make an org chart in Visio from Excel.

First, ensure you have both Microsoft Visio and Excel installed on your computer. For this guide, we'll be using Visio 2019 or newer and Excel 2010 or newer. We'll also assume you have your organizational data already formatted in an Excel worksheet.

Preparing Your Data in Excel

Before you start, make sure your Excel data is structured for org chart creation. You'll need at least three columns: one for the manager's name, one for the employee's name, and one for the employee's title or role.

How to Make an Org Chart in Excel (+ video tutorial)
How to Make an Org Chart in Excel (+ video tutorial)
How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial
How to Create the Organizational Chart You Know Your Business Needs | Process Street | Compliance Operations Platform
How to Create the Organizational Chart You Know Your Business Needs | Process Street | Compliance Operations Platform

Here's an example of how your data should look:

ManagerEmployeeTitle/Role
John DoeJane SmithMarketing Specialist
Jane SmithMike JohnsonSEO Specialist

Sorting and Filtering Your Data

To ensure your org chart is well-structured, sort your data by the 'Manager' column. This will help Visio automatically generate the correct hierarchy when you import the data.

How to Make Org Charts in PowerPoint, Word, Teams, Excel & Visio
How to Make Org Charts in PowerPoint, Word, Teams, Excel & Visio
How to Create an Organizational Chart Linked to Data in Excel (Easy & Dynamic)
How to Create an Organizational Chart Linked to Data in Excel (Easy & Dynamic)
a computer screen with an arrow pointing to the text boss how did you make this org chart?
a computer screen with an arrow pointing to the text boss how did you make this org chart?

You can also use filters to hide any data you don't want to include in your org chart. For example, if you only want to show employees from a specific department, you can add a 'Department' column and filter by that column.

Creating the Org Chart in Visio

Now that your data is ready, it's time to import it into Visio and create your org chart.

First, open Microsoft Visio and select 'Organization Chart' from the 'Recent' or 'Templates' section. This will open a new organization chart with a blank page ready for your data.

How to Create Org. Charts in Excel linked to your Data
How to Create Org. Charts in Excel linked to your Data
How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial
an excel chart with two smiley faces and the word excel in green on top of it
an excel chart with two smiley faces and the word excel in green on top of it
Visio Pro 2013 Training: How to Link Org Charts to Excel Data
Visio Pro 2013 Training: How to Link Org Charts to Excel Data
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
Create Organization Chart in Excel
Create Organization Chart in Excel

Importing Your Excel Data

Click on the 'Data' tab in the ribbon, then click on 'From Excel'. Navigate to your Excel file, select the worksheet containing your data, and click 'OK'.

Visio will import your data, and you should see your organization chart begin to take shape. If your data was sorted by the 'Manager' column, Visio will automatically create the correct hierarchy.

Customizing Your Org Chart

Now that you have your basic org chart, it's time to customize it to your needs. You can add shapes, change colors, and add fields to display additional information about each employee.

Organogram Template | Creately
Organogram Template | Creately
How To Create Charts and Graphs in Excel
How To Create Charts and Graphs in Excel
31+ Free Organogram Templates & Organizational Charts
31+ Free Organogram Templates & Organizational Charts

To add or modify fields, select the data source pane on the left-hand side of your screen. From here, you can add or remove fields, change the field names, or adjust the field width.

You can also click on individual shapes to add or modify them directly. Right-clicking on a shape will bring up a menu with options to edit the shape's text, add or remove fields, or change the shape's style.

Reviewing and Refining Your Org Chart

Once you've customized your org chart, take some time to review it and make any necessary adjustments. You can zoom in and out using the slider in the bottom-right corner of the screen, or use the 'View' tab to switch between different viewing modes.

If you notice any errors or omissions in your data, you can right-click on a shape to 'Update Data', which will pull in the latest information from your Excel file.

Remember, creating an org chart is an iterative process. Don't be afraid to make changes, add or remove data, or adjust the layout to fit your needs.

Once you're satisfied with your org chart, you can save it, print it, or export it as a PDF or image for easy sharing. Congratulations, you've just created a professional and informative org chart using Microsoft Visio and your Excel data!

Now that you've mastered the basics of creating an org chart in Visio from Excel, why not try experimenting with different chart types, adding more data fields, or even linking your chart to live data? The possibilities are endless!