✦Template Printable Ideas Insights

"Create Organizational Hierarchy Chart in Excel"

By

Organizational hierarchy charts are vital tools for visualizing and understanding the structure, roles, and relationships within a company. Microsoft Excel, with its powerful tools and wide use, is an excellent platform to create these charts. Here's a step-by-step guide to help you make an organizational hierarchy chart in Excel.

To start, let's assume you have the following data: Department, Position, and Employee Name.

Preparing Your Data

Before creating the chart, ensure your data is structured correctly:

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

- Start by listing all the departments and positions in the first two columns.

- In the third column, list the employee names under their respective positions.

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...
the organization structure is shown in purple and orange
the organization structure is shown in purple and orange
41 Organizational Chart Templates (Word, Excel, PowerPoint, PSD)
41 Organizational Chart Templates (Word, Excel, PowerPoint, PSD)

Creating a Hierarchy List

First, create a hierarchy list using the Department and Position data. This will serve as the basis for your chart.

- In a new sheet, create a table with two columns: 'Level' and 'Text'.

Populating the Hierarchy List

Next, populate this table:

25+ FREE Editable Organizational Chart Templates - Besty Templates
25+ FREE Editable Organizational Chart Templates - Besty Templates
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
Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know
Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know
Corporate organizational chart with business avatar icons | Premium Vector
Corporate organizational chart with business avatar icons | Premium Vector
Company hierarchy schema diagram | Orson
Company hierarchy schema diagram | Orson
5+ Organization Chart Template Excel Sample | Template Business PSD, Excel, Word, PDF
5+ Organization Chart Template Excel Sample | Template Business PSD, Excel, Word, PDF

- In the 'Level' column, use the Department and Position data. The top level is the highest organizational level (e.g., '1' for the CEO).

- In the 'Text' column, combine the 'Level' and 'Text' to form a clear hierarchy (e.g., '1 - CEO').

Creating the Organizational Chart

Now, we'll use the organization chart layout to create your hierarchy chart.

the project manager's workflow diagram is shown in blue and white, as well as
the project manager's workflow diagram is shown in blue and white, as well as
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.
a computer organization chart is shown in this image
a computer organization chart is shown in this image

- Go to 'Insert' tab, click on 'Organization Chart'. Then, select 'Create a new organizational chart'.

Adding Data to the Chart

Add the data from your hierarchy list:

- Click on 'Select-data-source'. Under 'Data', choose your hierarchy list sheet.

- Under 'Visual', select 'Use 'Level' Column for Hierarchy'. Click 'OK'.

Customizing Your Chart

Customize your chart to fit your organization's needs:

- Click on any box to open the 'Format' pane. Here, you can change the 'Name', add 'Subordinates', or change the shape and color of the boxes.

- You can also 'Add Organization Chart Layout' to the existing chart, making it a full organizational hierarchy.

And there you have it! A well-structured, visually appealing organizational hierarchy chart in Excel.