How to Create Hierarchy in Excel
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.
Step-by-Step Guide
-
Step 1: Open a new Microsoft Excel spreadsheet.
You can add a hierarchy chart to any Excel workbook regardless of its contents. -
Step 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. , 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. -
Step 3: Click on the SmartArt button.
-
Step 4: Hover over Hierarchy.
-
Step 5: Select a hierarchy chart.
-
Step 6: Fill out the hierarchy branches.
Detailed Guide
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.
About the Author
Virginia Patel
Professional writer focused on creating easy-to-follow crafts tutorials.
Rate This Guide
How helpful was this guide? Click to rate: