Create an Org Chart From Excel Data in Excel

Charts & pivot tables · Updated November 19, 2026

Yes. In Microsoft Excel for Microsoft 365 on Windows, you can create an org chart with Insert > SmartArt > Hierarchy > Organization Chart, then arrange employee names by reporting level in the SmartArt Text Pane. Excel does not automatically turn a manager-and-employee data table into a chart that stays linked to the table, so plan to build or update the chart structure separately.

What an Excel org chart shows

An organizational chart, or org chart, represents who reports to whom. Each person appears in a box, and connecting lines show the reporting relationships. It is useful for communicating a team structure, introducing an organization, or documenting a department. It is not the same as a staff directory: a directory might list job titles and contact details without showing the chain of responsibility.

Excel can display a hierarchy using SmartArt, but the source data and the finished graphic are different things. A worksheet table can store employee records in rows; a SmartArt org chart stores names and levels in its own graphic. Creating the chart from a table therefore involves translating the reporting relationships into a hierarchy. If a person changes manager, you generally need to update the chart itself as well as the table.

Prepare the employee data

Before drawing anything, decide which relationships the chart should show. A simple source list can have columns for Employee, Job Title, and Manager. For example, Maya Chen might be the department head, with Luis Ortiz and Priya Shah reporting to her; if Jordan Lee reports to Luis, Jordan belongs one level below Luis. This manager relationship—not alphabetical order or job title—is what determines where each box goes.

Check the source data for issues that can make the structure ambiguous:

  • Use one consistent name for each employee. Avoid having the same person entered under different spellings.
  • Make manager names match the employee names in the list, and confirm that each person has the intended manager.
  • Identify the top-level person or role. That person normally has no manager within the chart.
  • Decide whether to include contractors, vacant roles, assistants, or only current employees.
  • Check for circular reporting, such as A reporting to B while B reports to A. A chart cannot represent that as a normal hierarchy.

A flat table with one row per employee is convenient for maintaining records, but SmartArt needs a nested outline. A useful planning step is to sort or group the names by reporting level, then make a separate outline for the chart. Do not assume that sorting names by manager will create the right parent-and-child structure automatically.

Create the chart with SmartArt

In Excel for Microsoft 365 on Windows, use these steps:

  1. Select the worksheet and cell area where you want the graphic to sit. You do not have to select the employee table.
  2. Choose Insert > SmartArt. In the SmartArt gallery, select Hierarchy, choose Organization Chart, and select OK.
  3. Open the SmartArt Text Pane if it is not already visible. You can use the small arrow at the left edge of the SmartArt graphic or choose SmartArt Design > Text Pane.
  4. Enter the top-level employee first. Press Enter to create another item at the same level. Use Tab to indent a person beneath the preceding higher-level person, and Shift+Tab to promote an item to a higher level.
  5. Review the outline carefully. A name indented beneath a manager becomes a subordinate in the chart; the visual position depends on that hierarchy.

For instance, enter Maya Chen at the top level, then Luis Ortiz and Priya Shah as direct reports beneath Maya. Add Jordan Lee as a subordinate beneath Luis, not as another direct report to Maya. In the Text Pane, indentation communicates the relationship; adding spaces to the beginning of a name is not a reliable substitute.

You can also select a shape and use SmartArt Design > Add Shape to add a person before or after it, above it, or below it. The available choices depend on the selected shape and layout. In an organization chart, the Add Assistant option can be used for an assistant relationship where that distinction is appropriate. Use the Text Pane when you need to check the full hierarchy at a glance.

Format and fit the hierarchy

After the names and reporting levels are correct, select the SmartArt graphic to see the SmartArt Design and Format tabs. SmartArt Design offers alternate hierarchy layouts and SmartArt styles; Format provides options for individual shapes, text, fills, and outlines. Keep the visual treatment restrained enough that names and reporting lines remain legible.

A chart may become crowded when many employees report to one manager or when it has several levels. Try a wider layout, enlarge the graphic, or split a large organization into department-level charts. Short labels—such as name and title—usually fit better than full biographies. If you add titles, keep them consistent, for example, put every title on a second line rather than mixing title placement from box to box.

To move or resize the whole chart, select its outer boundary rather than an individual box. Drag a corner handle to resize while keeping the proportions more consistent. For printed or shared worksheets, check the result in Print Preview and confirm the page orientation and scaling; a chart that looks clear on screen may become too small when squeezed onto one printed page.

Keep the chart accurate as people change

SmartArt is a graphic, not a live view of the employee table. Changing a manager name in a worksheet cell does not automatically move that employee’s SmartArt box. Similarly, refreshing a table or changing a filter does not rebuild the org chart. This is an important limitation if the organization changes frequently or has many employees.

For a small team, a practical process is to keep the employee table as the authoritative record, update the SmartArt when reporting lines change, and then compare the two before sharing the workbook. Include a last-updated date near the chart if readers need to know whether it is current. For a larger organization, assign responsibility for chart maintenance instead of assuming that anyone who edits the roster will also update the graphic.

When reviewing an update, verify more than the names. Check that every included employee appears once, each person is connected to the correct manager, the top-level position is correct, and vacancies or excluded groups are treated consistently. A visually polished chart can still be misleading if one relationship is wrong.

Excel SmartArt versus other ways to make an org chart

SmartArt is a good fit for a small or medium-sized hierarchy that needs to be placed directly in a workbook and edited occasionally. It is quick to create, does not require a separate data-visualization tool, and can be formatted alongside worksheet content. Its main drawback is the manual separation between the graphic and the source list.

For a large reporting structure or a chart that must be regenerated from a data source, a dedicated diagramming application may be more suitable. Microsoft Visio offers organization-chart tools and, depending on the Visio version and available features, can use structured information such as an Excel file to create a diagram. Check the capabilities of the specific Visio edition before choosing it, and verify how updates to the source data are handled. A linked or imported workflow is not the same as Excel SmartArt automatically refreshing from any table.

Another option is to build the diagram with Excel shapes and connectors. This gives precise control over box placement and appearance, but takes more work and can be difficult to maintain when the hierarchy changes. For a very small team, a neatly formatted table may be clearer than a diagram. Choose a chart when the reporting relationships are the point; choose a table when readers mainly need searchable details such as email, role, or location.

Common problems and practical fixes

  • Names appear at the wrong level: Open the Text Pane and correct the indentation. Use Tab to move a selected item down a level and Shift+Tab to move it up.
  • The chart is too crowded: Shorten labels, increase the graphic size, try another hierarchy layout, or divide the organization into smaller charts.
  • Updates to the worksheet do not change the chart: This is expected with SmartArt. Edit the graphic too, or use a workflow designed to generate diagrams from structured data.
  • A manager has no box: Add the manager as a person in the hierarchy before placing direct reports beneath them. A reporting line needs a represented parent position if the chart is to show it clearly.
  • There are multiple reporting relationships: A basic org chart communicates one primary hierarchy most clearly. If employees report to several managers, state which relationship the chart represents or choose a diagram better suited to matrix reporting.

Excel for Mac also includes SmartArt, although ribbon organization and dialog details can vary by release. Look under Insert for SmartArt and choose a hierarchy layout; then use the Text Pane to arrange levels. Excel for the web may have fewer creation or editing capabilities than the Windows desktop app, so if the SmartArt commands you need are unavailable, open the workbook in desktop Excel. The same core caution applies on each platform: a SmartArt graphic should not be presumed to stay synchronized with a worksheet roster.

Frequently Asked Questions

Can Excel make an org chart automatically from an employee list?
Not directly with the standard SmartArt org chart. You can create the graphic in Excel and arrange its levels in the Text Pane, but a flat list of employees and managers is not automatically converted into a SmartArt hierarchy that remains connected to the table.

What columns should an org chart Excel file have?
A practical source table includes an employee name and a manager name. A job title is useful for display, while an employee ID can help distinguish people with similar names. The manager value should consistently identify the manager in the employee list; the top-level person can have a blank manager field if that matches your recordkeeping convention.

How do I move someone to a different manager in SmartArt?
Change the person’s level in the Text Pane by selecting the item and using Tab or Shift+Tab, then confirm the resulting chart. If the person is moving between branches at the same level, reorganize the outline so the person sits beneath the correct manager. Also update the source table separately.

Can I link SmartArt boxes to cells?
SmartArt does not provide a general live link that makes each org-chart box automatically follow a corresponding employee row and manager relationship. You can edit the chart text, but changes in worksheet cells should not be expected to update the graphic on their own.

Is an org chart better than a table?
It depends on what readers need. A chart is effective for showing hierarchy and reporting lines; a table is often easier to search, sort, filter, and maintain when there are many employees or many details per person. Some workbooks include both, with the table serving as the detailed roster and the chart offering a visual summary.

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.