✦Template Printable Ideas Insights

Simplest Excel Org Chart Creation

By

Creating an org chart, or organizational chart, is a vital step in visualizing and understanding your company's structure, roles, and hierarchy. While you might assume this task requires specialized software, you'd be surprised to learn that Excel, a commonly used spreadsheet program, offers a straightforward way to create an org chart. So, what's the easiest way to create an org chart in Excel?

Excel's built-in SmartArt feature makes it a breeze to create an org chart. This intuitive tool allows you to add shapes, connect them, and format them to your liking. In this guide, we'll walk you through the process, step by step. By the end, you'll have a professional org chart without needing to learn complex software.

Getting Started with Excel

Before we dive in, ensure you have Microsoft Excel installed on your computer. Familiarize yourself with the basic Excel interface, especially the 'Home' tab, where we'll find the tools we need.

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

For this guide, we'll use an example company structure with four departments: Marketing, Sales, IT, and HR. Each department has a manager and a few team members. However, you can adapt this process to fit your organization's structure.

Preparing Your Data

To create an org chart, start by collecting and organizing your company's data. This includes names, job titles, and departments. Open a new Excel worksheet and create headers for ' Name', 'Job Title', and 'Department'.

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?
an excel chart with two smiley faces and the word excel in green on top of it
an excel chart with two smiley faces and the word excel in green on top of it
How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial

Enter your data below the headers, one person per row. This will serve as the foundation for your org chart. Remember to keep the data sorted alphabetically by name or use the 'Sort' function for better organization.

Creating the Org Chart

Now that your data is ready, it's time to create the org chart. In the 'Home' tab, click on 'SmartArt' in the 'Illustrations' section. A dropdown menu will appear, displaying various layouts. For an org chart, choose 'Organization Chart'.

A predefined org chart with placeholders will appear on the right side of your screen. On the left, you'll see a list of your data, starting with 'Deltaacé'. This is the hierarchy level, and the text below it represents the data you entered in your worksheet.

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)
7 Types of organizational structures
7 Types of organizational structures
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
the organizational chart is shown in blue and yellow with an arrow pointing up to it
the organizational chart is shown in blue and yellow with an arrow pointing up to it
How to Create Organizational Chart in Excel
How to Create Organizational Chart in Excel
How to Create Multi-Category Chart in Excel
How to Create Multi-Category Chart in Excel

Building the Hierarchy

Start by dragging 'Deltaacé' to the top box in your org chart. This will become your company's CEO or top-level position. Now, let's add the department managers.

Drag 'Marketing Manager', 'Sales Manager', 'IT Manager', and 'HR Manager' to the boxes below Deltaacé. Each of these will represent a department head in your company. The hierarchy should now look like this:

Deltaacé
 - Marketing Manager
 - Sales Manager
 - IT Manager
 - HR Manager

#exceltips #excelfunctions #xlookup #excelautomation #dataanalysis #corporateexcel #worksmart #excelproductivity #excelebook #impressyourboss | Excel Baba
#exceltips #excelfunctions #xlookup #excelautomation #dataanalysis #corporateexcel #worksmart #excelproductivity #excelebook #impressyourboss | Excel Baba
Organizational Chart Maker
Organizational Chart Maker
How to make a male_female ratio chart in Excel
How to make a male_female ratio chart in Excel

Adding Team Members

Next, we'll add the team members under their respective managers. Simply drag and drop each team member below their manager in the hierarchy. For example, the Marketing team would look like this:

Marketing Manager
 - Marketing Team Member 1
 - Marketing Team Member 2
 - Marketing Team Member 3

Repeat this process for the Sales, IT, and HR teams. Soon enough, you'll have a complete org chart reflecting your company's structure.

Customizing Your Org Chart

Now that your org chart is built, it's time to make it look professional and presentable. Use the 'Design' tab in the SmartArt Tools to change the layout, colors, and styles. You can also add pictures or icons to represent each person or department.

To customize further, right-click on a shape and select 'Format'. This will bring up the 'Format SmartArt' pane, where you can change the fill color, line color, and other advanced settings.

You can also add or remove levels in the organization chart by right-clicking and selecting 'Add Shape' or 'Delete'. This allows you to adjust the hierarchy as needed.

The Final Touches

Once you're satisfied with the look of your org chart, it's time to add some final touches. Consider adding a company logo, a brief introduction, or any other relevant information. This can be done by adding a text box or using the 'Text' feature in the SmartArt layout.

To print your org chart, select the entire chart, go to the 'File' tab, and click 'Print'. Alternatively, you can save it as a PDF or an image for easy sharing. To save as a PDF, go to 'File', followed by 'Export' and 'Create PDF/XPS'.

There you have it! You've just created an org chart in Excel. This simple yet powerful tool allows you to keep your team informed about the company's structure, promote transparency, and foster collaboration. Regularly reviewing and updating your org chart will ensure it remains accurate and relevant.

Remember, the key to a great org chart is accurate and up-to-date information. Keep your data fresh, and your org chart will serve as a valuable resource for your company. Happy organizing!