✦Template Printable Ideas Insights

Crafting Hierarchy Charts in Excel: A Step-by-Step Guide

By

Creating a hierarchy chart, also known as an organizational chart, is a common requirement in many business and academic settings. Microsoft Excel, with its numerous features and tools, is a popular choice for creating such charts due to its versatility and ease of use. In this comprehensive guide, we will walk you through the step-by-step process of how to create a hierarchy chart in Excel.

Before we dive into the steps, it's crucial to understand that Excel does not have a built-in hierarchy or organizational chart template. However, you can create one using the drawing tools and SmartArt feature. Let's get started!

Preparing Your Data

The first step in creating a hierarchy chart is to organize your data. Ensure that your data is structured in a manner that reflects the hierarchy you want to represent. Typically, this involves listing position titles in the first column, with subordinates listed below their respective managers.

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
How to Make Hierarchy Chart in Excel (3 Easy Ways)
How to Make Hierarchy Chart in Excel (3 Easy Ways)
Create an Organizational Hierarchy Chart in Excel
Create an Organizational Hierarchy Chart in Excel

For example, your data might look like this:

Position Manager
CEO ---
CFO CEO
CTO CEO
Account Manager CFO

Note: Ensure that the first cell in the first row has a heading that accurately describes the data, and format the column headers accordingly.

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
the organizational chart for an organization
the organizational chart for an organization
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?

Creating the Hierarchy Chart

Once you have your data structured, you're ready to create the chart. Here's how:

1. Select the data you want to use for the chart.

2. Go to the 'Insert' tab in the ribbon.

How to Make an Org Chart in Excel (+ video tutorial)
How to Make an Org Chart in Excel (+ video tutorial)
How to Create Multi-Category Chart in Excel
How to Create Multi-Category Chart in Excel
Download Hierarchy Chart Template Information Hierarchy Chart, Advanced Technology, Simple Hierarchy Chart, Editable Business Hierarchy Diagram, Graphic Design Photoshop, Organizational Hierarchy Chart Template, Military Hierarchy Chart, Hierarchy Chart Example, Organizational Chart
Download Hierarchy Chart Template Information Hierarchy Chart, Advanced Technology, Simple Hierarchy Chart, Editable Business Hierarchy Diagram, Graphic Design Photoshop, Organizational Hierarchy Chart Template, Military Hierarchy Chart, Hierarchy Chart Example, Organizational Chart
How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial
Create and Format SmartArt - Hierarchy Chart - Microsoft Office 2013
Create and Format SmartArt - Hierarchy Chart - Microsoft Office 2013
How To Create Charts and Graphs in Excel
How To Create Charts and Graphs in Excel

3. In the 'Illustrations' group, click on 'SmartArt'.

4. In the 'Choose a SmartArt Graphic' dialog box, select the 'Hierarchy' layout, and click 'OK'.

Adding and Formatting Your Chart

1. A new SmartArt graphic will appear in your worksheet. If your data didn't populate the graphic automatically, click on the 'Text' pane on the right, and enter your data manually.

Create an Org Chart in Excel
Create an Org Chart in Excel
How to make a male_female ratio chart in Excel
How to make a male_female ratio chart in Excel
Estructura organizativa jerárquica | Creately
Estructura organizativa jerárquica | Creately
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)

2. To add new levels to the hierarchy, simply click 'Add Shape' at the top of the 'SmartArt Tools' tab in the ribbon. This will create a new level above or below the currently selected shape.

3. To format your chart, use the tools in the 'SmartArt Tools' tab. You can change the layout, colors, styles, and fonts, among other things. Once you're satisfied with your chart, click 'OK' to close the gallery.

Positioning and Refining Your Chart

Now that your chart is created, you can position it anywhere on the worksheet by simple dragging and dropping.

If you need to make further changes to your chart, select it, and use the tools in the 'SmartArt Tools' tab to add, remove, or format shapes. You can also convert your SmartArt graphic to a Microsoft Word document by clicking on 'Convert to SmartArt Graphic'.

Adding Details to Your Chart

Sometimes, you might want to add more details to your chart, like employee information or department names. This can be achieved by using Excel's data validation and conditional formatting features.

1. Select the cell containing the employee name or position you want to add details to.

2. Go to the 'Data' tab in the ribbon.

3. In the 'Data Validation' group, click on 'Validation' and set up your constraints (e.g., listing valid options for a dropdown).

4. Once you've set up your validation, go to the 'Home' tab, and click on 'Conditional Formatting'.

5. Choose 'Highlight Cells Rules', and click on 'Equal to'.

6. In the dialog box that appears, enter the value you want to match, and choose the formatting you want to apply.

7. Click 'OK' to apply the formatting.

Creating a hierarchy chart in Excel can seem daunting at first, but with these steps, you're well on your way to creating professional-looking organizational charts. Keep practicing, and you'll soon be an Excel hierarchy chart pro!