✦Template Printable Ideas Insights

How to Edit Hierarchy Chart in Excel

By

Editing a hierarchy chart in Excel can be a crucial task, especially when you need to present complex data in a clear and understandable format. Microsoft Excel provides a range of tools to help you create and edit these charts seamlessly. Let's dive into a step-by-step guide on how to edit a hierarchy chart in Excel.

The first step is to differentiate between an organization chart and a hierarchy chart. While both help to illustrate hierarchical data, an organization chart typically shows the structure of a business or organizational unit, and a hierarchy chart shows the relationships between items based on their hierarchical levels. Now, let's start editing your hierarchy chart.

Select and Customize the Chart

Every editing process begins with selection. To edit your hierarchy chart, first, you need to select the chart. This can be done by simply clicking on the chart. Once the chart is selected, you will have a set of tools at your disposal, mainly located under the 'Design' and 'Format' sections in the 'Chart Tools' tab.

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

Under 'Design', you can change the chart type, add or switch row or column, and add or remove chart elements. The 'Format' section offers options to format the chart elements, axis, and plot area.

Change the Chart Type

If you're not satisfied with the chart type, you can change it under the 'Change Chart Type' option. Excel offers a variety of chart types, such as bar, line, pie, and more, helping you to best present your data.

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)
the most useful excel chart info sheet
the most useful excel chart info sheet
How To Create Charts and Graphs in Excel
How To Create Charts and Graphs in Excel

For instance, if your hierarchical data is better represented as a list, you might want to change your chart type to a simple list or table. Just click on 'Change Chart Type', select the desired chart type from the list, and click 'OK'.

Add or Remove Rows or Columns

Hierarchy charts are based on hierarchy, so it's crucial to keep the right number of rows or columns. You can add or remove rows or columns depending on your needs. To add a new row, right-click anywhere on the chart and click on 'Select Data'. In the 'Edit Series' box, click 'Add', provide the necessary details like series name, series formula, and click 'OK'. Repeat the same process to remove any unwanted rows or columns.

Remember, the order of series in the 'Select Data' source list determines the order of hierarchy in the chart. Hence, rearrange them accordingly.

How to Make an Organizational Chart in Excel - Tutorial
How to Make an Organizational Chart in Excel - Tutorial
Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know
Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know
How to make a male_female ratio chart in Excel
How to make a male_female ratio chart in Excel
Create a Stacked Column Chart with Total in Microsoft Excel
Create a Stacked Column Chart with Total in Microsoft Excel
Excel knowledge
Excel knowledge
41 Organizational Chart Templates (Word, Excel, PowerPoint, PSD)
41 Organizational Chart Templates (Word, Excel, PowerPoint, PSD)

Format the Chart

Once you've made the necessary adjustments to your chart type, it's time to adjust the visual aspects. The 'Format Selection' pane in the 'Format' section allows you to customize various elements of the chart, such as color, line, fill, and text.

For instance, you can change the color of a data series to differentiate between different levels in the hierarchy. Just click on the series, go to the 'Format Selection' pane, and select the 'Fill' icon. From the color options, select the color you desire.

Format the Axis

You can also customize the axis. Once you've selected the axis, the 'Format Selection' pane will have various options related to the selected axis. For example, the 'Axis Options' group allows you to reverse the plot order, swap series, or even add gridlines.

an excel chart with many different types of items and numbers on the page, including office hours
an excel chart with many different types of items and numbers on the page, including office hours
Dynamic charts
Dynamic charts
Hierarchy Chart Template
Hierarchy Chart Template

You can also add titles to the axes to better illustrate your data. To do this, select the axis, go to the 'Format Selection' pane, and click on the 'Text' icon. Add your title in the 'Has Text' box, and click 'Close'.

Format the Plot Area

The plot area is the area where your data series is plotted. You can customize the plot area by changing its fill, line color, and line style. Select the plot area, go to the 'Format Selection' pane, and select either the 'Fill' or 'Line' icon to make the necessary changes.

Keep in mind, changes to the plot area affect the entire chart. If you want to apply specific changes to certain parts of the chart, consider splitting the chart. This can be done under the 'Switch Column' option in the 'Design' section.

That's it! Hopefully, these steps have helped you edit your hierarchy chart in Excel. The key to successful editing is understanding what you want to convey and using Excel's tools to effectively express that. As you work with Excel more, you'll become increasingly comfortable creating and editing charts to effectively communicate your data.