✦Template Printable Ideas Insights

Create Org Chart from Excel Data

By

Creating an organizational chart (org chart) is an essential part of structuring and understanding your team's hierarchy and roles. Fortunately, you can create an org chart from data in Excel with ease. This guide will walk you through the process, from preparing your data to generating your org chart.

Before we dive in, ensure your data is structured correctly in Excel. You'll need columns for at least 'Name', 'Title', and 'Manager's Name' (to indicate the direct reporting line). Let's get started!

Preparing Your Data

Your first step is to organize your data in Excel. This involves ensuring all necessary information is present and accurate.

Create Org Chart
Create Org Chart
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)
How to Make an Org Chart in Excel (+ video tutorial)
How to Make an Org Chart in Excel (+ video tutorial)

Here's a simple way to structure your data:

  1. Name: The full names of your team members.
  2. Title: Their job titles or roles.
  3. Manager's Name: The name of the person they report to directly.

Handling Data Irregularities

You might encounter null values under 'Manager's Name', especially for top-level executives. For now, leave these as-is.

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
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?
How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial

Similarly, if someone reports to multiple people (shared line management), you can list these names separated by commas, then clean up later.

Creating Your Org Chart

Now that your data is in order, it's time to create the org chart. We'll use a simple, free tool called ExcelOrgChartMaker for this.

First, download and install the add-in from here. After installation, open your Excel sheet and click 'Developer' > 'ExcelOrgChartMaker'.

How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
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
Create Organization Chart in Excel
Create Organization Chart in Excel
How To Create Charts and Graphs in Excel
How To Create Charts and Graphs in Excel
the organizational chart for an organization
the organizational chart for an organization

Creating Your Hierarchy

The 'Global Settings' tab let you customize your org chart. Set your 'Overall Root Node' to the top-level executive(s). This ensures everyone is structured correctly below them.

Next, set your 'Self-Close' range. This tells the tool where to find your data for each employee. Typically, this starts in row 2 (assuming your headers are in row 1) and extends to however many rows you have data for.

Designing Your Chart

The 'Chart Styles' tab lets you customize the look of your chart. Choose from various templates, then adjust colors, fonts, and other design elements to suit your tastes.

How to Create Multi-Category Chart in Excel
How to Create Multi-Category Chart in Excel
Organogram Template Excel If you manage a team employee or busy household, you can easily man...
Organogram Template Excel If you manage a team employee or busy household, you can easily man...
an info sheet with many different types of boats in it
an info sheet with many different types of boats in it

Once you're happy with your design, click 'OK' to generate your org chart. The tool will create a new worksheet containing the visual representation of your team's hierarchy.

Take a moment to review your chart. If you spot any mistakes, simply return to your data, correct the issue, then regenerate the chart.

Congratulations! You've now created an org chart using data from Excel. This tool will help you and your team visualize and understand your organization's hierarchy and structure. Keep it up-to-date as your team grows or evolves, and you'll always have a clear snapshot of your organization at your fingertips.