✦Template Printable Ideas Insights

How to Create an Organizational Chart in Excel

By

Organizing a company's structure can be a complex task, but creating an organizational chart has become much simpler with the advent of Microsoft Excel. An organizational chart (org chart) visually represents your company's hierarchy, allowing you to understand and clearly communicate roles, responsibilities, and relationships within your organization. Here's a comprehensive guide on how to create an organizational chart in Excel.

Before we dive into the steps, ensure you have a basic understanding of your company's hierarchy. Identify the key positions, departments, and the line of command. This will serve as the foundation for your org chart. Let's proceed to create a simple, yet effective organizational chart.

Setting Up Your Excel Workbook

Begin by opening a new or existing Excel workbook. Ensure you're on the first sheet, where you'll create your 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

While Excel isn't designed for creating complex org charts, using the SmartArt feature can help you create professional-looking layouts. Next, we'll explore how to insert a SmartArt diagram and customize it according to your organization's structure.

Inserting a SmartArt Diagram

To insert a SmartArt diagram, click on the 'Insert' tab in the ribbon. In the 'Illustrations' group, click on 'SmartArt'. A dropdown menu will appear, displaying various layouts suitable for org charts. Choose 'Organization Chart', as it's the most suitable for our purpose.

Organizational Charts in Excel | MyExcelOnline
Organizational Charts in Excel | MyExcelOnline
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 Linked to Data in Excel (Easy & Dynamic)
How to Create an Organizational Chart Linked to Data in Excel (Easy & Dynamic)

Once you've selected the layout, you'll see a placeholder SmartArt diagram on your worksheet. Now, let's start adding content to our diagram.

Adding and Formatting Content

In the SmartArt pane that appears on the right, you'll see a text pane under 'Text'. This is where you'll add the names and roles of your company's hierarchy. Start by adding your company's CEO or most senior role at the top. Then, add the direct reports under their respective managers. Continue this process until you've added all the necessary roles.

Formatting your org chart involves customizing the styles and colors of your text and shapes. In the 'SmartArt Tools' tab under 'Design' and 'Format', you'll find options to change 'Layout', 'SmartArt Styles', 'Line Colors', and 'Color'. Experiment with these options to create a visually engaging org chart.

How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial
How to Create Organizational Chart in Excel
How to Create Organizational Chart in Excel
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
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
7 Types of organizational structures
7 Types of organizational structures

Creating a More Complex Organizational Chart

For more complex org structures or to include additional information like departments, responsibilities, or contact details, consider using a more advanced tool. Microsoft Visio or dedicated org chart software can provide more flexibility and functionality.

Alternatively, you can create a more detailed org chart in Excel by using tables, shapes, and text boxes. However, this method requires more manual work and might not be as visually appealing as using SmartArt or a dedicated org chart tool.

Using Tables and Shapes

Begin by creating a table listing all the roles and their respective details. You can then insert shapes, such as boxes or circles, to represent each role. Use text boxes to add names and positions. You can then manually arrange these shapes and text boxes to create your organizational hierarchy.

Create an Org Chart in Excel
Create an Org 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...
How to Create Multi-Category Chart in Excel
How to Create Multi-Category Chart in Excel

Once you've created your org chart, you can add more details by inserting filters, sorting, or using conditional formatting. This allows you to easily update and maintain your org chart as your company grows and changes.

Creating an organizational chart in Excel helps you visualize your company's structure, making it easier to understand roles, responsibilities, and relationships. It also aids in communication, both internally and externally, about your company's hierarchy. As your organization evolves, remember to update your org chart to ensure it accurately reflects your company's latest structure. And with that, you're ready to create and maintain your organizational chart using Excel.