Excel SmartArt Org Charts: Create, Edit, and Fix Them

Charts & pivot tables · Updated November 19, 2026

To make an org chart in Excel for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy > Organization Chart, then enter names and roles in the Text pane. Use the SmartArt Design tab to add, remove, rearrange, and format reporting relationships; SmartArt is a visual diagram, not a chart that automatically reads employee data from worksheet cells.

What an Excel SmartArt org chart does

SmartArt is Excel’s built-in collection of editable diagrams. Its Organization Chart layout is designed to show a hierarchy: a leader at the top, managers or teams below, and further reporting levels beneath them. Each person is represented by a shape, and the connectors make the relationship between positions visible.

This can be useful for a small department, a project team, a classroom, or a simple company structure. For example, a chart might show a department director, three managers reporting to that director, and the staff members assigned to each manager. You can include a person’s name, job title, or both in a shape, and you can use different layouts to make the levels easier to read.

The key limitation is that the diagram is maintained separately from worksheet data. Typing names into cells does not populate SmartArt, and changing a name in the diagram does not update a staff list elsewhere in the workbook. If the chart must stay synchronized with a changing roster, consider a data-driven charting tool or another organizational-chart application.

Create the chart and enter its first positions

In a blank worksheet, select Insert > SmartArt. In the SmartArt gallery, choose Hierarchy, select Organization Chart, and click OK. Excel inserts a starter diagram and displays the SmartArt Design and Format contextual tabs when the graphic is selected. The Text pane may open beside the diagram; if it does not, use the small arrow on the left edge of the SmartArt graphic to show it.

Enter the top position first, then add the other positions in an outline. In the Text pane, press Enter to create another item at the current outline level. Press Tab to indent an item under the preceding position, or Shift+Tab to promote it to a higher level. Think of indentation as defining the reporting structure, not just adjusting how the text looks.

For a simple structure, the outline might look like this:

  • Director
  • Manager A
  • Analyst 1
  • Analyst 2
  • Manager B
  • Coordinator

Indent Analyst 1 and Analyst 2 beneath Manager A, and indent Coordinator beneath Manager B. The outline’s hierarchy determines which positions report to which managers. Before entering a large roster, sketch the levels or prepare the outline in a worksheet so you can check the structure and spelling first.

Add, move, or remove people

You can build the hierarchy from the Text pane or by selecting a shape and using SmartArt Design > Add Shape. The menu offers placement choices such as adding a shape after or before the selected one, above it, or below it. In an organization chart, Add Assistant is also available for an assistant position connected to a selected role. The exact placement matters: a person added above a shape is not the same as a subordinate added below it.

To change a person’s position without retyping the whole chart, select the shape and use the Add Shape options, or change the item’s indentation in the Text pane. To delete a position, select its shape and press Delete, or remove the corresponding item from the pane. Check the result after deleting: removing a manager who has people below them can affect the visual structure of those subordinate items.

For large charts, make changes in small batches and verify each branch before continuing. A useful check is to trace every connector from the top position downward and confirm that each person appears under the intended manager. This is especially important when several managers have similar titles or when the outline contains many levels.

Choose a layout that fits the reporting structure

With the SmartArt selected, open SmartArt Design > Layouts to browse available arrangements. Organization Chart is the standard top-down view. Other hierarchy layouts may arrange the same outline differently, but not every hierarchy design communicates conventional reporting lines as clearly. Use the layout that makes the relationships easiest to follow, rather than choosing one only because it looks decorative.

SmartArt Design also includes an option to change the layout of selected branches, where supported by the chosen hierarchy graphic. For example, an organization chart can place subordinates in a hanging arrangement rather than directly beneath a manager. Layout choices can help when a manager has several direct reports, but they do not change the underlying reporting relationship in the outline. Review the connectors after switching layouts to ensure the diagram still says what you intend.

There is no single best layout for every organization. A broad structure with many direct reports may need more horizontal room; a tall structure with several management levels may need more vertical room. If the diagram becomes too wide or too tall to read at a useful size, splitting it into department-level charts is often clearer than shrinking every shape.

Format names, roles, colors, and shapes

Select the SmartArt to use SmartArt Design > Change Colors or choose a style from the SmartArt Styles gallery. These controls apply coordinated visual treatments to the diagram. To format one position differently, select its shape and use the contextual Format tab, or use the text formatting controls on the Home tab. A restrained palette and consistent text styling usually make a business chart easier to scan than many unrelated colors.

Decide what information each box should contain. A common pattern is a name on the first line and a job title on the second. If employee IDs, locations, phone numbers, or vacancy notes are essential, consider whether the chart will remain legible at its intended size. Long titles wrap, increase box height, and can push branches farther apart. Short, consistent labels are easier to maintain and read.

SmartArt offers text and shape formatting, but visual emphasis should not contradict the hierarchy. For example, using a bright color for one team can help distinguish a department, while using the same color to imply seniority may confuse readers if the positions do not share that status. Keep the meaning of colors clear, and do not rely on color alone to communicate an important distinction.

Common problems and practical fixes

  • A person appears at the wrong level: Open the Text pane and correct the item’s indentation with Tab or Shift+Tab. Then inspect the connector in the diagram.
  • The chart is crowded: Shorten labels, use a larger worksheet area, switch to a suitable layout, or divide the organization into smaller charts. Avoid reducing text until it becomes difficult to read.
  • A shape will not fit its text: Select the shape and adjust its size or text formatting on the Format or Home tab. Check whether a long title is forcing extra line breaks.
  • Connectors or spacing look uneven: Try a different hierarchy layout and review the branch structure. Do not drag boxes randomly before confirming the outline; manual positioning can make later edits harder to manage.
  • The diagram does not update when worksheet names change: That is expected. SmartArt does not maintain a live link to a cell range, so update its text separately or use a different approach for frequently changing data.

One common misconception is that an org chart is an Excel chart in the same sense as a column or line chart. SmartArt is a diagram made of shapes and connectors. That makes it straightforward to customize visually, but it does not provide the automatic category-and-series behavior of a chart based on worksheet values.

SmartArt compared with shapes and other options

SmartArt is usually the quickest choice when the hierarchy is modest and you want a diagram that can be edited directly in Excel. It keeps the outline and visual arrangement together, and its built-in layouts make it easier to restyle a whole chart than drawing every connector from scratch.

Drawing the chart with individual shapes can give you more control over unusual structures, such as dotted-line relationships, matrix reporting, or a layout that does not fit a standard hierarchy. The trade-off is the manual work: you must position shapes and connectors yourself, and changes to the structure can require repeated adjustments. Shapes may be more suitable for a small, highly customized diagram than for a large roster that changes often.

For an organization chart that must be generated or refreshed from structured employee records, consider Microsoft Visio or a dedicated organizational-chart tool. Check the product’s current features, licensing, and compatibility before choosing it; availability and included functionality can depend on the Microsoft 365 plan or separate purchase. Excel remains useful for preparing and reviewing the underlying roster even when another application is better for the diagram.

Print, share, and maintain the chart

Before printing, select the worksheet area you need and review File > Print. Use the print preview to check whether the chart fits on the page and whether the text is readable. Page orientation, margins, scaling, and paper size can affect the result. Scaling an oversized chart to one page may make the labels too small, so consider landscape orientation, a larger paper size, or separate department pages.

When sharing the workbook, remember that SmartArt is part of the worksheet, not a separate live org-chart service. Recipients can edit it in compatible desktop versions of Excel, but the appearance can be affected by differences in fonts, window size, or print settings. If readers only need a fixed view, save or export a copy as PDF after checking the layout. Keep an editable workbook as the source if the chart will need future changes.

For ongoing maintenance, keep a trusted roster or source document and decide who is responsible for updating both it and the SmartArt. Record an “as of” date near the chart if staffing changes frequently. A periodic review can catch people who have moved teams, vacant roles, or outdated titles before the workbook is circulated.

Frequently Asked Questions

Can Excel make an org chart automatically from names in cells?
No. SmartArt’s Organization Chart layout does not automatically build or synchronize itself from a worksheet list. You can enter names in the Text pane or shapes, but updates to a separate roster must be reflected in the diagram manually unless you use another tool or a custom process.

How do I add a subordinate in an Excel SmartArt org chart?
Select the manager’s shape, then choose SmartArt Design > Add Shape > Add Shape Below. You can also add an item in the Text pane and indent it beneath the manager. Check the connector to confirm the new position reports to the correct person.

Can I put an assistant beside a manager?
Yes. Select the relevant position and use SmartArt Design > Add Shape > Add Assistant, when that option is available for the selected organization-chart layout. Excel positions an assistant relationship differently from an ordinary subordinate relationship.

Is SmartArt available in Excel for Mac?
SmartArt is available in desktop Excel for Mac, although the ribbon appearance and some interface details can differ from Excel for Windows. Look for SmartArt on the Insert tab, then use the contextual SmartArt Design controls after selecting the diagram. Excel for the web may also differ in which editing controls are available.

What should I use for a very large or frequently changing org chart?
For a large structure, divide the chart into clear departments or use a tool designed to generate organization charts from structured employee data. SmartArt can work for a smaller, stable hierarchy, but manually maintaining many boxes becomes error-prone when reporting lines change often.

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.