✦Template Printable Ideas Insights

How to Create an Organizational Chart in Excel

By

Ever needed to illustrate your organization's structure, roles, and hierarchy clearly and effectively? An organizational chart is the ideal solution, and with Microsoft Excel, creating one is surprisingly straightforward. This step-by-step guide will walk you through the process, from planning to final touches.

Before you start, ensure you have the latest version of Excel and a good understanding of its basic functions. Let's dive in.

Preparation and Basics

Begin by opening a new workbook in Excel. You'll use a single worksheet for this chart, so name it accordingly, e.g., "OrgChart".

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

Next, familiarize yourself with the Row and Column headers. Rows are identified by numbers (1, 2, 3, etc.), and columns by letters (A, B, C, etc.). This will help when navigating and referencing cells.

Defining Your Chart

Start by listing all roles and subordinates in columns. In Row 1, from Column A to E, enter the following headers: "Name", "Position", "Department", "Direct Reports", and "Additional Info".

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
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?

In Column A, beginning from Row 2, list all employees' names. In Column B, mention their respective positions. Repeat the process for Department and Additional Info as needed.

Identifying Reporting Relationships

In Column D, "Direct Reports", list the names of the direct subordinates for each employee. For example, under the CEO's name, you might list the names of the department heads who report directly to them.

This column is crucial for creating the chart's hierarchy. Ensure it's accurate and up-to-date, as errors here can distort your chart.

How to Create Organizational Chart in Excel
How to Create Organizational Chart in Excel
Free Organisational Chart Template
Free Organisational Chart Template
a flow chart with several different types of language and their corresponding words, including thesauruss
a flow chart with several different types of language and their corresponding words, including thesauruss
25+ FREE Editable Organizational Chart Templates - Besty Templates
25+ FREE Editable Organizational Chart Templates - Besty Templates
6+ Organizational Chart Templates - Word Excel Templates
6+ Organizational Chart Templates - Word Excel Templates
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
How to Create an Organizational Chart in Word with Free Templates | EdrawMax

Creating the Organizational Chart

Now that your data is in place, it's time to transform it into a visual chart. Excel's SmartArt tool is perfect for this task.

Ensure your cursor is in the Data Range (A1:E20, for instance). Go to the "Home" tab, click on "SmartArt", and select "Organization Chart".

Formatting the Chart

Your chart is now generated, but it's likely crowded and disorganized. Begin refining it by promoting and demoting levels. Right-click on any name and select "Promote" or "Demote" to move bosses up or subordinates down.

the advanced excel chart sheet is shown in green and has instructions on how to use it
the advanced excel chart sheet is shown in green and has instructions on how to use it
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...
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
Editable Organizational Chart Template - Excel & Google Sheets - Customize Your Company Structure, Visualize Roles and Hierarchy
Editable Organizational Chart Template - Excel & Google Sheets - Customize Your Company Structure, Visualize Roles and Hierarchy

Continue adjusting the levels until your chart accurately reflects your organization's structure. You may need to resize the chart or individual boxes for better spacing and readability.

Customizing the Layout

Right-click on the chart, go to "Layout", and explore the various layouts and styles available. Choose the one that best matches your organization's branding or preference.

You can also add or remove shapes, change colors, and modify fonts directly in the "SmartArt" tab. Regularly review your chart to ensure it's clean, clear, and easy to navigate.

Finally, don't forget to save your work. Name your file something intuitive, like "Final OrgChart_Q2-2023", and keep it in an easily accessible location for updates and reference.