How to Create an Organizational Chart in Excel from a List – 3 Methods


What Is an Organizational Chart?

An organizational chart is a diagram where the hierarchy of an organization is depicted.

The following dataset showcases an Organizational Hierarchy of a company in the form of a list. To create an organizational chart:

Note: Make sure that the positions written in the list maintain the hierarchy order.

how to create an organizational chart in excel from a list

 

Method 1 – Using the Excel SmartArt Design Tab to Create an Organizational Chart from a List

Step 1: Using SmartArt

  • Go to the Insert tab.
  • Click SmartArt in Illustration.

Using SmartArt Design Tab to Create an Organizational Chart

The Choose a SmartArt Graphic dialog box will open.

  • Select Hierarchy.
  • Choose Organization Chart.

The following image will be displayed.


Step 2: Editing the Organizational Chart

  • Click as shown below.
  • Press CTRL + A.
  • Press DELETE.

Editing Organizational Chart in Excel

All text and shapes will be removed.

  • Select the dataset and press CTRL + C.

copying dataset to create an organizational chart in excel

  • Click as shown below.
  • Press CTRL + V to paste the copied items.

The list will be added:


Step 3: Organizing the Organizational Chart

  • Click anywhere in the Organization Chart.
  • Click SmartArt Design.

Constructing Organizational Chart in Excel

  • Click VP HR as shown below.
  • Click Demote as VP HR is one position below the President.

This is the output.

  • Choose Staff.
  • Click Demote 2 times (it is 2 positions below the President).

Editing Position to create an organizational chart in excel

This is the output.

  • Select Recruitment.
  • Click Demote 3 times (3 positions below the position of the President).

This is the output.

Follow the same steps for the rest of the positions to get the following output.

final output after creating an organizational chart in Excel


Method 2 – Using the TAB Button to Create an Organizational Chart from a list in Excel

Steps:

  • Follow the steps mentioned in Step 1 and Step 2 of the previous method to get the following output.

Utilizing TAB Button from Keyboard to Create an Organizational Chart

  • Select VP HR.
  • Press the TAB button 1 time.

The VP HR position is added to one position below the President.

  • Click Staff.
  • Press TAB 2 times.

Editing Position to create an organizational chart in excel

This is the output.

  • Choose Recruitment.
  • Press TAB 3 times.

Editing Position to create an organizational chart in excel

This is the output.

Follow the same steps for the other positions to get an organizational chart.

final output after creating an organizational chart in Excel


Method 3 – Using Excel Visio Data Visualizer Add-In to Create an Organizational Chart

Steps:

  • Go to the Insert tab.
  • Choose Add-ins.
  • Select Visio Data Visualizer.

Using Visio Data Visualizer Add-In of Excel to create an organizational chart

The Data Visualizer dialog box will be displayed.

  • Click Continue without signing in (Preview).

You will see the following image:

  • Select Organization Chart.
  • Click Create in Hybrid.

creating hybrid organizational chart in excel

This is the output.

This is a default chart. Edit the data.

  • Edit the columns named Name and Title as shown below.

editing Name and Title to create an organizational chart in excel

The Manager ID indicates the chain of command. For example, VP, HR reports to the President. So Manager ID of VP, HR is ID1 which is the Employee ID of the President.

  • Edit the Manager ID of the Staff position and enter ID2, as the Staff reports to the VP, HR.

  • In the Role Type column, choose Assistant.

This is the output.

Following the same steps, edit Manager ID and Role Type for the other positions.

  • Go to the diagram beside the table and click Refresh.

A dynamic organization chart is created.

final output after creating an organizational chart in Excel


How to Format an Organizational Chart in Excel

1. Changing the Chart Style

Steps:

  • Click SmartArt Design.
  • Choose a style in SmartArt Styles. Here, the 3rd option.

How to Format an Organizational Chart in Excel

This is the output.

Changing Style of an Organization Chart


2. Editing the Color of Nodes in an Organization Chart

Steps:

  • Click SmartArt Design.
  • Select Change Colors.
  • Choose an option. Here, the 1st option in Colorful.

Editing Color of Nodes of an Organization Chart

This is the output.


3. Formatting the Chart Layout

Steps:

  • Go to SmartArt Design.
  • Choose a layout in Layouts.

Formatting Layout of an Organization Chart

This is the output.


Download Practice Workbook


Related Articles


<< Go Back to SmartArt in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Zahid Hasan
Zahid Hasan

Zahid Hassan, BSc, Industrial and Production Engineering, Bangladesh University of Engineering and Technology, has worked with Exceldmy for 1.5 years. He has written 95+ articles for Exceldemy. He has worked as an Excel & VBA Content Developer. He also worked as a VBA Developer for the Template team. Currently, he is working as a Junior Software Developer for the Excel Add-in project. He is interested in Software Development, Python, VBA, VB.NET, and Data Science, expanding his expertise in... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo