Excel Organization Chart (Table of Contents)
Organization Chart in Excel
An organizational chart is used to display the management structure/team structure of any company or an organization.
Every organization has the management hierarchy which is represented by a row of boxes. The level of the hierarchy is represented by one on top of other and it will look like a pyramid.
Lines are used for adding these levels which show the relationship between the individual hierarchy boxes.
How to Create an Organizational Chart in Excel?
To create an organizational chart in excel is very simple and easy. Let’s understand how to create an organizational chart in excel with some examples.
Excel Organization Chart – Example #1
We have a small manufacturing company XYZ and have a total of 20 employees in the organization. The hierarchy of the organization are as follows:
Now we have to prepare an excel organization chart as per the hierarchy mentioned above.
4.8 (2,465 ratings)
Follow the below steps for this:
Step 1 – Go to INSERT tab. Click on SmartArt options under Illustrations section as per below screenshot.
It will open a SmartArt Graphic dialog box for various options as shown below:
Step 2 – Now click on Hierarchy option in the left pane and it will display the various types of template in the right side window. Refer below screenshot.
Step 3 – Select the template which you would require to use. We are clicking here on the very first template as shown below:
After clicking on the shape, it will display a SmartArt shape in excel sheet which looks like below screenshot.
The first text box shows the head which drives the whole chart and manages the whole organization. As per the given example, the CEO is the head of the organization.
Step 4 – Enter the CEO title under the first text box. Refer the below screenshot.
Step 5 – Now write the Vice President under the second text box.
Step 6 – As assistant President falls under Vice President hence choose the 3rd text box and click on Demote option under Create Graphic section as shown in the below screenshot.
Step 7 – Now write Assistant Vice President in the box.
Step 8 – Same repeat the procedure for the next positions. For any upper position click on Promote option under Create Graphic section. The final Organisation chart is shown below:
Step 9 – After creating the chart, you can close the chart Box by clicking on the cross button as shown below.
Editing the Chart
You can edit the chart anytime by using SmartArt Tools. If you want to edit the shape or fill the color in the shape, click on that shape and go to the FORMAT tab. Here a lot of options is available for editing. Refer the below screenshot for your reference.
If you want to edit all the shapes simultaneously, select all shape with CTRL+A shortcut key and apply the formatting as per the requirement.
Excel Organization Chart – Example #2
Let’s take another example. Below is the management hierarchy:
Ian Smith is the head of the Quality team and David Holmes and Richie Henderson report to him. Rocky Jacob and Samuel Samson are the team agents who report to David Holmes. Andrew Peterson and Annie Newson report to Richie Henderson.
For creating the management chart, we will repeat the above process as we did in Example 1.
Below is the final chart:
We can drag the shapes accordingly. You can choose the shape layouts by using the DESIGN tab.
The final editing management chart is given below:
Things to Remember about Organization Chart in Excel
- Organization charts help you to take better decisions faster.
- Before preparing the chart, you need to collate the full information about the different roles in the organization.
- Then identify the relationship as per the reporting between them.
- You can format the chart by using SmartArt tools and choose the shape layouts as per your preference.
This has been a guide to Organization Chart in Excel. Here we discuss how to create excel organization chart along with practical examples and downloadable excel template. You can also go through our other suggested articles –