Can You Build an Org Chart in Excel? Steps & Options

Charts & pivot tables · Updated November 19, 2026

Yes, you can build an organizational chart in Excel using SmartArt or by arranging shapes and connector lines. For a quick chart, choose Insert > SmartArt > Hierarchy, then enter names and roles; for more control over layout or appearance, create it manually with shapes.

What an Excel org chart can show

An organizational chart, or org chart, is a visual map of roles and reporting relationships. A basic chart might show a chief executive at the top, department heads beneath that person, and team members in lower levels. It can also include job titles, departments, locations, or other brief details if the layout has room.

Excel is useful when the chart is part of a workbook, when you want to customize its appearance, or when the organization is small enough to fit on a worksheet or printed page. It does not require a special org-chart file type: the chart is a graphic in the workbook. SmartArt provides a structured starting point, while ordinary shapes give you more freedom to position boxes and connectors.

One important distinction: a hierarchy graphic is not a regular Excel data chart like a column or line chart. SmartArt does not automatically read a list of employees and keep the reporting diagram synchronized with it. If your staff changes often, plan how you will update both the underlying information and the visual chart.

Build one with SmartArt

In Excel for Microsoft 365 on Windows, click the worksheet where the graphic should go, then select Insert > SmartArt. In the Choose a SmartArt Graphic window, select Hierarchy, pick a layout, and click OK. The SmartArt Design and Format tabs appear when the graphic is selected. Their availability and some controls can vary by platform; Excel for the web may not provide every desktop editing option, so use the desktop app if a command is missing.

To enter the organization, click the arrow at the left edge of the SmartArt graphic to open its Text Pane, then type or paste the labels. Each line represents a shape. Press Enter to add a line; use Tab to indent a line and make it a subordinate in the hierarchy, or Shift+Tab to move it up a level. For example, a chief executive can be the first line, with three department heads indented once and each manager indented beneath the relevant department head.

You can also select a shape and use SmartArt Design > Add Shape to add a colleague or reporting position. The menu offers placement choices such as adding a shape after, before, above, or below the selected one; the available choices depend on the layout. Use Add Assistant for an assistant position where that option is available. To change a person’s place in the hierarchy, select the line in the Text Pane and adjust its indent, rather than trying to drag the box and hoping the reporting structure changes with it.

  • Start with the highest role at the top of the text outline.
  • Use consistent indentation to show who reports to whom.
  • Keep labels concise, such as a name on one line and a job title on the next.
  • Review the finished layout for missing roles and incorrect reporting lines.

Choose a layout that fits the structure

SmartArt offers several hierarchy layouts, but not every layout suits every organization. A conventional organization chart is usually easiest to read when it has one clear top role and successive levels beneath it. A horizontal hierarchy can make sense when there are only a few levels but many direct reports. A compact layout can save space, though it may be harder to follow when the chart contains many names.

Choose based on the relationships you need to communicate, not simply on which design looks most decorative. If a department has many employees, consider whether showing every individual is useful. A leadership chart can show executives and department leads, while a separate team chart can cover individual contributors. Splitting a large structure into focused charts often makes reporting lines clearer than shrinking every box until the text is difficult to read.

SmartArt’s layout choices also affect how it arranges shapes when you add or remove entries. Try a layout with a small sample before entering a large hierarchy. You can change the layout later by selecting the graphic and choosing another option on SmartArt Design, but check the result: changing layouts may rearrange boxes and alter how much information fits.

Make a chart manually with shapes

Manual construction is useful when you need nonstandard groupings, want to position boxes precisely, or have a design that SmartArt cannot represent cleanly. On the Windows desktop, use Insert > Shapes to draw rectangles or other suitable boxes, then type a name and role in each shape. Add lines or connectors from Insert > Shapes to show reporting relationships. A connector is preferable to a plain line when available because it can remain attached to shapes as you move them.

Build one sample box first and decide on its size, font, border, and fill. Copy and paste it to create matching boxes, then replace the text and arrange the copies by level. Use the alignment and distribution commands on the Shape Format tab to make spacing more consistent. Select related shapes and use Group on the Shape Format tab when you want to move a section as a unit. The exact contextual controls can depend on what is selected.

This approach gives you visual flexibility, but it also creates more maintenance work. Moving a manager may require repositioning several boxes and reconnecting lines. For a small chart that will be presented once, that trade-off may be acceptable. For a changing hierarchy, SmartArt is often easier to revise; for a large or frequently updated chart, a dedicated organizational-chart tool may be a better fit.

Keep the chart and employee information consistent

A reliable update process matters more than the initial design if roles change regularly. Keep a separate worksheet table with one row per person and columns such as employee name, job title, department, and manager. Treat that table as the information record, and the SmartArt or shape diagram as the visual summary. Excel will not automatically rebuild a SmartArt hierarchy just because you edit a row in the table, so establish a review step to compare the chart with the current records.

For instance, if a manager transfers from Sales to Operations, update the manager field in the source list and then change the person’s position in the chart. Check both the manager’s new direct reports and the old team for accuracy. A chart that looks polished but shows outdated reporting lines can be more confusing than no chart at all.

For a small team, a manual comparison may be enough. For a larger organization, use a repeatable process: assign someone to maintain the source list, record the date of the last review, and confirm changes with the appropriate department owners. If you share the workbook, communicate which sheet contains the current chart and whether names or titles are intended to be public within the organization.

Format, print, and share the result

Make readability the priority. Use a font size that remains legible at the intended viewing size, use a restrained color scheme, and apply colors consistently if they represent departments or levels. Do not rely on color alone to explain reporting relationships; connector lines, position, and text should make the structure understandable in a grayscale printout too. Long job titles may wrap or make boxes uneven, so shorten labels carefully or enlarge the shapes.

Before printing, check the page layout and print preview. A wide chart may fit better in landscape orientation, and scaling a large graphic to one page can make the text too small. Consider placing different departments on separate worksheets or pages rather than forcing a sprawling chart onto a single sheet. Set the print area if you want to exclude unused cells, and inspect the preview to catch clipped boxes or connectors.

When sharing electronically, save the workbook in the standard Excel format if recipients need to edit it. If they only need to view the chart, exporting or printing the relevant sheet to PDF can preserve the layout more consistently. Review the exported version, since page scaling and font substitution can affect appearance. If the workbook contains other private information, check which sheets and data are included before sending it.

Limitations and alternatives

Excel works well for straightforward diagrams, but it is not a dedicated workforce-planning or diagram-management system. SmartArt offers convenient hierarchy layouts, not an automatic employee-directory connection. Manual shapes offer precision, but maintaining many connectors and boxes can become tedious. Very large organizations may also produce a chart that is difficult to read on a worksheet, even if the diagram technically fits.

Consider another option if your main need is automatic updates from a staff directory, detailed collaboration, or large diagrams that need to be navigated and maintained by multiple people. Microsoft Visio is designed for diagramming and has organizational-chart capabilities; access and available features depend on the Visio plan or license. Other organization-chart applications may connect to particular directory or HR systems, but check their data-import, privacy, and licensing terms before adopting one.

Excel can still be a practical choice when the source information already lives in a workbook, the chart is modest in size, and someone can own the update process. It may also serve as a first draft: sketch the reporting structure in Excel, confirm it with managers, and move to a purpose-built tool if the diagram becomes too large or changes too frequently.

Common problems and fixes

  • The chart becomes crowded: reduce unnecessary details, split the organization into department-level charts, or choose a layout with more horizontal space. Avoid shrinking text until it is unreadable.
  • A new box appears at the wrong level: inspect the indentation in the SmartArt Text Pane. Indentation determines hierarchy; visual position alone is not the best way to define the relationship.
  • Boxes move unexpectedly: SmartArt arranges shapes according to its layout. Try another hierarchy layout or switch to manually placed shapes if precise positioning is essential.
  • Lines do not follow boxes: when using manual shapes, use connectors rather than decorative lines where possible, and check connections after moving or resizing shapes.
  • Text is cut off in print: use print preview, adjust page orientation or scaling, and consider dividing the chart across pages instead of compressing it.

Frequently Asked Questions

Can Excel create an org chart automatically from a list of employees?
Not with SmartArt alone. SmartArt can make a hierarchy graphic, but it does not automatically convert an employee table into a chart that stays synchronized with the table. You can use the list as a reference while entering and maintaining the diagram, or investigate a dedicated tool if automatic data connections are essential.

Is SmartArt better than drawing shapes?
For a conventional hierarchy that needs straightforward edits, SmartArt is usually the simpler starting point. Shapes are more flexible for custom diagrams, but require more manual alignment and connector maintenance. The best option depends on the complexity of the structure and how often it changes.

Can I add a person who reports to two managers?
A standard hierarchy implies a parent-and-subordinate structure and may not clearly represent dual reporting. You can add a second connector manually, but the result may be ambiguous. Explain the dotted or secondary relationship with a legend, or use a diagramming tool better suited to matrix structures.

Can I edit the org chart in Excel for the web?
Some workbook editing is available in Excel for the web, but its SmartArt and shape controls may differ from the Windows desktop app. If you cannot find a needed layout or editing command, open the workbook in desktop Excel and verify the saved result before sharing.

Does an org chart need to include every employee?
No. Include the roles and reporting detail needed by the audience. A leadership overview can be clearer when it shows only senior roles and department leads, while a separate team chart provides individual-level detail.

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.