✦Template Printable Ideas Insights

Boost Excel: Super Simple Org Chart Creation

By

Creating a detailed and easy-to-understand organizational chart in Excel is a valuable skill for visualizing your team's structure. Excel, with its user-friendly interface and powerful tools, is the perfect software for this task. Here, we'll explore the simplest way to make an org chart in Excel, ensuring your hierarchy is clear and well-organized.

Before we dive in, make sure you have Excel installed on your computer or access it through an appropriate cloud service. We'll be using Excel 2016 or later for this guide, but you can still follow along with slightly older versions with minimal changes.

Setting Up Your Workspace

Start by opening a new, blank workbook. Name it 'Org Chart' or something relevant to your organization. The overall theme, colors, and fonts you choose should align with your company's branding for professionalism.

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

For simplicity, we'll list org chart items in Column A. In Row 1, enter hierarchy levels, such as 'C-level', 'Directors', 'Managers', etc. Use auto-expand feature (Home > Orientation > AutoFit Row Height) to make text fit well.

Basic Chart Creation

Now, let's create the basic organizational chart. In Column B, enter employees' names corresponding to their hierarchy. You can use data validation (Developer > Data Validation) to pre-list department heads, managers, and team members for easy selection.

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

Next, drag your mouse across cells to highlight all data. Go to Insert > SmartArt. Select the 'Hierarchy' layout. Each level will represent a new row in Excel, creating your basic org chart.

Adding Formatting and Details

Click on the org chart to select it. Use the 'Design' and 'Format' options in the ribbon to customize colors, shapes, and fonts. Add additional text boxes (Home > New Shape) for more details or to mention multiple people for a single role.

For complexity, add supporting tables or charts nearby to showcase departments, teams, or revenue breakdowns, creating a comprehensive organizational landscape.

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

Automatic Resizing and Adjustment

With a growing organization, manual adjustments can be time-consuming. Here's how to create a dynamic org chart that auto-resizes and adjusts based on data.

Suppose you've listed your team in Excel, and new members join frequently. You can create a user-friendly system that syncs the Excel org chart with your list. Here's how:

Using Absolute and Relative Cell Referencing

With the SmartArt org chart created, place your cursor on the last shape's text field. Ghee governor (or) aliasing it over the cell with the last employee's name. Click on the formula bar, and notice the formula: ="Sheet1"!B2. This refers to Row 2, Column B, where your data starts.

How to make a male_female ratio chart in Excel
How to make a male_female ratio chart in Excel
an organization chart with the words manager, employee and employee's name on it
an organization chart with the words manager, employee and employee's name on it
Organizational Chart Maker
Organizational Chart Maker
How To Create Charts and Graphs in Excel
How To Create Charts and Graphs in Excel

Change this to an absolute reference: ="Sheet1"!$B$2 (by entering "$" before "B" and "2"). Now, the org chart is grouped and linked to this cell. If you add or remove data, the chart dynamically adjusts its size and content.

This method allows for easy maintenance and doesn't require manually resizing or updating the org chart whenever there's a change in the team.

With these steps, your simple yet efficient organizational chart in Excel is complete. Regularly updating your Excel sheet ensures your org chart remains relevant and informative. This method is not only easy but also saves time and effort in the long run.