This article was co-authored by wikiHow Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. wikiHow's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards.
The wikiHow Tech Team also followed the article's instructions and verified that they work.
This article has been viewed 37,271 times.
Learn more...
This wikiHow teaches you how to add a new hierarchy chart to in Excel by using Microsoft's SmartArt feature.
Steps
-
1Open a new Microsoft Excel spreadsheet. You can add a hierarchy chart to any Excel workbook regardless of its contents.
-
2Click 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.
-
3Click on the SmartArt button. It will open a menu with different types of SmartArt objects that you can add to your Excel workbook.
-
4Hover over Hierarchy. This will show you different types of hierarchy charts that you can use.
-
5Select a hierarchy chart. Click on the chart you want to add. This will create a new hierarchy chart, and add it to your workbook.
-
6Fill out the hierarchy branches. Click on a box and type on your keyboard to change the contents of your hierarchy chart.
About This Article
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.
