✦Template Printable Ideas Insights

Boost Your Excel Skills: Adding More Boxes to Organizational Charts

By

Ever found yourself needing to expand your organizational chart in Excel due to a growing team or changing roles? You're not alone. Excel, with its flexible structure, allows you to easily add more boxes to your org chart. Let's dive into how you can achieve this efficiently.

Before we get started, ensure you have a basic organizational chart set up with at least a few roles or departments. If you're not sure how to create one from scratch, there are numerous online resources and tutorials that can guide you through the initial setup.

Using the Indented List Feature

The indented list feature in Excel is a great way to create a hierarchical org chart. It automatically formats your list into an indented structure, making it easy to understand the hierarchy at a glance.

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

To use this feature, select the cells containing your roles or departments. Click on 'Home' in the ribbon, then click on 'Increase Indent' (the text should shift to the right). To move a role up or down in the hierarchy, simply select a row and click on 'Decrease Indent' or 'Increase Indent' as needed.

Adding a New Level

To add a new level, place your cursor on the row below where you want the new level to appear. Then, click on 'Increase Indent'. A new column will appear, allowing you to add in the new role or department.

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
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
Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know
Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know

For example, if you have a 'Management' row and you want to add a 'Sales Manager' role directly under it, simply click on 'Increase Indent' on the 'Management' row, then type 'Sales Manager' in the new column and press enter.

Moving Roles Between Levels

To move a role to a different level, simply click on the row with the role you want to move. Then, click on 'Decrease Indent' or 'Increase Indent' depending on whether you want to move the role up or down in the hierarchy.

For instance, if you've realized that the 'HR Manager' should report directly to the 'CEO' instead of the 'Management' level, select the 'HR Manager' row, then click on 'Decrease Indent' twice to move it under the 'CEO'.

Create Organization Chart in Excel
Create Organization Chart in Excel
Human Resources Excel Spreadsheet Template: 9 Box Grid
Human Resources Excel Spreadsheet Template: 9 Box Grid
How to Create Organizational Chart in Excel
How to Create Organizational Chart in Excel
Create a Stacked Column Chart with Total in Microsoft Excel
Create a Stacked Column Chart with Total in Microsoft Excel
the 10 more excel functions poster
the 10 more excel functions poster
Create check box tracker
Create check box tracker

Using Shapes for a More Visual Org Chart

While the indented list is functional, sometimes you want a more visual org chart. This is where Excel's shapes come in handy. They allow you to create a more traditional box and arrow org chart.

To start, you can use the 'SmartArt' feature under 'Insert' in the ribbon. This will give you a variety of org chart templates to choose from. Once you've selected a template, you can add, remove, or move boxes to fit your organization's structure.

Adding a New Box

To add a new box, simply click on the box where you want the new one to appear. Then, go to the 'Design' tab under 'SmartArt' and click on 'Add Shape'. A new box will appear, allowing you to add in the new role or department.

Have you ever wondered how to create a delivery tracker in Excel?
Have you ever wondered how to create a delivery tracker in Excel?
Excel Skills Every Data Analyst Needs
Excel Skills Every Data Analyst Needs
The simple way to add check marks in Excel!
The simple way to add check marks in Excel!

For example, if you want to add a 'Marketing Coordinator' who reports to the 'Marketing Manager', click on the 'Marketing Manager' box, then click on 'Add Shape'. A new box will appear below it, where you can add the 'Marketing Coordinator' role.

Moving a Box

To move a box, simply click on it and drag it to its new location. When you let go of the mouse button, it will snap into place in the new spot.

For instance, if you've decided that the 'Marketing Coordinator' should report to the 'Sales Manager' instead, click on the 'Marketing Coordinator' box and drag it onto the 'Sales Manager' box. It will automatically shift to become a sub-box under the 'Sales Manager'.

As your organization continues to evolve, remember to regularly update your org chart to reflect the current roles and hierarchy. This will not only help your team stay organized but also keep everyone on the same page regarding their responsibilities and who they report to.