Create an Org Chart in Excel From a List

Charts & pivot tables · Updated November 19, 2026

Yes. Put each person in a list with their manager, then use Insert > SmartArt > Hierarchy > Organization Chart to build the diagram. Excel cannot infer reporting lines from names alone, so you must supply or arrange the parent-and-subordinate relationships in SmartArt.

What your list needs to show

A useful org chart is based on reporting relationships, not just a roster. A list with employee names and job titles may look complete, but it does not tell Excel who reports to whom. Add a manager or supervisor field so the chain of responsibility is clear before you draw anything.

For example, a source list could have columns for Employee, Job Title, and Manager. An illustrative structure might be:

  • Jordan Lee, President, no manager
  • Sam Patel, Operations Director, Jordan Lee
  • Casey Morgan, Finance Director, Jordan Lee
  • Riley Chen, Operations Manager, Sam Patel

Jordan is the top person, Sam and Casey report to Jordan, and Riley reports to Sam. The manager column describes the relationships, but Excel’s SmartArt tool does not automatically turn that ordinary table into a chart. You will use the relationships to create the hierarchy in the SmartArt text pane.

Decide what belongs in each box, too. Names alone are compact; names plus titles give readers more context but make boxes larger. You might include a department or location when it helps explain the structure, but avoid adding details that make the chart hard to scan.

Prepare and check the source list

Before building the graphic, make the source data consistent. Use one row per person and spell each name the same way everywhere. A manager’s name in the Manager column should match that manager’s employee name exactly. If the same person appears as “Alex Smith” in one place and “A. Smith” in another, it may be unclear whether those entries refer to the same person.

  • Choose one person as the top of the chart and leave that person’s manager field blank or label it clearly as the top role.
  • Check that every other employee has the intended manager, including people who report directly to the top role.
  • Look for circular relationships, such as one person listed as another’s manager while also reporting back to them.
  • Decide how to show vacancies, temporary reporting lines, contractors, or shared reporting before drawing the chart.
  • Keep the source list on a separate worksheet if you want a convenient record to compare with the finished graphic.

If someone reports to two managers, a traditional org chart may not express that relationship cleanly. Decide whether to show the primary reporting line and note the secondary relationship, or use a diagram designed for matrix reporting. The goal is to represent the real structure without implying a single reporting path where none exists.

Create the chart with SmartArt

In Excel for Microsoft 365 on Windows, follow these steps to create the basic chart:

  1. Open the worksheet where you want the diagram. Select Insert > SmartArt.
  2. In the Choose a SmartArt Graphic window, 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. You can also use the Text Pane command on the SmartArt Design tab when it is available.
  4. Enter the top person first. In the text pane, press Enter to add another item at the current level. Press Tab to make an item a subordinate of the item above it, and Shift+Tab to move an item up one level.
  5. Continue entering names and assigning levels until each person is under the correct manager. Review the diagram as you go, since the text hierarchy determines the boxes and connector lines.

For the example above, enter Jordan Lee as the first item, then add Sam Patel and Casey Morgan as direct reports at the next level. Add Riley Chen as a subordinate of Sam Patel. The important part is the indentation: Riley must be one level below Sam, not at the same level as Sam and Casey. If the hierarchy is wrong, correct the level in the text pane rather than trying to drag connector lines around.

The same SmartArt feature is available in Excel for Mac, although the ribbon layout and some labels can differ. Look for SmartArt under the Insert tab, choose a hierarchy layout, and use the SmartArt text pane to organize the entries. In Excel for the web, available SmartArt editing options can vary; if a needed control is missing, open the workbook in the desktop app.

Add, remove, and rearrange people

To add someone after the first draft, select the relevant box and use SmartArt Design > Add Shape. The available choices depend on the selected box and can include adding a shape after, before, above, or below it. For a role such as an executive assistant, use Add Shape > Add Assistant when that option is available. Then confirm that the new box appears at the intended level.

You can also edit the text pane directly. Press Enter to add an item at the current level, then use Tab or Shift+Tab to set its place in the hierarchy. To remove a person, select the corresponding text-pane entry or box and delete it. Check the result afterward: removing or moving a person can change the positions of other boxes, especially when several people report to the same manager.

When someone changes managers, move their entry to the correct level and location in the text hierarchy. Do not rely on the visual position of a box alone as evidence that the reporting line is right. The connector line and the structure shown in the text pane should agree with your source list.

Make the diagram readable

SmartArt lays out shapes for you, but a large organization can quickly outgrow one worksheet view. Names and titles may wrap, boxes may become small, and the chart may span more columns than a printed page can show. Start with a compact level of detail, then adjust the layout and page setup based on how people will read the result.

  • Use a consistent format for names and titles, such as the same line order in every box.
  • Keep text short enough to fit without shrinking it until it is difficult to read.
  • Use a hierarchy layout that matches the chart’s shape; a wide team may need a different arrangement from a tall reporting chain.
  • Use color sparingly to distinguish departments or groups, and do not rely on color alone to convey reporting relationships.
  • Check the chart at normal worksheet zoom and in print preview, not only while editing a selected SmartArt object.

To change the arrangement, select the chart and review the layouts on the SmartArt Design tab. SmartArt Styles and the Format tab provide additional appearance controls. Names of commands or groups may be arranged differently on Mac, but the same general SmartArt design and formatting tools are available. If the chart is for printing, use Page Layout settings and Print Preview to check whether it fits; scaling a very wide diagram onto one page can make text unreadable.

Keep the chart aligned with changing data

SmartArt is a diagram, not a live organizational database. Editing a name in the original worksheet list does not automatically update the corresponding SmartArt box, and changing a box does not update the source list. If reporting lines change, compare the chart with the source data and edit the SmartArt hierarchy deliberately.

For a small team, updating SmartArt by hand is often practical. For a larger organization, keep the employee-and-manager table as the authoritative source, record when it was last reviewed, and assign someone to check the chart after personnel changes. If the diagram is used for formal reporting or planning, include a date or version note so readers can tell whether it is current.

For charts that must be regenerated frequently from structured data, consider a dedicated diagramming or organizational-chart tool that supports data import and refresh. Confirm what its import feature actually updates: some tools can create boxes from rows but still need rules for manager IDs, missing managers, duplicate names, or multiple reporting lines.

SmartArt compared with other approaches

SmartArt is a good choice when the chart is modest in size, the hierarchy is straightforward, and the result needs to stay inside an Excel workbook. It is quick to create, easy to format, and convenient for a chart that will be reviewed alongside spreadsheet data. Its main limitation is that the diagram is not automatically linked to a normal employee table.

Drawing boxes and connectors manually gives precise placement, but it becomes tedious to maintain when people move or teams expand. A specialist charting application can be a better fit for a large organization, repeated updates, or complicated reporting structures. PowerPoint is another option when the main purpose is presentation rather than keeping the chart in a workbook. Choose based on update frequency, chart size, collaboration needs, and whether the source data must remain synchronized.

Common problems and practical fixes

  • Everyone appears at the same level: Check the indentation in the SmartArt text pane. Use Tab to make an entry subordinate and Shift+Tab to promote it.
  • A person reports to the wrong manager: Move the person to the correct position in the text hierarchy, then verify the connector line.
  • The chart is too crowded: Shorten labels, split a large chart into department-level views, or choose a more suitable hierarchy layout.
  • Changes to the worksheet do not appear in SmartArt: This is expected; the source table and diagram are separate. Update the SmartArt as well.
  • Names are hard to distinguish: Include job titles or departments, or use a unique identifier in the source list while keeping the displayed box text readable.

A frequent misconception is that sorting the worksheet by manager will create the reporting structure. Sorting can group related rows for easier review, but it does not define parent and child levels in SmartArt. The hierarchy must be represented in the text pane, and the chart should be checked against the manager relationships in the source list.

Frequently Asked Questions

Can Excel make an org chart automatically from a list?

Not from a plain list of names. You need manager or parent relationships, and standard SmartArt does not automatically convert a regular worksheet table into an updating org chart. You can use the list as a reference while entering the hierarchy in SmartArt.

What columns should an org chart list have?

At minimum, use an Employee column and a Manager column. Job Title is useful for labeling the boxes. A department, location, or employee ID can help clarify records, but include extra fields in the chart only if readers need them.

How do I move a box to a different level?

Select the entry in the SmartArt text pane. Press Tab to indent it as a subordinate, or Shift+Tab to promote it one level. Then inspect the chart to make sure the box reports to the intended person.

Can I link the chart to cells so it updates automatically?

SmartArt text is not a live link to ordinary worksheet cells. Changes to the list will not refresh the boxes automatically. For recurring updates, manually reconcile the diagram or use a charting tool with a data-import and refresh workflow.

Can I print a large org chart from Excel?

Yes, but a large chart may be split across pages or scaled down too far. Check Print Preview, adjust page orientation or scaling, and consider printing separate department views if a single-page version would make the text too small.

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.