✦Template Printable Ideas Insights

Excel: Create Organizational Chart

By

Creating an organizational chart in Excel can be incredibly useful for visualizing your company's structure, tracking employee roles, and fostering better communication within your teams. Here's a step-by-step guide to help you create a sleek, professional organizational chart that's both easily understandable and visually appealing.

Before diving into the process, ensure that you have the latest version of Excel installed on your computer, as some features might differ slightly depending on the version. This guide assumes you're using Excel 2016 or later.

Preparing your Data in Excel

To begin, you'll need to organize your team's information in an Excel worksheet. Create a new sheet and input the following details for each employee: full name, title, and department. You can also add their direct reports (employees they manage) to create accurate hierarchical levels.

How to Make an Org Chart in Excel (+ video tutorial)
How to Make an Org Chart in Excel (+ video tutorial)
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)
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

Here's an example of how your data should be structured:

Full Name Title Department Direct Reports
John Doe CEO Executive Jane Smith, Jim Brown
Jane Smith CTO IT Bob Johnson, Alice Lee

Setting up your Data for the Organizational Chart

Now that your data is organized, it's time to prepare it for the organizational chart. In the 'Direct Reports' column, replace each employee's names with their respective full names enclosed in square brackets - []. This will help you link the employees to their direct reports during the chart creation process. For example:

How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - 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 Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial

[John Doe], [Jane Smith], [Jim Brown]

Creating the Organizational Chart

With your data set up, it's time to create the chart. Click on the first cell containing the employee names (A2) and drag to select the entire range of data up to the 'Direct Reports' column. Then, go to the 'Insert' tab and click on 'Organization Chart'.

In the 'Select a Chart' dialog box, choose 'Organization Chart' (the first icon in the list) and click 'OK'. Your organizational chart will now be generated using the data you've inputted.

How to Create an Organizational Chart in Word with Free Templates | EdrawMax
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
How to Create Organizational Chart in Excel
How to Create Organizational Chart in Excel
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
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
25+ FREE Editable Organizational Chart Templates - Besty Templates
25+ FREE Editable Organizational Chart Templates - Besty Templates
an info sheet with many different types of boats in it
an info sheet with many different types of boats in it

Customizing your Organizational Chart

Now that you have a basic organizational chart, it's time to customize it to fit your teams' needs. Right-click on the chart and select 'Format', then explore the formatting options that appear on the right-hand side of the screen.

Formatting the Shapes

To change the style and design of your chart, select 'Shape Styles' or click on the 'More Fill Colors' option under 'Fills'. Here, you can choose from various color themes, gradients, or even insert photos for a unique touch. Adjust the fonts, text colors, and line thickness under the 'Text Fill' and 'Line' settings to make the chart visually appealing.

Adding Swimlanes

To create a more detailed chart, consider adding swimlanes to group related departments or teams together. This can help visually distinguish between different branches of your organization. Right-click on the chart and select 'Add Swimlane' to divide the chart into sections or 'Change Swimlane Levels' to modify existing ones.

Create an Org Chart in Excel
Create an Org Chart in Excel
How to create a progress chart.#excel #microsoft #microsoftexcel #office #word #o #powerpoint.
How to create a progress chart.#excel #microsoft #microsoftexcel #office #word #o #powerpoint.
Organizational Chart Template. Charity Organization template. Company Organization Template. Employee Structure Excel Template. Org Chart.
Organizational Chart Template. Charity Organization template. Company Organization Template. Employee Structure Excel Template. Org Chart.

Saving and Sharing your Organizational Chart

Once you're satisfied with your organizational chart's design, it's time to save and share it with your team. Click on the chart, then go to the 'Design' tab and click 'Print', 'Save', or 'Share' to disseminate your hard work.

Creating an organizational chart in Excel isn't just a helpful tool for your company; it also serves as a collaborative project that fosters teamwork and understanding among your employees. So grab your team, create an organizational chart that truly represents your company, and watch as your organizational structure comes to life.