How to Create an Org Chart in Excel: Steps and Tips

Charts & pivot tables · Updated November 19, 2026

To create an org chart in Excel for Microsoft 365 on Windows, select Insert > SmartArt > Hierarchy > Organization Chart, then enter names and job titles in the Text pane. Use Tab to make an entry a subordinate and Shift+Tab to move it up a level; format the chart with the SmartArt Design tools.

What an Excel org chart can show

An organizational chart is a visual map of roles and reporting relationships. A simple example might show a director at the top, department managers beneath that person, and team members below each manager. The lines and box positions communicate the hierarchy more quickly than a list of names alone.

Excel’s built-in SmartArt organization chart is a practical choice for a small or moderately sized structure that needs to sit alongside other spreadsheet information. It is a graphic, not a special data table: the names and reporting lines you enter in SmartArt are not automatically connected to rows in an employee worksheet. That distinction matters if you expect the chart to update whenever a source list changes.

Before building one, decide what the chart is meant to communicate. It could show formal reporting lines, project responsibilities, or a simplified team structure. These are not always the same thing. If a person reports to one manager but coordinates work with several others, a conventional hierarchy may not represent every relationship clearly. Keep the chart focused on its purpose rather than trying to turn it into a complete directory.

Create a basic chart with SmartArt

In Excel for Microsoft 365 on Windows, start with a blank worksheet or open the workbook where the chart belongs. Choose Insert > SmartArt, select Hierarchy in the gallery, choose Organization Chart, and select OK. Excel inserts a sample graphic and displays the SmartArt Design and Format tabs when the graphic is selected.

Click the small arrow on the left edge of the graphic to open the Text pane if it is not already visible. Each bullet in the pane represents a box in the chart. Replace the sample labels with a person’s name and, if useful, a job title. You can put the name and title on separate lines within a box by pressing Shift+Enter while editing the text.

Build the reporting structure in the Text pane:

  • Press Enter to add another entry at the same level as the current entry.
  • Press Tab to indent an entry and make it report to the entry above it.
  • Press Shift+Tab to reduce the indent and move an entry to a higher level.

For example, enter “Maya Chen” as the first item, press Enter for “Jordan Lee,” and press Tab before entering “Ravi Patel” if Ravi reports to Jordan. The indentation in the pane represents hierarchy; it is not merely a way to style the text. Review the resulting boxes as you go so that a mistaken indent does not imply the wrong manager.

Add, remove, and rearrange roles

You can also edit the chart directly. Select a box, then use SmartArt Design > Add Shape to choose an available placement, such as adding a shape below, before, or after the selected shape. Depending on the selected box and chart, the menu also offers an assistant placement. An assistant is a distinct role connected to a manager; it is not simply another direct report on the same branch.

To change a person’s level, select the corresponding entry in the Text pane and use Tab or Shift+Tab. The SmartArt Design tab also includes Promote and Demote commands for changing hierarchy. To remove a box, select it and press Delete. Check the surrounding branches afterward: removing a manager who has subordinates can affect how those entries are displayed, so confirm that the remaining reporting relationships still make sense.

Moving a box by dragging can be less predictable than changing the hierarchy in the Text pane, because SmartArt arranges boxes according to its layout. For a substantial reorganization, update the outline first and let SmartArt reposition the shapes. This helps preserve consistent connectors and spacing. If you need a non-hierarchical relationship, consider adding a note or using a different visual rather than forcing it into the reporting tree.

Format the chart for readability

Select the SmartArt graphic to use the SmartArt Design tab. The Change Colors menu and SmartArt Styles can apply coordinated appearances to the entire chart. The Change Layout menu offers hierarchy arrangements; trying another layout can make a wide structure easier to read without changing the underlying reporting relationships.

For more specific changes, select an individual box and use the Format tab to adjust its fill, outline, or text styling. Use emphasis sparingly. For instance, a different fill for department heads can help readers scan the chart, but using a unique color for every person makes the structure harder to interpret. Keep text large enough to read at the size at which people will view or print the workbook.

Names alone may not identify people in a large organization. Adding job titles or department names can help, but long labels make boxes expand and the overall chart wider. A useful compromise is a name on the first line and a concise role on the second. If the chart becomes too dense, split it into department-level charts or show only key roles rather than shrinking every box until the text is unreadable.

Work with employee data in a worksheet

A common question is whether an org chart can be generated automatically from a table containing employee names and manager names. SmartArt’s organization chart is not a live, data-linked view of such a table: changing a source row does not automatically rebuild its boxes or connectors. You can use a worksheet list as a reference while entering or revising the SmartArt outline, but plan to maintain the graphic itself.

For a larger organization, first clean and verify the source list. A practical table might contain columns for employee ID, name, job title, department, and manager ID. Stable IDs are more reliable than names alone when two employees share a name or a person changes roles. Check that every manager reference points to a valid person, and decide how to handle the top role, vacant positions, contractors, and people with multiple reporting relationships.

Do not assume that sorting the source table will create the right hierarchy. A list sorted alphabetically can be useful for checking names, but reporting order must be represented explicitly. If the chart must be refreshed frequently from structured data, investigate a dedicated organization-chart or diagramming tool and confirm that its data import and update features fit your Excel version and licensing. A manually maintained SmartArt chart may be fine for a stable team, but it is a weak choice as a continuously synchronized employee directory.

Use shapes for a custom layout

SmartArt is usually the quickest option, but individual Excel shapes can be better when the diagram needs a custom arrangement, extra annotations, or a layout that does not fit a standard hierarchy. Choose Insert > Shapes, add rectangles for roles, and enter text in each shape. Then add connector lines from the Shapes gallery to show reporting links. Use connector shapes rather than ordinary lines when possible; connectors are designed to attach to shapes and can remain attached as boxes move.

Manual diagrams offer control over each box, but they also require more upkeep. You must position shapes, keep spacing consistent, and check every connection after moving or deleting a role. For a clean result, create one box, format it, and duplicate it for similar roles. Use alignment and distribution commands on the Shape Format tab where available, and group related shapes when the layout is finished so they are easier to move together.

A hybrid approach is possible: use SmartArt for a standard hierarchy, then add worksheet notes or labels outside the graphic. Avoid covering SmartArt connectors with separate lines or layering unrelated shapes over the chart; edits and resizing can make those additions drift out of place.

Common problems and practical fixes

  • A name appears at the wrong level: Open the Text pane and correct its indentation with Tab or Shift+Tab. Check the entries around it, since a wrong indent can affect how the branch is understood.
  • Text is clipped or boxes look cramped: Shorten labels, use a concise title, widen the chart, or choose another hierarchy layout. Avoid reducing font size before considering whether the chart has too much detail.
  • The chart is too wide for a printed page: Try landscape orientation through Page Layout > Orientation > Landscape. Use print preview to see the result; fitting a large chart to one page can make its text too small to read.
  • Connectors or spacing look uneven: Select the SmartArt and try another layout from SmartArt Design > Change Layout. For a shape-based chart, check that connectors are attached to the intended boxes.
  • Changes to the employee table do not appear: This is expected for SmartArt because it is not automatically linked to that table. Update the graphic manually or use a tool designed for data-driven diagrams.

It is also easy to confuse a visually attractive chart with an accurate one. Ask someone who understands the reporting structure to review the names, titles, and lines before sharing it. This is especially useful after a reorganization, when a box can look correctly placed even though its connector still represents an outdated relationship.

Save, share, and print the chart

Keep the chart in the workbook if readers need its surrounding data or if the organization changes regularly. If it is intended for a presentation or a document, copying the graphic into the destination can be convenient, but check whether it should remain editable or be pasted as a picture. A picture preserves appearance but is not convenient for later structural edits.

For printing, use print preview and check both legibility and page breaks. A very wide hierarchy may be better printed across multiple pages or exported for viewing at a larger size than compressed onto one sheet. In Excel, the Page Layout tab includes orientation and scaling controls; use them carefully because scaling affects the whole printed selection or sheet, not just the text inside the chart.

When sharing a workbook, consider who is allowed to see employee information. Include only the names and details needed for the chart’s purpose, and follow your organization’s rules for handling internal personnel data. If readers use screen readers, provide a clear title and explanatory text in the worksheet; the graphic alone may not communicate its structure as efficiently as a well-organized text outline.

When another tool may be a better fit

Excel is convenient when the chart is small, familiar to its audience, and needed in a workbook. SmartArt avoids manually drawing every box and works well for a straightforward chain of command. Excel becomes less comfortable when the organization is large, changes often, includes complex cross-functional reporting, or requires automated synchronization with a personnel system.

For a presentation, PowerPoint can be a more natural home for a polished static diagram. For a large diagram that needs specialized layout or data connection features, compare diagramming software such as Microsoft Visio with the requirements and licenses available to your organization. These alternatives are not automatically better: weigh update frequency, number of roles, collaboration needs, accessibility, and the expected output. If the chart is small and changes rarely, a clear SmartArt graphic may be simpler to maintain than adopting another tool.

Frequently Asked Questions

Can Excel make an org chart from a list of names?
Excel can display an organization chart with SmartArt, but SmartArt does not automatically infer manager relationships from a plain list. Enter the hierarchy in its Text pane, or use a separate tool if you need a chart generated and refreshed from structured employee data.

How do I add a subordinate in an Excel org chart?
Select the manager’s box and choose SmartArt Design > Add Shape > Add Shape Below, or add an item in the Text pane and indent it with Tab. Confirm that the new box appears under the intended manager.

Can I put a job title under a person’s name?
Yes. Edit the box text and put the name and title on separate lines, using Shift+Enter while editing the text. Keep titles concise so the boxes do not become too wide.

Why does my org chart not update when I edit the employee table?
The SmartArt graphic and worksheet table are separate objects. Editing a row does not update SmartArt automatically, so revise the chart too or choose a data-driven diagramming workflow.

Can I create an org chart in Excel for Mac?
Excel for Mac also has SmartArt hierarchy graphics. The ribbon layout can differ from Windows, but look under Insert > SmartArt and choose a hierarchy organization-chart layout. Some commands and screen details vary by Excel release.

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.