✦Template Printable Ideas Insights

Create Organizational Chart in Excel: Step-by-Step Guide

By

Ever found yourself in a leadership role, needing to visualize your team's structure, but drawing a blank on the best tools to use? Microsoft Excel, your powerful ally, has a solution – creating an organizational chart. Here's how you can make an organizational chart in Excel, making team management a breeze.

Excel's unique blend of data manipulation and presentation features make it an excellent choice for creating professional, informative, and easy-to-update organizational charts. Let's dive into the steps to create one, using SmartArt, a feature designed specifically for this purpose.

Preparing Your Data

Before we dive into the creation process, ensure your team's data is organized. You'll need each team member's name, job title, and manager's name. A simple table with columns for these three fields will suffice. Additionally, ensure your data is accurate and up-to-date to create an effective organizational chart.

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

Once your data is ready, it's time to transform it into a visual representation of your team's structure.

Selecting the Right SmartArt Diagram

Open Excel and insert a new worksheet. In the 'Insert' tab, click 'SmartArt', and choose the appropriate organizational chart layout. The most common choice is the 'Organization Chart', but you can also choose from 'Hierarchy', 'Relationship', or 'Process' layouts, depending on your needs.

Organizational Charts in Excel | MyExcelOnline
Organizational Charts in Excel | MyExcelOnline
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?

Once you've selected the layout, paste your team data into the text boxes provided. Start with the CEO or highest-ranking team member at the top and work your way down, using the 'promote' and 'demote' buttons to ensure the correct hierarchy.

Customizing Your Organizational Chart

Excel offers a range of customization options to make your organizational chart visually appealing and informative. Click on the 'Design' tab to explore these options. You can change the color scheme, layout, or add pictures to each box, enhancing the chart's professionalism and personal touch.

To add pictures, click on the text box you want to customize, go to the 'Home' tab, and click on 'Change Picture'. This allows you to select a photo from your computer or OneDrive, tying a face to a name and fostering team connection.

How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial
How to Create Organizational Chart in Excel
How to Create Organizational Chart in Excel
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
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 a 1 Click Organizational Chart In Excel [Masterclass + Free Download]
How To Create a 1 Click Organizational Chart In Excel [Masterclass + Free Download]
How to Create Org. Charts in Excel linked to your Data
How to Create Org. Charts in Excel linked to your Data

Keeping Your Organizational Chart Up-to-Date

Organizational charts shouldn't be static. They should grow and change as your team does. Thankfully, Excel makes it easy to keep your chart up-to-date.

Whenever there's a change in your team – a new hire, promotion, or departure – update your data table accordingly. Then, just click on the SmartArt graphic and select 'Update List'. Excel will automatically reflect the changes in your chart.

Linking Your Chart to Source Data

For an extra layer of automation, you can link your SmartArt chart directly to your data source. This ensures your chart is always up-to-date and eliminates the need for manual updates. To do this, right-click on your chart, select 'Convert to Table', then click inside the table and go to the 'Design' tab. Click 'Properties', check 'Linked to Table', and choose the appropriate primary key field.

Create Organization Chart in Excel
Create Organization Chart in Excel
Organogram Template Excel If you manage a team employee or busy household, you can easily man...
Organogram Template Excel If you manage a team employee or busy household, you can easily man...
How to Create Org Charts in Excel — The Step-by-Step Guide | EdrawMax
How to Create Org Charts in Excel — The Step-by-Step Guide | EdrawMax

With this setup, whenever you update your source data, your chart will automatically reflect those changes, keeping your organizational chart current and accurate at all times.