✦Template Printable Ideas Insights

"Add Boxes to Excel Org Chart: Step-by-Step Tutorial"

By

In the corporate world, understanding the organizational structure is crucial for effective communication, decision-making, and career growth. Microsoft Excel, with its versatile features, allows you to create compelling organizational charts (org charts) that represent your company's hierarchy. Adding boxes to an org chart in Excel is a straightforward process, which we'll delve into in this guide.

Let's kickstart with the basics. An org chart in Excel is essentially a visual representation of your organization's structure. It's created using shapes, text boxes, and connectors to mimic the hierarchical structure, making it an invaluable tool for understanding and communicating your organization's structure.

Preparing Your Excel Worksheet

Before we dive into adding boxes to your org chart, let's ensure our worksheet is well-prepared.

How to Make an Org Chart in Excel (+ video tutorial)
How to Make an Org Chart in Excel (+ video tutorial)
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 Create an Organizational Chart Linked to Data in Excel (Easy & Dynamic)
How to Create an Organizational Chart Linked to Data in Excel (Easy & Dynamic)

First, ensure your worksheet is clean and free of unnecessary data. Rows and columns should be clearly defined.

Merging Cells

To create a spacious box for names and titles, you might need to merge cells. Select the cells you want to merge, click on the "Merge and Center" button in the "Home" tab under "Alignment".

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

Pro tip: Merged cells work best for large, empty spaces. Remember to keep merged cells to a minimum to maintain a clean org chart.

Defining Your Box Sizes

Each box in your org chart should be of the same size for consistency. You can achieve this by selecting the cells that'll form a box, right-clicking, and selecting "Format Cells". Choose the 'Number' tab, ensure the cells are formatted as 'General', then click 'OK'.

This ensures that all selected cells have the same formatting, making it easy to resize boxes uniformly.

Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know
Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know
Create check box tracker
Create check box tracker
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
a diagram with the words make org chart in excel and other words on top of it
a diagram with the words make org chart in excel and other words on top of it
the info sheet shows how to use excel dashboards for your business plan and workflow
the info sheet shows how to use excel dashboards for your business plan and workflow
a notebook with microsoft excel written on it
a notebook with microsoft excel written on it

Adding Shapes for Organizational Boxes

Now that your worksheet is prepared, let's add shapes for the organizational boxes.

In the "Home" tab, click on "Shapes", then select the shape you desire for your box. We'll use the common rectangle for this example.

Drawing Rectangle Boxes

Click and drag your mouse to draw the rectangle, ensuring it covers the defined box size. The box should now Span the width of your defined box size, but you can adjust its height later.

Top 25 Basic Excel Formulas Every Beginner Must Know
Top 25 Basic Excel Formulas Every Beginner Must Know
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
Have you ever wondered how to create a delivery tracker in Excel?
Have you ever wondered how to create a delivery tracker in Excel?

Adjusting Box Height

Right-click the box, select "Format Shape", then click on "Size & Properties". Change the height to match your defined box size. The width should automatically adjust to cover the entire span of your defined box size.

Remember to format your boxes consistently. You can change the fill, outline, and rotation as desired. The 'Format Shape' dialog box is your friend here.

Organizing your org chart boxes and connecting them is the final step. You can use the line tool in the 'Shapes' gallery to draw connecting lines. Right-click on the line, choose 'Format Shape', and adjust the line color, style, and weight to meet your design needs.

Creating organizational boxes in Excel requires a bit of creativity and patience, but the result is a visually appealing org chart that's easy to understand and navigate. So start by preparing your worksheet, then add shapes for your boxes. Formats your boxes consistently, and finally, organize and connect them. Happy charting!

Next steps? Check out our guide on how to add text to your org chart boxes for a comprehensive, professional look.