Open Excel
Select the worksheet where you want the chart
Go to the Insert tab
Click SmartArt
Choose Hierarchy
Select an organization chart or other hierarchy layout
Click OK
Enter the top-level name in the first box
Add subordinate names in the lower boxes
Use the SmartArt Design tab to add shapes
Use the SmartArt Design tab to promote or demote levels
Use the SmartArt Design tab to change layout or colors
Resize the chart if needed
Format text, shapes, and spacing as needed
Save the workbook