Automatically Create an Org Chart in Excel: What Works

Charts & pivot tables · Updated November 19, 2026

Excel can quickly create an org-chart graphic with SmartArt, but it cannot automatically turn a regular employee table into a chart that stays linked to the table. In Microsoft Excel for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy > Organization Chart, then enter or arrange the reporting relationships; for a chart generated from structured employee data, consider desktop Visio or a suitable add-in.

What Excel can automate—and what it cannot

Excel’s built-in option is SmartArt. It supplies a hierarchy layout and lets you add, remove, and reposition boxes, so you do not have to draw every shape from scratch. You still need to provide the people and establish who reports to whom. SmartArt does not read a Manager column in a worksheet and infer the chart, and its boxes are not live links to worksheet cells.

That distinction matters when people search for an automatic org chart. There are two different goals:

  • Create the first visual quickly: SmartArt is a convenient built-in choice when the organization is small or the chart changes infrequently.
  • Generate or update a visual from employee records: Use a tool designed to import reporting data, or a controlled custom solution. A normal Excel table by itself does not make SmartArt refresh from its rows.

SmartArt is suitable for a presentation, a printed reference, or a small team diagram. It is less suitable as a continuously maintained directory when the source roster changes often. Choosing the right method at the start can prevent the chart from becoming a second, out-of-date copy of the employee data.

Prepare the employee data first

Before making a chart, make the reporting structure unambiguous. A useful source table has one row per person and separate columns for identifying and display information. For example, a fictional roster could contain Employee ID, Name, Job Title, Department, and Reports To. The Reports To value should identify the direct manager consistently, ideally by a stable ID rather than a name that might be shared by two employees.

Include a clear root, such as the chief executive, whose Reports To field is blank or marked as the top position. Every other employee should connect to one manager unless the organization deliberately represents a different structure. In a conventional org chart, a person should not report to themselves, a manager should not be missing from the roster, and reporting relationships should not form a loop.

For a small chart being entered manually, a simple outline can help translate the table into levels. For instance:

  • Executive Director
  • Operations Manager
  • Facilities Coordinator
  • People Manager
  • Recruiter
  • Finance Manager

The outline’s indentation is important: Facilities Coordinator and People Manager might both report to Operations Manager, while Recruiter might report to People Manager. A flat list sorted alphabetically does not communicate those relationships. Review the source table with someone responsible for the reporting structure before publishing, especially if the chart will be used for approvals or emergency contacts.

Create a basic org chart with SmartArt

In Excel for Microsoft 365 on Windows, create the graphic as follows:

  1. Open the worksheet where the chart should appear and select a blank area. If the chart is large, consider creating a separate worksheet for it.
  2. Choose Insert > SmartArt, select Hierarchy, choose Organization Chart, and select OK.
  3. Select the small arrow on the left edge of the SmartArt graphic to open its Text pane if the pane is not already visible.
  4. Enter the top position first, then add the other positions. Press Enter to add another item at the current level. Press Tab to make an item a subordinate of the item above it, or Shift+Tab to move it up a level.
  5. Replace placeholder text with a person’s name and, if useful, their role. Keep the labels concise so they fit in the boxes.
  6. Select the graphic and use the SmartArt Design and Format tabs to adjust the layout, colors, and appearance. Save the workbook and inspect the result at a readable zoom level.

For example, if the Text pane contains Executive Director, then Operations Manager indented one level, then Facilities Coordinator indented beneath Operations Manager, the graphic shows the coordinator reporting to that manager. A second manager entered at the same level as Operations Manager appears as another direct report to the executive, provided the outline indentation is correct.

On Excel for Mac, the SmartArt choices are also accessed from the Insert tab, though the ribbon arrangement and dialog appearance can differ by release. Look for SmartArt, then the Hierarchy category and an organization-chart layout. The exact position of the Text pane control may look different. The Windows-specific ribbon path above should not be assumed to match every Mac build pixel for pixel.

Set reporting levels and add special roles

The outline is the key to the structure. In the Text pane, items at the same indentation level are peers; indenting an item makes it a lower level. A common error is to press Enter repeatedly and assume Excel will infer the manager from the order of the names. It will not: users must set the hierarchy explicitly, using Tab and Shift+Tab or the SmartArt controls.

SmartArt includes options for adding a shape relative to a selected position. Select a box, then use the SmartArt Design tab’s Add Shape menu to add a position before, after, above, or below it. For an assistant role, select the relevant manager and choose Add Shape > Add Assistant when that option is available for the selected layout. Check the resulting placement carefully; a visually adjacent box does not necessarily mean the reporting relationship is correct.

Some organizations have dotted-line relationships, shared leadership, vacancies, or temporary assignments. A basic hierarchy communicates a primary reporting line, not every working relationship. If viewers could mistake a dotted-line connection for a direct report, add a legend or a clear note rather than relying on color alone. For complex matrix structures, a single conventional org chart may not be an adequate representation.

Make the chart readable and maintainable

Large charts can become difficult to read because every additional layer and branch consumes space. Use short labels such as name on one line and title on another, and avoid unnecessary information such as phone numbers if the chart will be printed. You can resize the SmartArt graphic by dragging its handles, but making it wider does not solve every problem: a very wide chart may be unreadable on a standard page.

Before sharing, check that names and titles have not been clipped, that the top role is obvious, and that peers are aligned consistently. Use a restrained color scheme and maintain enough contrast between text and background. If color indicates department or status, include a text explanation so readers are not required to distinguish colors alone. Add a date or version note outside the chart when readers need to know when the reporting data was reviewed.

Consider accessibility as well as appearance. Give the graphic useful alternative text where appropriate, and do not communicate reporting relationships only through color. A chart intended for screen readers may be easier to understand when the same reporting information is also available as a well-structured table or outline in the workbook.

What happens when the roster changes?

SmartArt text is stored in the graphic rather than being connected to a worksheet roster. If an employee changes manager, you must edit the hierarchy yourself. If the employee’s name or title changes, update the chart text too. Keeping the source table and the SmartArt in the same workbook does not create a live connection between them.

For an occasional update, open the Text pane, revise the relevant entry, and check the layout afterward. A change in a manager’s name may be simple; moving a whole department can require changing several hierarchy levels. Keep a documented source of truth, assign someone to review changes, and date the published chart. If a roster has been edited by multiple people, compare the finished chart with the current approved data rather than assuming that the graphic is still accurate.

If updates happen frequently, plan the process before choosing the tool. A repeatable import or refresh workflow may reduce manual re-entry, but it still needs checks for missing managers, duplicate IDs, inactive employees, and unexpected reporting loops. Automation can reproduce bad source data as efficiently as good data, so validation remains part of the job.

Excel SmartArt, Visio, and other options

SmartArt is the simplest built-in Excel approach when a person can enter the structure and manual maintenance is acceptable. It keeps the chart in the workbook, requires no separate data-import setup, and is easy to adjust for a small team. Its limitation is the lack of a direct connection to a roster table.

Microsoft Visio desktop editions that include the Organization Chart Wizard can create an org chart from structured information, including information held in an Excel file. The wizard asks for the source and which fields identify people and managers, then lays out the chart. Availability depends on the Visio edition and license, so check the installed product before planning a workflow. Importing data is not the same as having a continuously synchronized chart: confirm how the chosen Visio version handles later source changes and whether you need to rerun the import or update the diagram.

Other options include a reputable org-chart add-in or an organization’s approved HR platform. Before using one, check whether it supports the required Excel version, what data it sends outside the workbook, how it handles updates, and whether its output can be edited or exported. A custom macro may be possible, but it needs maintenance and careful testing; it should not be treated as a built-in Excel feature or run on the only copy of a workbook.

PowerPoint SmartArt can be useful when the main purpose is a presentation, but it has the same basic manual-hierarchy limitation. If the requirement is a chart that reflects a frequently updated employee directory, choose a source-connected workflow rather than moving the same manually maintained graphic between Office applications.

Common problems and checks before sharing

When the diagram looks wrong, first inspect the outline rather than changing colors or box positions. A misplaced indent can make a department appear under the wrong manager. Confirm each direct report, check that there is only one intended top position, and look for names that were omitted or entered twice.

  • Boxes are crowded: Shorten labels, split a very large chart into department-level views, or use a larger page or sheet area. Do not shrink text until it becomes hard to read.
  • A person appears at the wrong level: Select the item in the Text pane and correct its indentation; then verify the visual result.
  • Changes in the table did not appear: That is expected for SmartArt, because it is not linked to the cells. Update the graphic manually or use a data-import workflow.
  • Two people have the same name: Add a title, department, or employee identifier to distinguish them, while avoiding exposure of sensitive identifiers to an audience that does not need them.
  • The chart is hard to print: Preview the page layout and print settings, or distribute a readable digital version instead of forcing a wide chart onto one page.

Finally, consider who should see the file. Names, job titles, team structures, and vacancies can be sensitive organizational information. Follow your organization’s access and sharing rules, remove unnecessary personal details, and check the workbook for unrelated sheets or data before sending it outside the intended audience.

Frequently Asked Questions

Can Excel create an org chart automatically from a table?
Not with SmartArt alone. SmartArt creates a hierarchy graphic, but you must enter or arrange its reporting levels. For a chart generated from employee and manager fields, use a tool such as the Visio Organization Chart Wizard when your desktop edition includes it, or an approved add-in.

Can an Excel org chart update when I change a cell?
A SmartArt chart does not update from worksheet cells because its text is not linked to the roster. You must edit the SmartArt, or use a data-import solution and follow that product’s update process.

How do I show a manager and direct reports in SmartArt?
Enter the manager and direct reports in the Text pane, using indentation to indicate levels. Items indented beneath a manager represent lower-level positions; inspect the finished diagram to ensure the intended reporting lines are clear.

Is Visio better than Excel for an org chart?
Visio is often a better fit when the chart should be generated from structured reporting data. Excel SmartArt is simpler for a small, manually maintained diagram. The best choice depends on chart size, update frequency, available licenses, and whether the source data must drive the visual.

Can I make an org chart in Excel for Mac?
Excel for Mac has SmartArt hierarchy layouts, although ribbon placement and dialogs can vary by release. Use the Insert tab to find SmartArt and choose a hierarchy layout, then enter the structure in its text interface.

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.