Creating a tree chart, also known as an organizational chart or hierarchy chart, in Excel can be a powerful way to visualize data and relationships. Whether you're mapping out a project's phases, displaying a company's organizational structure, or showing the hierarchy of a product's features, Excel's tree chart functionality can help you achieve this.
Before we dive into the step-by-step process, ensure you have the latest version of Excel. The tree chart feature is available in Excel 2016 and later versions, including Excel for Mac. Now, let's explore how to create a tree chart in Excel.
Preparing Your Data
Before creating a tree chart, you need to structure your data correctly. Tree charts work best with hierarchical data, where each level has a parent-child relationship. For instance, in an organizational chart, each employee has a manager (parent), and each manager has subordinates (children).
In Excel, you can represent this hierarchy using a simple list or a table. Each row should represent an item, and the first column should contain the parent item. If an item has no parent, leave the cell blank. Here's a simple example:
| Parent Item | Child Item |
|---|---|
| CEO | Marketing Director |
| Marketing Director | Social Media Manager |
| Marketing Director | Content Manager |
| Sales Director | Regional Sales Manager (East) |
| Sales Director | Regional Sales Manager (West) |
Creating the Tree Chart
Once your data is ready, you can create the tree chart. Here's how:
- Select the data you want to use for the chart.
- Go to the 'Insert' tab in the Excel ribbon.
- In the 'Illustrations' group, click on 'Organization Chart'.
- In the 'Choose a 2D or 3D Organization Chart' dialog box, select 'Hierarchy' and click 'OK'.
Customizing the Tree Chart
After creating the chart, you can customize it to fit your needs. Here are some ways to do that:
- Change the layout: Right-click on the chart and select 'Format'. In the 'Format Selection' pane, go to 'Layout' and choose the layout that best suits your data.
- Add or remove levels: Right-click on a level and select 'Add Level' or 'Remove Level' to adjust the hierarchy.
- Change the style: Right-click on the chart and select 'Format'. In the 'Format Selection' pane, go to 'Shape Styles' and choose a style that fits your theme.
- Add or remove shapes: Right-click on a shape and select 'Add Shape' or 'Remove Shape' to adjust the chart's appearance.
Adding Data to the Tree Chart
If you've created a tree chart but haven't added data yet, or if you want to update the data in your chart, here's how:
![[FREE] Determine Correlation of Data Sets Using Bubble Chart in Excel](https://i.pinimg.com/originals/8a/a3/d6/8aa3d68afb6786211b534738eaa90914.jpg)
![Ultimate KPI Tree Guide: What Is a KPI Tree & How to Build KPI Trees That Work [2026]](https://i.pinimg.com/originals/e6/56/f5/e656f5838e72fc86a1dd3bc440894ff1.jpg)
1. Click anywhere in the chart to select it.
2. Go to the 'Design' tab in the Excel ribbon.
3. In the 'Data' group, click on 'Edit Data'.
4. In the 'Edit Chart Data' dialog box, update the data as needed. When you're done, click 'OK'.
Updating the Chart Automatically
If you want your chart to update automatically whenever you update your data, follow these steps:
1. Click anywhere in the chart to select it.
2. Go to the 'Design' tab in the Excel ribbon.
3. In the 'Data' group, make sure 'Edit Data' is checked. If it's not, click on it to check it.
Now, whenever you update your data, your chart will update automatically.
Creating a tree chart in Excel can help you visualize complex data in a simple, easy-to-understand format. Whether you're mapping out a project, displaying an organizational structure, or showing a product's features, a tree chart can help you communicate your message effectively. So, go ahead and give it a try!