EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Charts Excel Organization Chart
Secondary Sidebar
Excel Functions
  • Excel Charts
    • Excel Data Visualization
    • Dashboard in Excel
    • Bullet Chart in Excel
    • Excel Animation Chart
    • Plots in Excel  
    • Interactive Chart in Excel
    • Surface Charts in Excel
    • Excel Calendar Template
    • Thermometer Chart in Excel
    • Box Plot in Excel
    • S CURVE in Excel
    • Venn Diagram in Excel
    • Project Management with Gantt Chart
    • Change Chart Style in Excel
    • 3D Scatter Plot in Excel
    • Box and Whisker Plot in Excel
    • Radar Chart in Excel
    • Control Charts in Excel
    • Dot Plots in Excel
    • Marimekko Chart Excel
    • Combo Chart in Excel
    • Contour Plots in Excel
    • Candlestick Chart in Excel
    • Map Chart in Excel
    • Pie Chart Examples
    • Excel Stacked Bar Chart
    • Excel Flowchart
    • Excel Types of Graphs
    • Excel Normal Distribution Graph
    • Excel Bell Curve
    • Legends in Excel Chart
    • Excel Chart Templates
    • Excel Organization Chart
    • Excel Doughnut chart
    • Excel 3D Plot
    • Excel Scatter Chart
    • Excel Line Chart
    • Excel Combination Charts
    • Excel Gauge Chart
    • Excel Pivot Chart
    • Excel Clustered Column Chart
    • Excel Dynamic Chart
    • Excel Stacked Column Chart
    • Excel Bubble Chart
    • Histogram Chart Excel
    • Excel Gantt Chart
    • Excel Stacked Area Chart
    • Excel Waterfall Chart
    • Excel Area Chart
    • Excel Clustered Bar Chart
    • Excel Column Chart
    • Excel Pie Chart
    • Comparison Chart in Excel
    • Pareto Analysis in Excel
    • Add a Secondary Axis in Excel
    • Grouped Bar Chart
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (36+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Tips (220+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED COURSE
  • Excel Data Analysis Course
  • Excel for Marketing Course

Excel Organization Chart

By Madhuri ThakurMadhuri Thakur

Organization Chart in Excel

Excel Organization Chart (Table of Contents)

  • Organization Chart in Excel
  • How to Create an Organizational Chart in Excel?

Organization Chart in Excel

An organizational chart is used to display the management structure/team structure of any company or organization.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Every organization has a management hierarchy, which is represented by a row of boxes. The hierarchy level is represented by one on top of the others, 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.

You can download this Organization Chart Excel Excel Template here – Organization Chart Excel Excel Template

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.

Follow the below steps for this:

Step 1 – Go to the INSERT tab. Click on SmartArt options under the Illustrations section as per the below screenshot.

Organization Chart Example 1-1

It will open a SmartArt Graphic dialog box for various options, as shown below:

Organization Chart Example 1-2

Step 2 – Now click on the Hierarchy option in the left pane, and it will display the various types of templates in the right side window. Refer to the below screenshot.

Organization Chart Example 1-3

Step 3 – Select the template which you would require to use. We are clicking here on the very first template, as shown below:

Organization Chart Example 1-4

After clicking on the shape, it will display a SmartArt shape in an excel sheet, which looks like the below screenshot.

Organization Chart Example 1-5

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 to the below screenshot.

Enter the CEO

Step 5 – Now, write the Vice President under the second text box.

Vice President

Step 6 – As assistant President falls under Vice President, choose the 3rd text box and click on Demote option under Create Graphic section, as shown in the below screenshot.

Demote option

Step 7 – Now write Assistant Vice President in the box.

Assistant Vice President

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:

Organization Chart Example 1-10

Step 9 – After creating the chart, you can close the chart Box by clicking on the cross button, as shown below.

Organization-Chart-Example-1-11

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 shape, click on that shape and go to the FORMAT tab. Here a lot of options are available for editing. Refer to the below screenshot for your reference.

Organizational Chart Example 1-12

If you want to edit all the shapes simultaneously, select all shapes with the 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:

Organizational Chart Example 2-1

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:

Organizational Chart Example 2-2

Things to Remember about Organization Chart in Excel

  • Organization charts help you to make better decisions faster.
  • Before preparing the chart, you need to collate the full information about the organization’s different roles.
  • 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.

Recommended Articles

This has been a guide to Organization Chart in Excel. Here we discuss creating an excel organization chart along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Excel Gauge Chart
  2. Excel Clustered Column Chart
  3. Histogram Chart Excel
  4. Interactive Chart in Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Data Analysis Training (17 Courses, 8+ Projects)4.9
Excel for Marketing Training (8 Courses, 13+ Projects)4.8
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

Download Organization Chart Excel Excel Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Organization Chart Excel Excel Template

EDUCBA

डाउनलोड Organization Chart Excel Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more