✦Template Printable Ideas Insights

Mastering Excel: Create Hierarchy Charts Step-by-Step

By

You're here because you want to create a hierarchy chart in Excel, and that's precisely what we're going to achieve together. But first, let's understand why a hierarchy chart can be so invaluable in your data visualization endeavors. These charts allow you to exhibit information in a way that shows the relationships between different levels of data, much like an organizational chart or a product category hierarchy.

Now that we've establishes the importance of hierarchy charts let's dive into our step-by-step guide on how to create one in Excel.

Understanding the Data and Structure

Before you start building your hierarchy chart, it's crucial to have a clear understanding of your data and the desired structure. Imagine your data as a tree, with the main topics as the trunk and branches, and the subtopics as the leaves. For example, if you're creating a hierarchy chart for your company's departments and employees, you might have 'HR' as a main topic, with 'Recruitment' and 'Payroll' as its subtopics.

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 Org Chart in Excel (+ video tutorial)
How to Make an Org Chart in Excel (+ video 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?

Once you've decluttered your data and organized it in a hierarchical structure, it's time to start constructing your chart.

Setting Up Your Workbook

For our example, we'll use a simple structure with main topics and two levels of subtopics.

How To Create Charts and Graphs in Excel
How To Create Charts and Graphs in Excel
How to Make Hierarchy Chart in Excel (3 Easy Ways)
How to Make Hierarchy Chart in Excel (3 Easy Ways)
How to make a male_female ratio chart in Excel
How to make a male_female ratio chart in Excel

Organize your data in columns like this:

Category | Subcategory 1 | Subcategory 2
------------------------------------------
Main Topic 1     Subtopic A   Subtopic B
Main Topic 2     Subtopic C   Subtopic D
Main Topic 3     Subtopic E   Subtopic F

With your data set up, it's time to create the hierarchy chart.

Creating the Hierarchy Chart

Now we'll guide you through creating the chart using Microsoft Excel's built-in hierarchy features.

Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know
Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know
41 Organizational Chart Templates (Word, Excel, PowerPoint, PSD)
41 Organizational Chart Templates (Word, Excel, PowerPoint, PSD)
Hierarchy Chart Template
Hierarchy Chart Template
Dynamic charts
Dynamic charts
an image of a bar chart with numbers on it
an image of a bar chart with numbers on it
How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial

1. **Highlight Your Data**: Select your entire data range.

2. **Insert Chart**: Click on 'Insert' in the menu, then select 'Recommended Charts'. Choose the hierarchy chart that best fits your data.

3. **Customize Your Chart**: Right-click on the chart and select 'Format Selection'. Adjust the layout, colors, and styles to make your hierarchy chart visually appealing and easy to understand.

How to create a progress chart.#excel #microsoft #microsoftexcel #office #word #o #powerpoint.
How to create a progress chart.#excel #microsoft #microsoftexcel #office #word #o #powerpoint.
a diagram showing the different types of sales and marketing items in an organization chart, which includes
a diagram showing the different types of sales and marketing items in an organization chart, which includes
Top 25 Basic Excel Formulas Every Beginner Must Know
Top 25 Basic Excel Formulas Every Beginner Must Know

4. **double-check**: Ensure each main topic and subtopic is assigned to the correct level within your hierarchy chart.

Excel's built-in tools will do most of the work, but you might need to adjust some features to achieve the perfect look.

Exporting and Presenting Your Chart

Once your hierarchy chart is complete, you might want to export it as an image for presentations or reports. Excel makes this easy.

1. **Select Your Chart**: Click anywhere within your chart to select it.

2. **Right-click**: Right-click on the selected area and choose 'Save as Picture'.

3. **Choose Format**: Select the format you want (JPEG, PNG, etc.) and click 'Save' to export your chart.

With your hierarchy chart saved, you can now include it in presentations, reports, or share it with colleagues and stakeholders to communicate your data effectively.

Creating hierarchy charts in Excel isn't just about showcasing data; it's about telling a story. By presenting information in an easy-to-understand format, you ensure that your message is clear and compelling. So go ahead, give it a try, and let your data tell a story!