How to Make an Org Chart in Excel

Charts & pivot tables · Updated November 19, 2026

The easiest way to make an org chart in Excel for Microsoft 365 on Windows is to use SmartArt: select Insert > SmartArt > Hierarchy > Organization Chart, then enter names and job titles in the Text Pane. Excel arranges the boxes into a reporting structure, which you can format and adjust without drawing each box by hand.

Why SmartArt is the easiest option

SmartArt is designed for diagrams whose parts have a clear relationship. An organization chart is a hierarchy: one person or role reports to another, and that relationship is shown through connected boxes. SmartArt creates the boxes and connectors together, so adding or moving a person usually updates the diagram without requiring you to redraw its lines.

This built-in approach is usually best for a small or medium-sized chart that you want to show in a worksheet, print, or copy into a presentation. It is quicker to set up than arranging shapes manually, and it does not require a separate add-in. SmartArt is included with desktop Excel, although access to Excel itself depends on your Microsoft 365 license or other Office license.

There is an important distinction: Excel does not automatically turn any employee list into a finished org chart simply because the list has names and manager names. SmartArt expects you to supply the hierarchy, either by typing and indenting entries or by using its shape controls. If your employee data changes often, plan for some maintenance rather than expecting the chart to update itself from a data table.

Create the chart with SmartArt

Start with a blank area of a worksheet or a new worksheet. The chart is a floating graphic, not a table of cells, so leave room for it to expand. Then follow these steps in Excel for Microsoft 365 on Windows:

  1. Choose Insert > SmartArt on the ribbon.
  2. In the Choose a SmartArt Graphic window, select Hierarchy, then choose Organization Chart. Select OK.
  3. Click the Text Pane control on the SmartArt Design tab if the pane is not already visible. The pane is where you can enter and organize the chart labels.
  4. Replace the placeholder text with a person’s name, role, or both. For example, enter Jordan Lee — General Manager for the top box.
  5. Add the next person and set their level in the hierarchy. Continue until the reporting relationships are represented.
  6. Resize or reposition the graphic as needed. Use the corner handles to resize proportionally, and drag the chart’s border to move it.

For a very small chart, you can also click directly in a box and type. The Text Pane is easier to manage once the chart has several people, because it exposes the hierarchy as an indented list rather than making you select each box individually.

Enter names and set reporting levels

In the Text Pane, each bullet corresponds to a box. Press Enter to create another entry at the current level. To make an entry a subordinate of the entry above it, place the cursor in the new entry and press Tab. To move it back up one level, press Shift+Tab. The indentation in the pane indicates who reports to whom; it is not merely visual spacing.

For example, a simple structure could be entered in this order: the general manager, a sales manager and an operations manager at the next level, then the sales representatives under the sales manager and the shift leads under the operations manager. Indent each group of direct reports beneath its manager. Avoid indenting someone just to make the chart look balanced: the indentation tells Excel to show a reporting relationship.

You can also change the structure with the ribbon. Select a box, then use SmartArt Design > Add Shape to add a shape after or before the selected one, above it, or below it. The available choices depend on the selected shape and diagram. The Promote and Demote controls on the same tab can change a selected person’s level. These tools are helpful when reorganizing a chart already in place.

Keep the labels compact. A name on one line and a title on the next is often easier to scan than a long description. SmartArt boxes can contain more text, but long labels make boxes wider or taller and can crowd the page.

Make the chart readable and presentation-ready

After entering the structure, click the graphic to display the SmartArt contextual tabs. On SmartArt Design, the SmartArt Styles gallery offers visual treatments, and Change Colors provides color variations. These are quick ways to improve contrast and make the diagram look consistent. On the Format tab, you can adjust selected shapes’ fills, outlines, and text styling.

Choose a restrained style before adding lots of individual formatting. A chart with one clear color for managers and another for teams may help readers distinguish levels, but too many colors can imply categories that do not exist. Check that text is readable at the size at which people will view or print the chart. A diagram that looks clear when zoomed in may become illegible on a printed page.

  • Use consistent name and job-title formatting in every box.
  • Keep the reporting lines visible and avoid covering them with labels or other objects.
  • Give the chart enough worksheet space, particularly when several people report to one manager.
  • Use a descriptive worksheet name, such as Org Chart, and add a date or revision note if the chart is a snapshot.

For printing, open File > Print to check the preview before distributing the workbook. If the chart is too wide, try landscape orientation or a larger paper size, if available. Scaling a crowded chart to fit one page can make the text too small, so splitting it across pages or simplifying the displayed detail may be more useful.

Choose a layout that matches the organization

The standard Organization Chart layout works well when the reporting structure is mostly top-down. If it becomes too tall or wide, select a box and explore the layout controls on the SmartArt Design tab. Depending on the selected box and diagram, options such as hanging layouts can change how subordinate boxes are arranged. A layout changes presentation, not the underlying reporting relationships.

For a chart with a manager and several direct reports, a standard layout is usually easiest to interpret. For a manager who has several layers of teams, a hanging arrangement can use page space more effectively. Try alternatives on a copy if you are unsure: changing a layout can alter the visual grouping, and you should verify that readers can still tell which people report to which manager.

Excel SmartArt is less suitable for a very large organization, a matrix structure in which people report to multiple managers, or a chart that must be generated repeatedly from a changing database. A conventional org chart communicates a primary reporting line well, but it can give a misleading impression if it is used to represent every project relationship or dotted-line responsibility. Explain those distinctions with labels or notes, or choose a diagramming tool that better supports them.

Keep the chart accurate when staff change

For a static chart, edit the relevant entry in the Text Pane or select its box and change the text. To add a new hire, add a shape at the appropriate level and confirm that it is connected to the correct manager. When someone changes teams, move their entry to the right level and inspect the chart afterward. A tidy-looking diagram can still be wrong if a person is indented beneath the wrong manager.

If names and managers are maintained in another system or worksheet, decide which source is authoritative before editing the chart. SmartArt does not automatically synchronize with a regular employee table. If you paste a revised list into the Text Pane, check the resulting indentation and every reporting line; pasted text may not preserve the hierarchy the way you expect. For frequent updates or hundreds of employees, consider a system or tool with data-driven diagramming rather than treating a manually maintained SmartArt graphic as a live directory.

Also consider what information belongs in a shared file. An org chart normally needs work names and roles, not private personnel details. Limit access to the workbook appropriately and avoid adding sensitive information that readers do not need. If the chart is shared outside the organization, verify that the names, roles, and reporting lines are approved for that audience.

SmartArt versus drawing boxes by hand

Manual shapes are an alternative when you need unusual layouts or visual elements that SmartArt cannot arrange the way you want. Choose Insert > Shapes, add rectangles for people, and use connector shapes from the Lines section to show relationships. You can then format, copy, and align those objects. This gives more freedom, but each shape and connector needs attention as the chart changes. A moved box can leave a connector awkwardly placed if it was not attached or adjusted correctly.

SmartArt is generally the faster choice for a conventional hierarchy that may need occasional edits. Manual drawing can be worth the extra work for a highly customized one-off graphic, but it is not automatically better for a large chart. In either case, keep a source list of names and managers if accuracy matters. The diagram is a visual aid; it is not a substitute for the organization’s authoritative staff records.

Excel on Mac and Excel for the web

The main SmartArt workflow is similar in Excel for Microsoft 365 on Mac: use the Insert tab to insert SmartArt, choose a hierarchy graphic, and edit its text and layout. Ribbon labels and the placement of contextual controls can differ slightly by platform and update. Mac keyboard shortcuts also differ for many commands; for example, use Command rather than Ctrl for common save and copy shortcuts. The Tab and Shift+Tab hierarchy editing behavior applies when the Text Pane has focus.

Excel for the web may offer a different set of editing controls from the desktop app, and available capabilities can change. If you cannot find a SmartArt option or need detailed layout and formatting controls, open the workbook in desktop Excel. Check the finished chart in the version people will use, especially if collaborators work across desktop and browser versions.

Frequently Asked Questions

Can Excel make an org chart automatically from a list of employees?
Not with SmartArt alone. You can use the Text Pane to enter a hierarchy, but you must represent the manager-to-report relationships. For a chart that should refresh automatically from structured employee data, use a suitable data-driven diagramming tool or workflow.

How do I add another person to an org chart in Excel?
Select the relevant box and choose SmartArt Design > Add Shape, then select the position that fits the reporting structure. You can also add an entry in the Text Pane and use Tab or Shift+Tab to set its level.

How do I move someone to a different manager?
In the Text Pane, move the person’s entry under the correct manager and set its indentation to the appropriate level. You can also select the box and use Promote or Demote where appropriate. Check the resulting connector and hierarchy before sharing the chart.

Can I print an Excel org chart on one page?
Often, but the result depends on the chart’s size and the paper format. Check File > Print and adjust orientation or scaling. If fitting everything on one page makes the text too small, use multiple pages or reduce the amount of detail instead.

What is the fastest way to make a very large org chart?
SmartArt is convenient for a manageable hierarchy, but a large or frequently changing organization can be cumbersome to enter and maintain manually. Use an approved data-driven diagramming option if the chart needs to be regenerated from authoritative employee records.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.