This wikiHow teaches you how to use Microsoft's SmartArt function in Excel to insert a representation of the hierarchy.
Step 1. Open a new Microsoft Excel spreadsheet
You can insert a representation of the hierarchy in every Excel workbook, regardless of its content.
Step 2. Click the Insert tab
You can find this button at the top of the screen in the navigation bar next to other options like begin, Formulas and Check. This will open the insert toolbar at the top of the workbook.
Step 3. Click the SmartArt button
This will open a menu with different types of SmartArt objects that you can insert into your Excel workbook.
Step 4. Hover your mouse over hierarchy
This will show you different types of representations of the hierarchy that you can use.
Step 5. Choose a representation of the hierarchy
Click on the representation you want to add. This creates a new hierarchy representation and inserts it into your workbook.
Step 6. Fill in the hierarchy branches
Click on a field and use your keyboard to type in the content of your hierarchy display.