✦Template Printable Ideas Insights

Expand Your Excel Skills: How to Add More Boxes to an Organizational Chart

By

Are you looking to expand your organizational chart in Excel, but feeling a bit stuck on how to add more boxes? You're not alone. Excel's built-in tools might seem limited at first, but with a little creative use, you can add as many boxes as you need. Let's dive in and explore how to do this, step by step.

Before we start, ensure you have Excel installed and opened on your computer. We'll be using basic Excel functions, so no need for advanced skills. Let's start by understanding the basic structure of an organizational chart, which typically includes departments, teams, and individual roles.

Adding Boxes to the Chart

Excel uses reshaping and merging cells to create the 'boxes' in your organizational chart. We'll start by adding a new level to your chart, say a new department.

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

First, add a new row below the last box in your chart. You can do this by right-clicking on the row number (e.g., 2, 3, etc.) and selecting 'Insert' from the context menu.

Reshaping Data

Now, you'll need to reshape the data to fit the new row. For example, if you want to add a 'Sales' department under 'Management', you can transform your data from 'Vertical' to 'Horizontal'.

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?
the organizational chart for an organization
the organizational chart for an organization
Organizational Charts in Excel | MyExcelOnline
Organizational Charts in Excel | MyExcelOnline

To do this, select your data, click on 'Home' > 'Format as Table', and then under 'Create Table', check 'My table has headers'. Click 'OK', then right-click anywhere in the table, select 'Resize Table', and increase the number of rows to include your new row.

Merging Cells

Now, let's merge cells to create a new box. Say you want the new 'Sales' box to span three columns. Select the cells you want to merge (e.g., B2, C2, D2), right-click, and select 'Merge & Center'.

You can edit the text in the merged cell to say 'Sales'. Do the same for the 'Management' box above it, but this time, unmerge the cell, and type in 'Sales Dept'.

Human Resources Excel Spreadsheet Template: 9 Box Grid
Human Resources Excel Spreadsheet Template: 9 Box Grid
Top 7 Excel Inventory Management Tips and Free Template
Top 7 Excel Inventory Management Tips and Free Template
Create Organization Chart in Excel
Create Organization Chart in Excel
Have you ever wondered how to create a delivery tracker in Excel?
Have you ever wondered how to create a delivery tracker in Excel?
How to Add Check Boxes In MS Excel Sheet (Easy)
How to Add Check Boxes In MS Excel Sheet (Easy)
a computer screen with the text organize assignments due with checkboxes
a computer screen with the text organize assignments due with checkboxes

Adding Teams and Roles

Great, you've added a new department. Now let's add teams and roles under it. We'll add 'Sales Team A' and 'Sales Team B', each with a 'Manager' and 'Team Members'.

To do this, insert two new rows under 'Sales'. Reshape your data, and then merge and center cells to create new boxes. You can copy and paste the 'Sales Team A' and 'Sales Team B' boxes to create the second team.

Creating Organizational Chart Hierarchy

To create a hierarchy, use indentation to show who reports to whom. Select the row for 'Team Members', go to 'Home' > 'IncreaseIndent'. The team members will now appear indented under their respective managers.

Create a Stacked Column Chart with Total in Microsoft Excel
Create a Stacked Column Chart with Total in Microsoft Excel
the 4 levels of excel master info sheet with text and images on it, including data
the 4 levels of excel master info sheet with text and images on it, including data
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.

To add more teams or roles, simply follow the same process. Don't forget to save your work regularly!

And there you have it! With these steps, you can add as many boxes as you need to your organizational chart in Excel. Happy organizing!