✦Template Printable Ideas Insights

Mastering Excel: Creating Organizational Charts in Steps

By

An organizational chart is a visual representation of your company's structure, depicting hierarchy, roles, and relationships among various departments and teams. Drawing one in Microsoft Excel simplifies collaboration, especially with its built-in tools and user-friendly interface. Here's a step-by-step guide on how to draw an organizational chart in Excel.

Before diving in, make sure you have a clear understanding of your organization's structure, including departments, teams, and roles. This will ensure an accurate and well-organized chart.

Setting Up the Basics

First, let's create a simple list of departments and titles that we'll expand into a 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
How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial
How to Make an Org Chart in Excel (+ video tutorial)
How to Make an Org Chart in Excel (+ video tutorial)

In a new Excel workbook, create a table (press 'Alt + Enter' to create line breaks in a cell) with 'Department' and 'Title' as headers. List your departments and respective titles in the columns below.

Creating Roles

Each employee in the future chart will be represented as a shape. We'll create these shapes and assign roles now.

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

Head to the 'Insert' tab, click on 'Shapes', and select the hierarchy you want for your roles (e.g., Organization, Department, Position). Click on 'Save As' to save the hierarchy for future use.

Adding Employees

Now, let's add employees to our chart. In your 'Title' column, highlight the roles you want to turn into shapes. goto the 'Design' tab, and click 'Add employee'. Excel will convert the selected titles into shapes, placed chronologically in the hierarchy you created earlier.

You can adjust the placement, connections, and hierarchy levels of your employees by dragging and dropping the shapes. Use the 'Layout' tab for auto-fit, auto-align, and auto-width options to optimize the chart's appearance.

How to Create an Organizational Chart in Word with Free Templates | EdrawMax
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
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?
7 Types of organizational structures
7 Types of organizational structures
Flat style organizational chart | Premium Vector
Flat style organizational chart | Premium Vector
Organizational Charts in Excel | MyExcelOnline
Organizational Charts in Excel | MyExcelOnline
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

Customizing Your Organizational Chart

isticated your chart with colors, fonts, and themes to match your branding or personal style.

Each shape represents an employee, and you can customize it further. Select a shape, go to the 'Format' tab, and click 'Text Fill & Line Color', 'Format Shape', or 'WordArt Styles' to change colors, gradients, and fonts.

Changing Shape Types

For a different look, you can change the shape type for each role. Select a shape, go to the 'Format' tab, click 'Edit Shape', and choose from the various shapes available.

an organization diagram with several people on it
an organization diagram with several people on it
25 Typical Orgcharts
25 Typical Orgcharts
Demo Start | Creately
Demo Start | Creately

You can also mix and match shape types for a unique design, ensuring the hierarchy remains clear and unmistakable. For example, you can use a combination of squares for departments and circles for individual roles.

Wrapping Up

Finally, you can add a title to your chart, adjust the page layout for printing, and 'Export' your chart as a PDF or image file for presentations or reports.

Drawing an organizational chart in Excel offers flexibility, allowing you to continually update and refine your company's structure. As your organization grows, easily add new employees or adjust the hierarchy as needed. Happy charting!