You can add a hierarchy chart to any Excel workbook regardless of its contents.;
, 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.
 It will open a menu with different types of SmartArt objects that you can add to your Excel workbook.
 This will show you different types of hierarchy charts that you can use.
 Click on the chart you want to add. This will create a new hierarchy chart, and add it to your workbook.
 Click on a box and type on your keyboard to change the contents of your hierarchy chart.
Open a new Microsoft Excel spreadsheet.
Click on the Insert tab.
Click on the SmartArt button.
Hover over Hierarchy.
Select a hierarchy chart.
Fill out the hierarchy branches.
{"src": "wikihow-all_test", "title": "How to Create Hierarchy in Excel"}