✦Template Printable Ideas Insights

Create Org Chart in Excel: Step-by-Step Guide

By

In today's business landscape, organization charts are indispensable tools for understanding and visualizing company structures. But what if you could create these charts using a versatile tool you already have on your computer – Microsoft Excel? Yes, you can do an org chart in Excel, and in this guide, we'll explore how to create, format, and customize these charts to suit your needs.

Before we dive in, let's understand why creating an org chart in Excel is beneficial. Excel is widely used, so it's likely that everyone in your team or organization has access to it. This makes it an ideal platform for sharing and collaborating on organizational charts. Moreover, Excel's data-driven nature makes it perfect for connecting your org chart to your workforce data.

Understanding the Basics of Excel Org Charts

The first step in creating an org chart in Excel is understanding the basic components. Excel org charts are based on a list of names and their respective ranks, departments, or teams. Each person in the list can have a manager, creating a hierarchical structure that Excel can automatically organize into an org chart.

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

Excel offers two types of org charts: Organization Chart and Pyramid. The Organization Chart arranges employees in a left-to-right, hierarchical manner, while the Pyramid chart places employees in a descendently top-down structure. We'll focus on the Organization Chart, as it's more common and versatile.

Preparing Your Data

Before you start creating your org chart, you'll need to organize your data in Excel. Your data should be in a list format, with each employee's information in a separate row. The data typically includes the employee's name, their manager's name (if applicable), and any other relevant information like department or job title.

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
Automatic Org Chart Maker: Excel Template with Photos (Ready to Print)
Automatic Org Chart Maker: Excel Template with Photos (Ready to Print)

Here's a simple example of how your data might look: | Name | Manager | |--------|---------| | John Doe | CEO | | Jane Smith | John Doe | | Bob Johnson | Jane Smith | | Alice Brown | John Doe |

Creating an Organization Chart in Excel

Once your data is ready, creating the org chart is simplicity itself. Select your data, then go to the Insert tab in the Excel ribbon. Click on Organization Chart, and Excel will automatically create an org chart based on the data you've selected. If your data includes more levels of hierarchy, those will be added to the chart automatically as well.

You can then customize your org chart by adding shapes, borders, and text boxes. For more advanced customization, you can right-click on any shape in the org chart and select Format Shape to access formatting options.

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
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.
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)
Org Chart, Organizational Chart, Business Plan, Business Strategy, Company Org Chart, Company Organization Template, Company Structure
Org Chart, Organizational Chart, Business Plan, Business Strategy, Company Org Chart, Company Organization Template, Company Structure
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...
41 Organizational Chart Templates (Word, Excel, PowerPoint, PSD)
41 Organizational Chart Templates (Word, Excel, PowerPoint, PSD)

Formatting Your Excel Org Chart

Once you've created your org chart, you can format it to match your organization's branding or to make it more engaging. Here are some tips for formatting your org chart:

Background and Borders

You can change the background color of individual shapes or add borders to make them stand out. Right-click on a shape and select Format Shape. In the popup menu, you can adjust the fill and outline colors.

You can also add a border to the entire org chart by selecting it (click and drag to select multiple shapes) and using the Borders tool in the Home tab of the ribbon. This can help contain the org chart and make it look more cohesive.

31+ Free Organogram Templates & Organizational Charts
31+ Free Organogram Templates & Organizational Charts
11+ High-Quality Organizational Chart Templates [Excel, Word & PowerPoint] - Word Excel Fomats
11+ High-Quality Organizational Chart Templates [Excel, Word & PowerPoint] - Word Excel Fomats
Org Chart Excel & Google Sheets. Employee Structure Template. Employee Hierarchy. Organizational Chart. Org Chart. Company Org Chart.
Org Chart Excel & Google Sheets. Employee Structure Template. Employee Hierarchy. Organizational Chart. Org Chart. Company Org Chart.

Line Styles and Colors

The lines connecting the shapes in your org chart can also be formatted. Right-click on a line and select Format Line. Here, you can change the line color, thickness, and style.

Changing the line color can help distinguish different levels of hierarchy or departments. You might use blue lines for one department and red lines for another, for example.

Adding Text and Images

You can add text to shapes to provide more information about each employee. Right-click on a shape and select Add Text. In the text box that appears, you can type any information you want to display.

You can also add images to your org chart. Right-click on a shape and select Add Shape, then choose Picture. You can then select an image from your computer or clip it from the web. This can be a great way to add a personal touch to your org chart.

Grouping and Reshaping

Once you've customized your org chart, you can group shapes together to make it easier to move or format them as a single unit. Select the shapes you want to group, then right-click and select Group.

You can also reshape individual shapes or groups of shapes. Select the shapes you want to reshape, then right-click and select Format Shape. In the popup menu, you can change the shape of the selected items.

Advanced Excel Org Chart Tricks

Once you're comfortable with the basics of creating and formatting org charts in Excel, you can explore some advanced techniques to make your charts even more powerful and engaging.

Linking to Other Data

One of the most powerful aspects of Excel org charts is their ability to connect to other data. You can link your org chart to other Excel sheets or even to external data sources like SQL databases.

This allows you to create dynamic org charts that update automatically when your data changes. For example, if you add a new employee to your data, the org chart will automatically update to include them. This can save you a lot of time and ensure that your org charts are always up-to-date.

Creating Interactive Org Charts

Another advanced feature of Excel org charts is the ability to make them interactive. You can add buttons and other interactive elements that allow users to drill down into the org chart, filter data, or perform other functions.

This can make your org charts more engaging and useful. For example, you could add buttons that allow users to filter the org chart by department or location, or buttons that link to other relevant information or tools.

Creating Master Org Charts

A lesser-known feature of Excel org charts is the ability to create master org charts. A master org chart is a template that you can use to create new org charts quickly and easily.

This can be a great time-saver if you need to create multiple org charts with similar structures. You can create a master org chart with the basic structure and formatting you want, then use it to create new org charts with just a few clicks.

To create a master org chart, go to the Home tab of the ribbon and click on Save as Template. This will save your org chart as a .exmt file that you can use to create new org charts.

To create a new org chart from a master template, go to the Insert tab of the ribbon and click on Organization Chart. Then, instead of selecting your data, click on More Filters and select From Template. This will allow you to select your master template and create a new org chart based on it.

And there you have it – a comprehensive guide to creating, formatting, and customizing org charts in Excel. Whether you're creating a simple org chart for your team or a complex, interactive org chart for your entire organization, Excel has the tools you need to get the job done. So next time you need an org chart, don't reach for the Publisher template – reach for Excel instead!