This wikiHow teaches you how to add a new hierarchy chart to in Excel by using Microsoft's SmartArt feature.

10 Second Summary

1. Open a new Excel spreadsheet.
2. Click Insert at the top of your screen.
3. Click SmartArt.
4. Hover over Hierarchy.
5. Select a hierarchy chart.
6. Fill out the boxes on your hierarchy chart.

Steps

1

Open a new Microsoft Excel spreadsheet. You can add a hierarchy chart to any Excel workbook regardless of its contents.

2

Click on the Insert tab. This button is located on the navigation bar at the top your screen next to other options including Home, Formulas, and Review. It will open the Insert toolbar at the top of your spreadsheet workbook.

3

Click on the SmartArt button. It will open a menu with different types of SmartArt objects that you can add to your Excel workbook.

4

Hover over Hierarchy. This will show you different types of hierarchy charts that you can use.

5

Select a hierarchy chart. Click on the chart you want to add. This will create a new hierarchy chart, and add it to your workbook.

6

Fill out the hierarchy branches. Click on a box and type on your keyboard to change the contents of your hierarchy chart.