✦Template Printable Ideas Insights

Simple & Quick: Create Excel Org Chart Instantly in 2022

By

Creating an organizational chart, or org chart, is a crucial task for businesses of all sizes. It's a visual representation of your company's hierarchy, reflecting roles, responsibilities, and relationships. Microsoft Excel, with its built-in tools and add-ins, offers an efficient way to create org charts. Here, we'll guide you through the easiest way to create an org chart in Excel.

Before diving into the steps, ensure you have Excel installed on your computer. This guide will use screenshots based on the latest version of Excel, but the process remains similar in earlier versions.

Using the built-in SmartArt feature to create a basic org chart

Excel's SmartArt feature allows you to create a simple org chart quickly. This method works best for small to medium-sized businesses with straightforward hierarchies.

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

To begin, open a new or existing workbook in Excel. Click on "Insert" in the menu, then choose "SmartArt" from the dropdown options. Select "Organization Chart" under the "Hierarchy" category.

Adding and formatting roles

In the SmartArt layout, you'll see a text box for "Add your text." This is where you'll input your company's organizational structure. Start with the CEO or top-level manager at the top, then add their direct reports below them.

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

To add more people, click on the "+" icon beside an existing box. To remove someone, click on the "-". You can also rearrange the structure by dragging and dropping the text boxes. Format the org chart by clicking on the "Design" and "Format" options in the "SmartArt Tools" menu.

Using the/orgchart add-in for more complex org charts

For more extensive and intricate org charts, consider using the free 'orgchart add-in' for Excel. It offers a wide range of features and pre-built templates. Before using the add-in, ensure your Excel version supports add-ins.

To get started, download and install the orgchart add-in from the official website (https://www.orggraph.com/excel). Once installed, click on "Developer" in the Excel menu, then select "orgChart." Choose the desired template from the options provided. You'll now see an org chart with your chosen layout.

the organizational chart for an organization
the organizational chart for an organization
How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial
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
Create Organization Chart in Excel
Create Organization Chart in Excel
How To Create Charts and Graphs in Excel
How To Create Charts and Graphs in Excel

Populating the org chart with data

With the orgchart add-in, you can pull data directly from your Excel spreadsheet. For example, if your employee information is in columns A to E, click on "Data" in the "orgChart" menu, then select "Import list." A dialog box will appear; choose the range containing your data (A1:E50, for instance) and map the columns to the appropriate fields. Click "OK" to import your data.

The orgchart add-in will create a dynamic org chart using your spreadsheet data. As your company structure evolves, simply update your data in Excel, and your org chart will reflect those changes.

Creating an org chart in Excel, regardless of your chosen method, enhances communication and collaboration within your team. It encourages a better understanding of roles and responsibilities, contributing to a more cohesive and productive work environment. So, why not give it a try today and enjoy the benefits of a well-structured organizational chart!

Editable Organizational Chart Template - Excel & Google Sheets - Customize Your Company Structure, Visualize Roles and Hierarchy
Editable Organizational Chart Template - Excel & Google Sheets - Customize Your Company Structure, Visualize Roles and Hierarchy
Organizational Chart Maker
Organizational Chart Maker
How to Create a Scrollable Calendar in Excel Gantt Chart 📅🔄 (Dynamic Date Control)
How to Create a Scrollable Calendar in Excel Gantt Chart 📅🔄 (Dynamic Date Control)