Excel Org Chart: Create One from a Manager Data Range

Charts & pivot tables · Updated November 19, 2026

To create an org chart from an Excel data range, first arrange the data so each person has a name and a manager, then use Excel’s Insert > SmartArt > Hierarchy > Organization Chart to build the structure. Excel does not automatically turn an arbitrary table into a linked org chart; for a chart generated from a larger manager-and-employee table, use Visio’s Organization Chart Wizard if it is available in your edition.

What Excel can—and cannot—do

An org chart is a hierarchy: each person or role occupies a position, with reporting relationships connecting the boxes. Excel can display that hierarchy with SmartArt, but SmartArt is a diagram editor, not a table-to-chart converter. Inserting an organization chart does not make Excel infer who reports to whom from adjacent columns.

This distinction affects how you plan the work. For a small team or a chart that changes rarely, you can use the spreadsheet as a source and build the SmartArt graphic yourself. For a large roster, frequent updates, or a need to regenerate the diagram from records, a data-driven tool such as Visio is usually more suitable. In either case, the quality of the result depends on clean reporting data.

Prepare the source range

Keep one person per row, with a single header row and no merged cells or blank separator rows. A practical layout might include Employee ID, Employee Name, Manager ID, Job Title, and Department. The manager ID is useful because two people can share a name; matching a unique ID avoids ambiguity.

For example, a simple source might say that E001, Jordan Lee, has no manager, while E002, Sam Patel, has manager ID E001. That means Jordan is the top-level person and Sam reports to Jordan. The table describes the relationship in data; the chart represents it visually.

  • Give each employee a unique, consistently formatted identifier.
  • Use the same ID in the manager field that appears in the employee ID column.
  • Leave the manager field blank for the top of the hierarchy, rather than entering a made-up manager.
  • Check for misspelled names, duplicate IDs, missing managers, and accidental spaces.
  • Decide whether the chart should show people, job roles, or both; do not mix these without a clear convention.

To make the range easier to maintain, select a cell in it and press Ctrl+T on Windows, then confirm that the table has headers. On Mac, use Command+T in Excel for Mac. A table expands when you add rows and gives the source a stable name, although that alone does not make a SmartArt diagram update automatically.

Build the chart with SmartArt

In Excel for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy, select Organization Chart, and choose OK. Excel inserts a blank diagram. The same general SmartArt approach is available in Excel for Mac, though the ribbon layout can differ slightly. If a command is missing or arranged differently in Excel for the web, open the workbook in the desktop app for the full set of diagram controls.

  1. Select the SmartArt graphic, then open its text pane using SmartArt Design > Text Pane.
  2. Enter the top-level person first. Press Enter to add another item at the same level.
  3. To make an entry a direct report, place the cursor at the start of its line and press Tab to demote it. Use Shift+Tab to promote it back a level.
  4. Continue entering the hierarchy, checking each level against the Manager ID column in your source table.
  5. Use the SmartArt Design and Format tabs to choose a layout, color treatment, and text styling that remains legible.

In the text pane, indentation represents reporting level. A simple outline could have the chief executive at the first level, department heads below, and team members indented under their own manager. Do not rely on row order alone: employees sorted alphabetically in Excel will not necessarily appear under the right manager in SmartArt.

Translate manager records into a hierarchy

A manager-based table and a SmartArt outline express the same information differently. The table says “this employee’s manager is this ID”; the outline says “this item is nested beneath that item.” Before typing into the text pane, map each employee to their manager and group direct reports under the correct person.

Consider this miniature roster: Jordan Lee has no manager; Sam Patel and Alex Chen each have manager ID E001; and Morgan Diaz has manager ID E002. The chart should place Jordan at the top, Sam and Alex on the next level, and Morgan beneath Sam. If Morgan is placed next to Alex instead, the chart may look tidy but it misstates the reporting relationship.

For a bigger list, make a working copy or a separate worksheet for the chart outline. Sort or filter the source to make it easier to inspect managers and their direct reports, but remember that sorting does not create the nesting automatically. If the company has several top-level leaders, decide whether the chart should show a shared parent such as “Board” or whether it should display separate branches. Avoid inventing a reporting relationship merely to make the diagram look symmetrical.

Use Visio when the chart should come from the data

If the goal is to generate an org chart from the Excel records rather than manually draw it, Microsoft Visio may offer a better workflow. In Visio desktop, start an organization chart and use the Organization Chart Wizard to import information stored in a file. Depending on the Visio edition and version, the wizard can use an Excel workbook and map fields such as employee name and the person they report to. Availability and exact prompts can vary, so check the options in your installed edition.

Prepare the workbook with clear column headings and a consistent identifier or manager-name field, then choose the worksheet or range requested by the wizard and match the relevant columns to its fields. Review the generated chart carefully: imported data can reveal missing managers or unexpected branches, but it cannot determine whether the underlying reporting information is correct. Save the Visio diagram separately if you need to preserve the imported source workbook.

Visio is useful when there are many employees, the hierarchy needs to be regenerated, or you need diagram-specific tools for connectors and page layout. It may require a separate license or an edition that includes the relevant functionality. For a compact chart that will be edited only occasionally, SmartArt in Excel can be simpler and avoids maintaining a separate diagram file.

Make the chart readable and useful

A correct hierarchy can still be hard to understand if boxes are crowded or labels are inconsistent. Decide what information each box needs before formatting. A common choice is a person’s name on the first line and their title on the second; adding department, location, phone number, and email to every box can make the chart too dense.

  • Use a consistent naming format and title style throughout the chart.
  • Keep the number of details in each box small, and use a legend or a nearby table for extra information.
  • Choose a layout that fits the number of reporting levels. A chart with many levels may need a wider page or multiple pages.
  • Use color to communicate a clear distinction, such as departments, not simply as decoration.
  • Check the chart at its intended print or screen size; text that looks readable while zoomed in may be tiny when printed.

For printing, use Page Layout options to set orientation, paper size, and scaling, then inspect Print Preview. A wide hierarchy often fits landscape better than portrait. Avoid shrinking a complex chart to a single page if that makes names unreadable; splitting it by department or using a larger paper size may be more practical.

Keep the chart accurate after changes

SmartArt created in Excel is not a live view of the source range. If a manager changes in the table, Excel will not automatically move that person’s box to a different branch. Treat the diagram as a separate representation: after updating the source, review the affected employee and their reports, then revise the SmartArt outline or rebuild the diagram.

For recurring updates, keep the source table as the authoritative record and include a review date or version note near the chart. A useful check is to compare each person’s manager in the source against the person directly above them in the diagram. Also check for new hires, departures, vacant roles, interim managers, and people with multiple reporting relationships. A conventional org chart usually shows one primary reporting line; matrix relationships may need a separate note or diagram rather than extra connectors that make the hierarchy confusing.

Common problems and alternatives

If a person appears at the wrong level, check the indentation in the SmartArt text pane; pressing Tab or Shift+Tab changes hierarchy level. If the chart has an unexpected top box, look for a source row with a blank or incorrect manager field. If a report is missing, confirm that the entry was added to SmartArt and not merely added to the Excel table. These issues are often data or outline problems, not chart-formatting problems.

Excel charts such as column or bar charts are not substitutes for org charts: they plot numeric values, not reporting links. Shapes and connector lines give you more freedom than SmartArt but must also be arranged manually. PowerPoint SmartArt can be convenient when the final product is a presentation, while Visio is the stronger option when the diagram itself needs dedicated layout and data-import features. Choose based on update frequency, chart size, required precision, and the tools your organization already has.

Frequently Asked Questions

Can Excel create an org chart automatically from a data range?
Not with SmartArt alone. SmartArt creates an editable hierarchy graphic, but it does not automatically map arbitrary employee and manager columns into that graphic. For a data-driven import, check whether Visio’s Organization Chart Wizard is available in your edition.

What columns do I need for an org chart?
At minimum, use an employee name and a manager field. A unique employee ID and matching manager ID make the relationships safer to interpret, especially when names repeat. Titles and departments are optional fields for labels or grouping.

How do I add a direct report in SmartArt?
Open the SmartArt text pane, add the person’s entry, and use Tab to indent it beneath the appropriate manager. Use Shift+Tab to move an entry up a level. Verify the placement against the manager information in your source.

Will my SmartArt org chart update when I edit the Excel table?
No. A standard SmartArt graphic is not linked to the table as a reporting-data model. Update the graphic separately, or use a data-import workflow designed to regenerate diagrams from source records.

Can an org chart show more than one manager?
A typical org chart emphasizes one primary reporting relationship for each person. If employees report to multiple leaders, show the primary structure and explain secondary or matrix relationships separately, or use a diagramming tool that supports clearly labeled additional connections.

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.