✦Template Printable Ideas Insights

"How to Create an Organizational Chart from Excel"

By

Making an organizational chart from Excel can be a daunting task, but with the right steps, it's surprisingly straightforward. As a versatile tool, Excel enables you to create detailed, informative, and visually appealing org charts. Let's dive into a step-by-step guide to simplify this process.

Before we start, ensure you have Microsoft Excel installed on your computer and a basic understanding of its features. We'll be using Excel 2016 or later, but the steps are largely similar in other versions.

Preparing Your Data

An organized dataset is crucial for an effective org chart. Start by listing all the departments and employees, along with their roles and reporting structures. You can use a simple table with columns for 'Name', 'Role', 'Department', and 'Manager'.

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

For instance, your data might look like this:

NameRoleDepartmentManager
AlexCEO Executive-
JamieCMOMarketingAlex

Formatting Your Data

Once your data is organized, format it for better readability. You can group rows based on departments, apply consistent font styles, and use cell merging for better reporting structure representation.

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

To group rows, select the data, then click "Home" > "Format as Table". This also allows you to apply formatting that's consistent across your org chart.

Creating Your Organizational Chart

Now that your data is ready, it's time to transform it into an org chart. To do this, we'll use Excel's "SmartArt" feature.

Select your data, then click "Insert" > "SmartArt". Choose the org chart layout you prefer (we recommend the "Organization Chart" design for a typical org chart). Your data will automatically populate the selected layout.

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 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
an excel spreadsheet showing the number and type of items that are in each column
an excel spreadsheet showing the number and type of items that are in each column
the cover of how to create an org chart with a woman's face
the cover of how to create an org chart with a woman's face
the organizational chart for an organization
the organizational chart for an organization

Customizing Your Organizational Chart

While the automatic layout is a great starting point, you'll likely want to customize your org chart for better presentation. Here's how you can do that:

Adjusting the Layout

To add or remove employees, click on the "+" or "-" icons at the bottom of the SmartArt tool. To move an employee, simply click on them and drag to the desired location. To promote or demote an employee, use the arrow icons that appear when you hover over their box.

To swap employee roles, choose "SmartArt Graphics" > "Add Shape" to create a new role. Then, drag and drop employees into the new roles. Alternatively, delete an existing role and add a new one to replace it.

a diagram with the words make org chart in excel and other words on top of it
a diagram with the words make org chart in excel and other words on top of it
How to Create Organizational Chart in Excel
How to Create Organizational Chart in Excel
an info sheet with many different types of boats in it
an info sheet with many different types of boats in it
Organizational Chart Template. Charity Organization template. Company Organization Template. Employee Structure Excel Template. Org Chart.
Organizational Chart Template. Charity Organization template. Company Organization Template. Employee Structure Excel Template. Org Chart.

Styling Your Chart

You can also customize the SmartArt layout itself. Right-click anywhere in the chart, choose "Format," then use the options on the right side menu to change the theme, colors, line styles, and more.

To customize individual text boxes, right-click them and select "Format." Here you can adjust text fill, line color, and more for that specific box.

Adding Extra Information

To provide more context, you can add extra information to your org chart. Use the text boxes in each box to add additional details about each employee. Alternatively, add legend boxes or other shapes to your org chart for extra information.

For example, you could add a box explaining the color-coding or additional roles within each department.

Once you're satisfied with your org chart, it's ready for presentation. To preserve the formatting, save it as a .pdf or export it as an image file (PNG or JPEG).

Creating an org chart in Excel takes practice, but with these steps, you'll create clear, informative, and engaging visual representations of your company's structure. Happy charting!