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.
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.
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.
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.
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!