Excel SmartArt Org Chart: Create and Customize Charts

Charts & pivot tables · Updated November 19, 2026

To create 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. SmartArt is a quick way to draw a small or medium reporting structure, but it is a graphic you maintain manually—not a chart that automatically stays synchronized with an employee table.

What an Excel SmartArt org chart does

SmartArt is a set of editable diagrams built into Excel. Its Organization Chart layout arranges boxes to show who reports to whom: typically, a leader at the top, direct reports beneath that person, and further levels below. You can add names, job titles, and other brief details, then adjust the graphic’s appearance without drawing every box and connector yourself.

The chart represents relationships visually; it does not create a formal employee database or infer reporting lines from names, departments, or other worksheet values. The hierarchy is stored in the SmartArt graphic. If a person changes roles, you must update the diagram yourself. This distinction matters when choosing between a quick presentation graphic and a structure that needs to stay current as records change.

SmartArt works well for a department overview, a project team with a clear lead, or a compact management chart. It can also be useful for explaining a proposed structure. A large organization with many branches, frequent changes, or strict data-maintenance requirements may need a different approach.

Create the chart in Excel

In the desktop version of Excel for Microsoft 365 on Windows, start with a blank worksheet or open the workbook where the graphic belongs. Use the ribbon path Insert > SmartArt > Hierarchy > Organization Chart, then select OK if Excel displays a confirmation dialog. The graphic appears on the sheet, along with a Text pane for entering its contents. If the pane is hidden, select the small arrow on the graphic’s edge to show it.

  1. Enter the top position first, such as a director or team lead.
  2. Add direct reports underneath it, then add any further reporting levels.
  3. Use the Text pane’s indentation to show which people report to which manager.
  4. Close the Text pane when finished, and resize or move the graphic on the worksheet.

You can also use the graphic’s controls on the SmartArt Design tab to add shapes. Select a shape, choose SmartArt Design > Add Shape, and pick the available position that fits the relationship you want to represent. Depending on the selected shape and layout, choices can include adding a shape after or before the selection, above it, below it, or adding an assistant. Check the resulting hierarchy: the wording in these choices describes placement relative to the selected shape, not necessarily a person’s job title.

On Mac, the SmartArt feature is available in desktop Excel, although ribbon placement and dialog appearance can differ. Excel for the web may not expose the same creation and formatting controls as desktop Excel. If you cannot find a layout or editing command in the browser, open the workbook in the desktop app rather than assuming the graphic is unavailable.

Enter names and build reporting levels

The Text pane is often the easiest way to establish a hierarchy before polishing its appearance. In a new chart, type the first position, press Enter to create another entry at the same level, and use Tab to indent an entry beneath the preceding level. Use Shift+Tab to outdent an entry and move it up a level. These keys affect the selected line in the Text pane; they do not add a literal tab character to a person’s name.

For example, a simple outline might place Maya Chen at the top, followed by two direct reports, Luis Ortiz and Priya Shah. If Priya manages two analysts, indent their names one level beneath Priya. The resulting chart shows Maya above Luis and Priya, with the analysts below Priya. An indent represents a reporting relationship, so do not indent people merely to make the list look tidy.

For an existing chart, select the relevant shape before adding a subordinate or peer. You can also edit names directly in a shape, but the Text pane makes it easier to inspect the whole hierarchy and spot entries at the wrong level. Keep labels concise: put a person’s name on one line and a title on a second line when the layout supports it, rather than adding long descriptions that force every box to grow.

Format the layout and appearance

When you select a SmartArt graphic, Excel shows contextual tabs such as SmartArt Design and Format. SmartArt Design contains controls for changing the layout, applying colors, and choosing SmartArt styles. For example, use SmartArt Design > Change Colors to select a coordinated color scheme. The exact style choices depend on the selected layout and Office version.

Use the Format tab for more specific adjustments to selected shapes, such as their fill, outline, or text appearance. A restrained palette usually works better than assigning a different bright color to every employee. If color communicates a useful distinction—such as separate divisions—include another cue, such as a division label, so the meaning is not carried by color alone.

To change the overall arrangement, select a different option in the SmartArt Design layout gallery. Some layouts can display assistant roles or organize levels differently, but switching layouts can change spacing and shape placement. Review the reporting lines after a switch; a visually attractive layout should not make the hierarchy ambiguous. You can resize the graphic by dragging its corner handles, but enlarging it does not necessarily solve a crowded structure if the chart contains too many levels or long labels.

Keep a chart readable and useful

A chart that fits on a screen may be too small to read when printed or pasted into a presentation. Before finishing, consider who will use it and where it will appear. A staff directory may need names and titles, while an executive overview may be clearer with only roles and department leads. Avoid placing phone numbers, email addresses, or lengthy responsibilities in every box unless those details are essential to the chart’s purpose.

  • Use consistent naming and job-title conventions across boxes.
  • Keep levels and branches visually easy to follow; avoid unnecessary labels or decoration.
  • Check that the chart remains legible at the intended zoom level and printed size.
  • Provide a meaningful title or nearby explanation if readers may not know the team or date covered.
  • Consider accessibility: do not rely on color alone, and provide a concise description of the graphic where the workbook’s accessibility tools allow it.

SmartArt is a visual object placed on a worksheet, not a cell-based table. Leave enough worksheet space around it, and check whether it overlaps data, labels, or other objects. If people need to sort or filter the employee information, keep that information in a regular table as well; a diagram is not a substitute for structured records.

Common problems and practical fixes

A person appears at the wrong level. Select that entry in the Text pane and use Tab or Shift+Tab to adjust its indentation. Then confirm that the displayed connector matches the intended manager. Moving a shape visually is not the same as changing the reporting structure.

The chart is crowded or text is clipped. Shorten labels, enlarge the graphic, or try another hierarchy layout. If a department has many employees who do not need to appear individually in the overview, show the department lead and summarize the team rather than shrinking every box until the text is unreadable. A second chart or a separate roster can be clearer than one oversized diagram.

New entries do not appear where expected. The position of a new shape depends on the selected shape and the Add Shape option. Undo the change if necessary, select the intended manager or peer, and add the shape again. Inspect the Text pane to verify the underlying indentation.

The chart does not update when worksheet data changes. That is expected: editing a table does not automatically update the text or hierarchy in a standard SmartArt org chart. Treat the diagram as a separate item to maintain, or choose a tool designed around a data source if automated updates are important.

SmartArt compared with other ways to make an org chart

SmartArt is a practical choice when you want a built-in diagram that is quick to insert and easy to restyle. It is generally more convenient than drawing each box and connector with individual shapes, especially for a straightforward hierarchy. However, its convenience does not make it data-linked, and extensive custom positioning can become awkward when the organization changes frequently.

Manual shapes give you more control over the position and design of each box, but require more work to keep connectors and spacing consistent. A worksheet table is better for sorting, filtering, and maintaining employee details, but it does not automatically become a visual reporting chart. Dedicated diagramming software may suit a complex organization or a chart that must be maintained from structured data; check the product’s current features and licensing before choosing it.

A useful compromise is to keep authoritative employee information in a table and make a separate SmartArt summary for a presentation. Add a date or version note near the chart, and assign responsibility for updating it. That simple process helps prevent a polished graphic from being mistaken for a live directory.

Share, print, and maintain the graphic

SmartArt is stored in the workbook, so sharing the Excel file preserves the diagram as an editable graphic for people using a compatible version of Office. If recipients only need to view it, exporting or printing the relevant sheet can be convenient, but check the print preview first. Worksheet scaling, page orientation, margins, and print area can affect the graphic’s size and placement.

For a chart that spans a wide team, landscape orientation or a larger paper size may improve readability. In Excel for Windows, use Page Layout > Orientation to choose Portrait or Landscape, and inspect File > Print before printing. Avoid forcing a detailed chart onto one page if doing so makes the text too small. If you share a PDF or image instead of the workbook, remember that viewers generally cannot edit the SmartArt structure in that exported copy.

When the reporting structure changes, update the SmartArt and any accompanying employee table separately unless you have deliberately chosen a data-driven tool. Add a review date if the diagram is used operationally. This makes its status clear and gives readers a reason not to rely on an outdated copy saved or printed earlier.

Frequently Asked Questions

Can Excel make an org chart automatically from names in a table?
A standard SmartArt org chart does not automatically build or refresh its hierarchy from an employee table. You can create the chart and enter its structure in the Text pane, but changes to worksheet cells do not synchronize with the graphic.

How do I add a subordinate in an Excel SmartArt org chart?
Select the manager’s shape, then use SmartArt Design > Add Shape and choose an option that places a shape below it. You can also indent the new entry under the manager in the Text pane and verify the resulting reporting line.

How do I move someone up one level?
Select the person’s line in the Text pane and press Shift+Tab to outdent it. Check the chart afterward to make sure the person now reports to the intended manager.

Can I make an org chart in Excel for the web?
Available SmartArt commands can vary between Excel for the web and desktop Excel. If the browser version lacks a layout or editing option you need, open the workbook in desktop Excel for the fuller ribbon controls.

Is Excel SmartArt suitable for a large organization?
It can depict a large structure, but one diagram may become difficult to read and maintain. For extensive or frequently changing reporting lines, consider separate department charts or a diagramming tool with a suitable data workflow.

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.