Creating an Org Chart in Excel: Steps and Options Explained

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 each person and role in the SmartArt Text pane. Add and arrange reporting levels with the SmartArt Design tab; for a small chart that needs custom positioning, you can instead build it from shapes and connector lines.

What an Excel org chart can show

An organizational chart is a visual map of roles and reporting relationships. A typical chart starts with a leader at the top, places direct reports below, and shows their teams at the next level. It can help staff understand who reports to whom, introduce a department, or make a proposed team structure easier to discuss.

Excel can create the diagram with SmartArt or individual shapes, but it is not a dedicated organization-chart database. The chart is a visual object in a workbook, and it does not automatically stay synchronized with a separate employee list. That distinction matters if people, titles, or reporting lines change frequently: you need a process to update both the information and the diagram.

Before building, decide whether the chart should show people, positions, or both. A chart of positions can remain useful during vacancies, while a people-focused chart may include names and job titles. Also decide how much detail belongs on the page. Phone numbers, work locations, and other directory details may be better kept in a separate staff list.

Prepare the reporting information first

Write down the structure before formatting boxes. A simple table can help you check spelling, titles, and manager relationships. For example, a small department might have Maya Chen as department director, reporting to whom are Omar Patel and Nina Brooks; Omar manages Lee Kim and Ava Ruiz, while Nina manages Sam Reed. This hierarchy is easier to enter once it is clear than to reconstruct while dragging diagram elements around.

  • Use one consistent name and title format, such as a name on the first line and role on the second.
  • Confirm who reports directly to each manager. A project lead or mentor is not necessarily a formal manager.
  • Decide how to show vacancies, contractors, shared roles, and people who report to more than one person.
  • Choose a page size and orientation based on the number of levels and teams you need to show.

Excel does not infer the hierarchy from a list of names and managers when you insert an organization chart. SmartArt starts with a diagram structure; you supply the content and arrange its levels. Checking the reporting relationships beforehand reduces the chance of a polished chart that communicates the wrong structure.

Build the first version with SmartArt

SmartArt is generally the quickest option for a conventional hierarchy. In Excel for Microsoft 365 on Windows, follow these steps:

  1. Open the worksheet where the chart should sit and select Insert > SmartArt.
  2. In the SmartArt chooser, select Hierarchy, choose Organization Chart, and select OK.
  3. Select the chart to show the SmartArt Design tab. Open the Text pane if it is not already visible; you can also select the small arrow on the left edge of the SmartArt graphic.
  4. Enter the top role first, then enter the other names and roles in the hierarchy. Use the Text pane’s indentation levels to show subordinate positions beneath their managers.
  5. Use SmartArt Design > Add Shape to insert a position in the appropriate relationship to the selected box. The menu includes options such as adding a shape below or adding an assistant.

The Text pane is often easier to manage than clicking boxes individually, especially when you need to inspect the hierarchy. Indent a line to make it subordinate to the line above; promote or demote entries when you need to change their level. Check the visual result after editing because an indentation mistake can put a person under the wrong manager.

SmartArt may reorganize boxes as you add or remove roles. That automatic layout is useful for keeping a basic diagram orderly, but it can also change spacing as the chart grows. If you need precise placement or unusual reporting lines, consider whether the extra control of manually drawn shapes is worth the additional maintenance.

Format and arrange the chart

Select the SmartArt graphic to use the SmartArt Design and Format tabs. SmartArt Design offers layout, color, and style choices; the available choices depend on the selected graphic. Apply a restrained style that keeps text readable rather than relying on decorative effects. A consistent color can distinguish departments or management levels, but use labels as well so the meaning does not depend on color alone.

For a wider structure, try a different organization-chart layout from SmartArt Design rather than shrinking text until it is difficult to read. You can also resize the graphic by dragging its handles. To keep the chart aligned with worksheet content, use the worksheet’s row and column grid as a visual guide, but remember that SmartArt is a floating object, not cell data.

To make the chart easier to read when printed, select Page Layout and check the page orientation, margins, and scaling. Use Print Preview before sharing. Excel’s scaling can reduce a wide diagram to fit one page, but that may make names too small; landscape orientation or a larger paper size may be more readable than forcing the entire chart onto a single sheet.

When to use shapes and connector lines

Individual shapes are useful when the structure is small, the layout is unusual, or you need control over each box. On the Windows desktop, use Insert > Shapes to add rectangles or other boxes, then enter text in them. Add lines from Insert > Shapes > Lines to show reporting relationships. Connector lines are preferable to ordinary freeform lines where available because they can remain attached to shapes as you move them.

Manual diagrams take more work. You must position boxes, keep spacing consistent, route connectors, and check that every line still ends at the intended box after edits. For a chart with many employees, those small tasks add up. A practical method is to build one row of boxes, copy it for peers, and use Excel’s alignment and distribution commands on the Shape Format tab to make the layout more consistent.

Shapes can also help when a person has a dotted-line relationship that a basic hierarchy does not express cleanly. Use a clear legend to distinguish solid and dotted reporting lines, and avoid implying that a secondary relationship is a direct manager relationship. If the diagram becomes crowded or requires many special cases, a dedicated diagramming or HR system may be a better fit.

Keep the source data and diagram in agreement

A useful workbook can contain both a staff table and a chart, but treat them as separate elements unless you have deliberately created an automation process. Changing a manager’s name in a table does not automatically rewrite a SmartArt box. After organizational changes, compare the diagram with the current approved reporting list and update both before distributing the file.

For a chart that changes regularly, keep a clean source table with columns such as Employee, Role, and Manager. Use stable, unique identifiers if names may be duplicated, and document who owns updates and when the chart was last reviewed. This makes errors easier to detect and gives readers a way to judge whether a copy is current. A date in the worksheet can help, but it should be updated as part of the review rather than assumed to refresh itself.

Excel formulas can help organize or check information in a table, but a formula-driven list is not itself a visual org chart. Avoid promising that sorting the table will preserve reporting relationships: sorting can reorder rows, while the manager links must still identify the correct people. Keep a backup or versioned copy before making substantial revisions to a shared chart.

Design, accessibility, and sharing considerations

Use readable text and concise labels. If a box cannot fit a name and role at a comfortable size, consider a larger page, splitting the organization into department charts, or linking to a detailed directory. Avoid adding sensitive personal information simply because there is room in a box. A chart shared outside a team can reveal internal roles and reporting lines, so check the intended audience and your organization’s sharing rules.

Provide context for readers who may not know the structure. A title, department name, date reviewed, and a short note explaining abbreviations can prevent confusion. If the chart uses color to identify teams, include team names in the boxes or a legend. Check the chart at normal screen size and in print preview; a diagram that looks clear when zoomed in may be hard to follow on a printed page.

For accessibility, use meaningful text in the boxes and do not communicate relationships through color alone. SmartArt and shapes are visual objects, so readers using assistive technology may not experience the layout as a person looking at the page does. Consider adding an accompanying structured list of managers and direct reports, particularly when the chart is important information rather than a decorative overview.

Excel versus other ways to make an org chart

Excel is a sensible choice for a modest, mostly static chart when the workbook is already where people work and the diagram needs only basic hierarchy. SmartArt is faster to create and rearrange than drawing every box, while manual shapes allow more layout freedom. Neither approach should be mistaken for a live organization directory without a separately maintained connection or process.

For complex charts, frequent reorganizations, collaboration among many editors, or automatic data-driven updates, compare Excel with a dedicated diagramming tool or an HR information system. These products may provide specialized templates, data import, or publishing options, but features and costs depend on the product and plan. Excel’s main advantage is that it is familiar and can keep a diagram beside related spreadsheet information; its limitation is that changes to the underlying workforce data are not automatically reflected in the SmartArt graphic.

On Excel for Mac, SmartArt is available in desktop editions, though ribbon layout and some labels can differ from Windows; look under Insert for SmartArt. Excel for the web has a different feature set and may not provide the same editing experience for every diagram element, so use the desktop app if a command or layout option is missing. Check the current app’s ribbon rather than assuming every platform behaves identically.

Frequently Asked Questions

Can Excel make an org chart automatically from a list?
Not simply by inserting an organization chart. SmartArt gives you a hierarchy graphic, but you enter and arrange its content. A table can hold employee and manager data, yet it does not automatically become a SmartArt diagram or keep that diagram synchronized.

How do I add a person under a manager?
Select the manager’s box in the SmartArt graphic, then use SmartArt Design > Add Shape and choose the appropriate option, such as adding a shape below. You can also edit the Text pane and indent the new entry to the intended level, then verify the resulting placement.

Can an employee report to two managers?
A standard organization chart is designed to show a primary hierarchy, so a dual-reporting relationship may not be obvious. You can add a secondary connector or note, but label it clearly and include a legend. For many matrix relationships, another diagram style may communicate the structure better.

Can I print an Excel org chart on one page?
Often, but fitting a wide chart to one page can make it too small to read. Check Print Preview and consider landscape orientation, a larger page, or separate charts by department rather than shrinking the text excessively.

Will the chart update when I change the employee table?
No, not by default. SmartArt and manually drawn shapes are separate from ordinary worksheet cells. Update the diagram as part of the same review process as the source table, or choose a tool designed to generate charts from maintained organizational data.

A reliable way to finish

For most basic charts, start with SmartArt, enter a checked hierarchy, and use the Text pane and Add Shape controls to make changes. Review the names, roles, reporting lines, print size, and sharing audience before distributing the workbook. If edits are frequent or the structure is complex, evaluate a dedicated tool instead of relying on a manually maintained Excel graphic.

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.