✦Template Printable Ideas Insights

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

By

In the corporate world, an organizational chart (org chart) is a crucial tool for visualizing the hierarchy and structure of a company. It's a graphical representation of the roles, responsibilities, and relationships among the members of an organization. While dedicated software can create complex org charts, Excel, with its extensive spreadsheet capabilities, can also serve as a versatile tool for creating simple to moderately complex organizational structures. So, can you create an org chart in Excel? Absolutely!

Excel's built-in features, along with some indirect techniques, allow you to design an org chart. However, it's essential to understand that Excel is not as intuitive or feature-rich as dedicated org chart software like orgplus or Lucidchart. Yet, it gets the job done for small to medium-scale organizations. Let's dive into how to create an org chart in Excel.

Using Microsoft Excel's Smart Art

Microsoft Excel comes with a feature called Smart Art, which can help you create an org chart. It offers various layouts and styles for depicting hierarchical structures, making it a handy tool for basic org chart creation.

Create Org Chart
Create Org Chart
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)

To use Smart Art, follow these steps:

  1. Open a new or existing Excel workbook.
  2. Click on 'Insert' in the menu.
  3. In the 'Illustrations' section, click on 'Smart Art.'
  4. Choose the 'Org Chart' layout that best suits your needs.
  5. Click 'OK.' The Smart Art will be inserted into your worksheet.
  6. Double-click on each box to enter the employee's name or position.
  7. Use the 'Design' and 'Format' tabs to customize the look of your org chart.

Leveraging Shapes and Smart Art for Complex Structures

If the included org chart layouts in Smart Art don't meet your requirements, consider using a combination of shapes, text boxes, and Smart Art to create more complex structures. Here's how:

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

1. Insert shapes and text boxes to represent positions in your org chart using the 'Insert' tab.

2. Use drag-and-drop to connect the shapes with Smart Art connectors. These connectors come in various designs and can help demonstrate the hierarchical relationships.

3. Add text to each shape or text box to depict the employee's name, position, or department.

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
7 Types of organizational structures
7 Types of organizational structures
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
Automatic Org Chart Maker: Excel Template with Photos (Ready to Print)
Automatic Org Chart Maker: Excel Template with Photos (Ready to Print)
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

Manipulating Tables for Organizational Data

Sometimes, your organizational data might be stored in an Excel table or database. In such cases, you can use Power Query or PivotTable to present this data in a visual, org chart-like format. Here's how:

Power Query

Power Query is a powerful tool in Excel that helps you clean, transform, and connect to data. You can use it to filter, sort, and pivot your organizational data, creating a simplified org chart structure. Here are the steps:

1. Select your data range.

How to Create An Org Chart in 5 Mins
How to Create An Org Chart in 5 Mins
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
How to Create an Organizational Chart in Word with Free Templates | EdrawMax
How to Create an Organizational Chart in Word with Free Templates | EdrawMax

2. Click on the 'Data' tab in the menu.

3. Click on 'Get Data' and select 'From Table/Range.'

4. Click 'Transform Data' in the 'Get Data to Table' dialog box.

5. Use the tools in the 'Home,' 'Transform,' and 'Add Column' tabs to clean, transform, and pivot your data as needed.

PivotTable

A PivotTable is an interactive table that allows you to rotate or 'pivot' data in a way that makes it easier to analyze. Here's how to create one:

1. Select your data range.

2. Click on the 'Insert' tab in the menu.

3. Click on 'PivotTable.'

4. Choose where you want to place the PivotTable and click 'OK.'

5. In the 'Create PivotTable' dialog box, choose whether you want to add your data to the Data Model, then click 'OK.'

6. Use the fields in the 'PivotTable Fields' pane to create rows, columns, and values in your PivotTable.

Creating an org chart in Excel requires creativity, a bit of manual work, and a solid understanding of the tool. However, for small to medium-sized organizations, Excel's features can effectively meet their org chart needs. If you're working in a larger organization with complex structures, consider using dedicated org chart software for more advanced functionality. Happy charting!