✦Template Printable Ideas Insights

Simple Org Chart in Excel: Quick & Easy Guide

By

Looking to create an organizational chart in Excel and keep it simple? You're in the right place. An organizational chart, or org chart, is a visual representation of your company's hierarchy, and it's incredibly useful for understanding roles, responsibilities, and team structures. In this guide, we'll walk you through the process of creating a simple org chart in Excel step by step, using nothing but the built-in tools and basic formatting.

Before we dive in, ensure you have the latest version of Excel installed on your computer. We'll be using a combination of tables, text wrapping, and basic shapes to create our org chart. The beauty of this method is that it's intuitive, easy to update, and doesn't require any add-ins or macros. So, let's get started!

Setting Up Your Excel Workbook

First things first, let's set up our Excel workbook for creating our org chart.

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?
Org Chart, Organizational Chart, Business Plan, Business Strategy, Company Org Chart, Company Organization Template, Company Structure
Org Chart, Organizational Chart, Business Plan, Business Strategy, Company Org Chart, Company Organization Template, Company Structure

1. **Create a New Workbook**: Open a new Excel workbook and save it somewhere easily accessible. You can always delete unwanted pages later, so don't worry about starting fresh.

Using Tables for Hierarchical Data

Tables in Excel are excellent for managing and organizing hierarchical data, like your org chart. Here's how to create one:

Happy Birthday Chart - 10 Free PDF Printables | Printablee
Happy Birthday Chart - 10 Free PDF Printables | Printablee
Demo Start | Creately
Demo Start | Creately
How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial

1. **Enter Your Data**: In the first sheet (Sheet1), enter your organization's departments, positions, and employee names in three columns (B, C, and D) as shown below (skip a few rows from the top):

Step 1: Enter your organizational data
Department Title Name
Sales Sales Manager John Doe
Marketing Marketing Manager Jane Smith

2. **Convert Your Data to a Table**: Click anywhere within your data range (B1:D16, for instance). Then, go to the Home tab, click Format as Table, choose a color scheme you like, and ensure the 'My table has headers' box is checked.

Customizing Your Table for the Org Chart

Now, let's make our table look like an org chart.

How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial
15+ Organizational Chart Template Free
15+ Organizational Chart Template Free
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
Download Business Organogram Chart for free
Download Business Organogram Chart for free
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.
Organizational Chart Maker
Organizational Chart Maker

1. **Add Borders**: Select the three columns of your table (B1:D16). Go to the Home tab, click on Borders, and choose 'All Borders'.

2. **Merge and Center Cells**: Select rows 1 and 2. Go to the Home tab, click on Merge & Center, then choose Merge & Center again. Rename the cell to 'Department' and apply a font size of 14.

3. **Widen Columns**: Make columns B, C, and D wider by dragging the dividing lines to the right. The exact width depends on your data, but aim to make them around 200 pixels each.

a computer screen with a diagram on it and the words org chart hack written below
a computer screen with a diagram on it and the words org chart hack written below
41 Organizational Chart Templates (Word, Excel, PowerPoint, PSD)
41 Organizational Chart Templates (Word, Excel, PowerPoint, PSD)
Plantilla de infografía de organigrama | Vector gratuito
Plantilla de infografía de organigrama | Vector gratuito

Creating the Hierarchy with Shapes

Now that we have our data set up, let's use shapes to create the org chart's hierarchy.

1. **Draw a Rectangle for the Department**: Click on the Insert tab, click on Shape, then choose a simple rectangle shape. Draw a rectangle around your 'Department' cell (A1). Resize and reposition it as needed.

Using the Indentation Technique

We'll use text wrapping and indentation to create the hierarchal effect.

1. **Wrap Text**: Click on the rectangle you just drew. Go to the Format tab under Shape, then click on Wrap Text. Now, the text within the rectangle will wrap instead of pushing the shape out.

2. **Indentation**: Click on the text within the rectangle. Go to the Home tab, click on the Increase Indent button () twice. This makes the text inside the rectangle indent slightly, creating a visual hierarchy.

Creating Levels in the Org Chart

To create different levels in your org chart (like manager, team members, etc.), we'll use the same technique with rectangular shapes and indentation.

1. **Add a Rectangle for 'Sales'**: Draw another rectangle around cell B2 and apply the same formatting (wrap text, increase indent twice) as before.

2. **Add 'Sales Manager'**: Repeat the process for cells C3 and D3. Make this rectangle slightly smaller than the previous one to represent the hierarchy.

Continue adding rectangles for each department, following the same steps. Experiment with indentation to create the desired hierarchy. Once you've added all the required levels, your org chart should take shape!

Final tip: To update your org chart in the future, simply edit the table data in Sheet1, then add or remove shapes as needed. Easy peasy!

Creating a simple org chart in Excel can help improve collaboration, communication, and overall organizational understanding. So, take pride in your newly created org chart, and share it with your team to foster a more cohesive work environment. Happy organizing!