• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Hierarchy Chart in Excel

August 23, 2021 by Andrew Childress
Add hierarchy chart in Excel

A hierarchy chart is a great way to visualize the structure of your organization. Let’s learn how to add a hierarchy chart in Microsoft Excel.

A hierarchy chart is a great way to visualize the structure of your organization. It shows multiple levels, tiers, or employee reporting relationships. Fortunately, these are quite easy to use in Excel. Let’s learn how to add a hierarchy chart in Microsoft Excel.

How to Add a Hierarchy Chart in Excel

Hierarchy charts are easy to draw in Excel. In fact, the software does the work for you. You simply fill in the blanks with your key details.

To add a hierarchy chart in Excel, begin by going to the Insert tab, found on the ribbon. Then, click on the Insert a SmartArt Graphic dropdown menu. You’ll see an array of options appear: List, Process, Cycle, and several others. The one you want is Hierarchy.

Hierarchy in Excel

Hover over the Hierarchy option, and review the style thumbnails inside. Click on one to apply it, and Excel will add the design onto your sheet. You’ll notice that it has a default layout with one node at the top, one off to the side, and three at the bottom.

In the SmartArt Text menu, you can customize the text inside each of the fields. You can also click on any of the lines to select it, then press Delete on your keyboard to remove it.

Hierarchy chart in Excel

It’s also possible to add to your hierarchy. For example, if you want additional fields at the bottom, click on the text line for the square that you want to add to. Then, click the + button on the SmartArt Text menu to add to your chart.

Add hierarchy chart in Excel

Once you’re finished, you can make edits like color changes by exploring the SmartArt Design tab on the ribbon.

As you can see, it’s easy to add a hierarchy chart in Excel. This helps you explain, introduce, and illustrate the structure of an organization or team.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Customize Excel smartartAdd SmartArt in Excel
Next Post:Map Chart in ExcelAdd map charts in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top