How to Make an Org Chart in Excel: SmartArt Hierarchy and an Employee List

shape
shape
shape
shape
shape
shape
shape
shape
How to Make an Org Chart in Excel: SmartArt Hierarchy and an Employee List - featured image

An organization chart, or org chart, shows who reports to whom in a company or a team. It helps new employees see how the business is structured, helps managers plan hiring and helps everyone find the right person to ask. Excel can draw one in a few minutes with SmartArt, and it can also keep the data behind the chart in a table, so you can count people, check for gaps and update the chart when someone joins or leaves. This guide shows both parts: how to insert and edit the chart, and how to keep a simple employee list with formulas. It uses a small ten-person example with numbers you can verify by hand.

Updated November 2026

In this guide

  1. Two ways to build an org chart
  2. Example company
  3. Step 1: insert a SmartArt hierarchy
  4. Step 2: type the names
  5. Step 3: add, move and delete boxes
  6. Step 4: choose a layout for large teams
  7. Step 5: change colors and style
  8. Step 6: add a photo or a picture
  9. Step 7: keep an employee table
  10. Step 8: count direct reports with a formula
  11. Step 9: check the data
  12. Step 10: print or share the chart
  13. Other ways to build an org chart
  14. Common mistakes
  15. Practice problems
  16. Quick recap

Two ways to build an org chart

The quick way is to draw the chart with SmartArt, which is a set of ready-made diagrams in Excel. You type the names into a text pane, and Excel arranges the boxes. This is perfect for a one-page chart that you print or paste into a document. The data way is to keep an employee table with a column for the manager, and to use formulas for counts and checks. The best result is to do both: use the table as the master list and the SmartArt chart as the picture. When someone changes role, update the table first, and then redraw the chart.

Example company

Use a small company with ten people. The Director is at the top. Under the Director are three managers: Sales, Operations and Finance. The Sales manager has three team members, the Operations manager has two and the Finance manager has one. So the numbers are 1 director, 3 managers and 6 team members, which makes 10 people in total. The Director has 3 direct reports, Sales has 3, Operations has 2 and Finance has 1. We will use these figures to check the formulas.

Step 1: insert a SmartArt hierarchy

Open a new sheet and go to the Insert tab. Choose SmartArt in the Illustrations group. In the dialog, click Hierarchy on the left, choose Organization Chart and click OK. Excel places a chart with a few boxes on the sheet, and a Text Pane opens on the left. If the Text Pane does not appear, click the small arrow on the left edge of the chart frame. The chart is an object, so you can move and resize it by dragging the frame.

Step 2: type the names

Click the first line in the Text Pane and type the name of the Director, and a title if you wish, on two lines by pressing Shift and Enter. Press Enter to add a new box at the same level. Press Tab to demote the new line, which makes it a subordinate of the box above. Type the three managers after one Tab. Then press Enter and Tab again to add team members under each manager, and Shift and Tab to move back up a level. Typing in the pane is faster than clicking each box.

Step 3: add, move and delete boxes

To add a box with the mouse, click an existing box, go to SmartArt Design and choose Add Shape. The options include After, Before, Above and Below. Add Shape Below creates a subordinate, and Add Shape After creates a peer. To move a person, select the line in the Text Pane and use the Promote and Demote buttons, or the Move Up and Move Down buttons. To delete a box, click its border and press Delete. The chart rearranges itself each time, so you do not have to align the boxes by hand.

Step 4: choose a layout for large teams

With many people under one manager, the boxes become wide and small. Click a manager box, and in SmartArt Design use the Layout button in the Create Graphic group to switch that manager to Standard, Both, Left Hanging or Right Hanging. The hanging layouts stack the team members vertically under the manager, which saves a lot of width. For our example, set each manager to Hanging, and the chart fits easily on a landscape page. If the text is too small, shorten the titles or reduce the number of levels shown.

Step 5: change colors and style

Click the chart and go to SmartArt Design. Choose Change Colors to apply a color scheme, and pick a style from SmartArt Styles. For a professional look, use one color for the leadership level and a lighter shade for the teams. In the Format tab, you can change the font, the box outline and the fill of a single box. Keep the number of colors low, and keep the text dark on light boxes for readability. Use the same font as the rest of your company documents.

Step 6: add a photo or a picture

Excel has an organization chart with pictures in the SmartArt gallery. Select it from the Hierarchy group, which is named Picture Organization Chart. Click the small picture icon in a box and insert the photo of the person from a file. Use square photos of the same size, taken in the same style, so the chart looks tidy. Pictures help in a large company, where people may not know each other, but they also take space, so use them only when they add value.

Step 7: keep an employee table

On a second sheet, make a table with the columns ID, Name, Title, Department and Manager. Press Ctrl+T and name the table Staff, as explained in our table guide. In the Manager column, type the name of the person’s manager, and leave it empty for the Director. For our example, the three managers have the Director as their manager, and the six team members have the manager of their department. This one table holds the whole structure and can be sorted and filtered.

Step 8: count direct reports with a formula

Add a column called Direct reports with =COUNTIF(Staff[Manager],[@Name]). For the Director it returns 3, for Sales 3, for Operations 2, for Finance 1 and for each team member 0. The total of the column is 3 plus 3 plus 2 plus 1, which is 9, and that equals the number of people who have a manager, since 10 people minus the Director leaves 9. This is a good check: the sum of direct reports must equal the headcount minus one. Our COUNTIFS guide explains how to add more conditions.

Step 9: check the data

To find people whose manager is not in the list, add a column with =IF([@Manager]="","Top",IF(COUNTIF(Staff[Name],[@Manager])=0,"Check","OK")). The Director shows Top, and everybody else should show OK. A Check means a typo in the manager name or a manager who left. Use a drop-down for the Manager column, based on the Name column, to prevent these mistakes. See our drop-down list guide for the steps. Clean data makes the chart easy to rebuild.

Step 10: print or share the chart

Select the chart and set the print area, then choose Landscape orientation and Fit to 1 page wide. Preview it before printing. To use the chart in another document, select the chart, copy it and paste it into Word or PowerPoint, either as a picture or as an editable object. Save a PDF copy for people who only need to read it. Add the date at the bottom, because an org chart goes out of date quickly, and a date tells readers how recent it is.

Other ways to build an org chart

Microsoft 365 offers add-ins that build a chart from the table automatically, and some versions of Excel include a Data Visualizer feature for flowcharts and org charts. These depend on your plan and your version, so check what you have. You can also draw boxes manually with Insert, Shapes and connect them with lines, which gives full control but takes longer. For a very large company, a dedicated tool may be better. For most small businesses, SmartArt and a clean table are enough.

Common mistakes

The most common mistake is to build a chart with too many levels or too many boxes on one page. Another is to leave out the title or the department. A third is to keep the chart and the table in different files, so they disagree. A fourth is to mix up the reporting line and the job grade. A fifth is to forget to update the chart after changes. A sixth is to type the manager name differently from the staff name. Use drop-downs, and review the chart every quarter.

Practice problems

Try these. Problem 1: a manager with 4 team members has 4 direct reports. Problem 2: a company with 10 people and one top person has 9 reporting lines. Problem 3: if the Director has 3 managers, and the managers have 3, 2 and 1 team members, the total headcount is 1 plus 3 plus 6, which is 10. Problem 4: build the SmartArt chart for this company with Hanging layouts. Problem 5: add one more team member in Finance and check that the Finance count becomes 2 and the headcount becomes 11.

Quick recap

Insert a SmartArt Organization Chart from the Hierarchy group. Type names in the Text Pane, using Enter for peers and Tab for subordinates. Use Add Shape, Promote and Demote to edit, a Hanging layout for large teams and a few colors for style. Keep the master list in a table with a Manager column, count direct reports with COUNTIF and check for missing managers. Print on one landscape page, date the chart and update it whenever the structure changes.

Frequently asked questions

How do I make an org chart in Excel?

Go to Insert, SmartArt, Hierarchy, choose Organization Chart and type the names in the Text Pane.

How do I add a box to an org chart in Excel?

Select a box and choose Add Shape in the SmartArt Design tab.

How do I create an org chart from a list in Excel?

Keep a table with a manager column and build the SmartArt chart from it, or use an add-in.

How do I count direct reports?

Use COUNTIF on the Manager column.

Can I add pictures to the chart?

Yes, use the Picture Organization Chart layout.

Related guides and free tools

Leave a Reply

Your email address will not be published. Required fields are marked *