Org Chart Creator in Excel: Steps, Limits, and Options

Charts & pivot tables · Updated November 20, 2026

Excel can create an org chart with its built-in SmartArt feature: choose Insert > SmartArt > Hierarchy, select an organization chart layout, and enter employee names and reporting relationships in the text pane. This works well for a modest, mostly static chart; Excel does not automatically turn an employee table into a fully synchronized org chart.

What an Excel org chart can do

An organizational chart, or org chart, shows roles and reporting relationships in a company, department, project, or other group. Boxes typically contain a person’s name and job title, while connecting lines indicate who reports to whom. Depending on the chart’s purpose, it may also show teams, locations, or vacancies.

Excel’s SmartArt hierarchy layouts provide a visual starting point without requiring you to draw every box and connector. You can add, remove, and rearrange positions, change the chart’s appearance, and keep it alongside other workbook content. That can be convenient when the chart is for a team meeting, an internal reference, or a report already maintained in Excel.

There is an important distinction, though: SmartArt is a diagram, not a database-backed organizational charting system. Typing or pasting a list of employees into a worksheet does not, by itself, make Excel infer each person’s manager and build a chart that stays linked to the list. You provide and maintain the hierarchy in the SmartArt graphic.

Create a chart with SmartArt

In Excel for Microsoft 365 on Windows, start with a blank worksheet or open the workbook where you want the chart. Use these steps:

  1. Select Insert > SmartArt.
  2. In the SmartArt graphic chooser, select Hierarchy and choose an organization chart layout. Select OK.
  3. Select the arrow on the left edge of the graphic to open its text pane if the pane is not already visible. Enter a name or position for each box.
  4. Use Enter to add another item at the same level in the text outline. Use Tab to make an item a subordinate of the item above it, and Shift+Tab to promote it one level.
  5. Review the chart, then use the SmartArt Design and SmartArt Format tabs to adjust the layout and appearance.

For example, enter a director first, then add two department heads at the same level. Under the first department head, demote the names of that person’s team leads; under each team lead, add their direct reports. The indentation in the text pane represents the hierarchy, so check that each person is nested under the correct manager before sharing the result.

You can also select a box and use SmartArt Design > Add Shape to insert a position relative to it. The available options depend on the selected shape and layout; an organization chart can include an assistant position as well as subordinate or peer positions. This approach can be easier than editing the text outline when adding one box to a chart that is already arranged.

Plan the reporting structure first

It is easier to build an accurate chart when the reporting relationships are settled before formatting begins. A simple source table can help you check the structure, even though it will not automatically drive the SmartArt graphic. Useful columns include employee name, job title, manager, department, and location. For example, a table might list Jordan Lee as a department head with no manager in the displayed department, and list Sam Patel with Jordan Lee as manager.

Decide what the chart is meant to communicate. A chart for a small department may show every employee, while an executive overview may show only senior leaders and department heads. If the company has dotted-line relationships, project leads, or shared reporting, decide whether to show those links or explain them in a note. A conventional org chart generally emphasizes primary reporting lines; trying to display every collaboration can make it difficult to read.

  • Use consistent job-title wording and spelling.
  • Choose whether to display people, positions, or both.
  • Check that each person has the intended manager and that there are no accidental duplicate entries.
  • Set a clear scope, such as one business unit or the whole organization.

For privacy, include only information appropriate for the audience. Names and job titles may be suitable for a staff directory, while personal contact details or sensitive personnel information usually do not belong in a broadly shared chart.

Format the chart for readability

SmartArt Design offers ways to change the layout, colors, and visual style. SmartArt Format provides options for working with individual shapes, such as changing their fill or text formatting. Keep the design restrained: consistent box sizes, readable type, and clear contrast usually matter more than decorative effects. A chart that looks attractive on a large monitor can become unreadable when printed or inserted into a presentation.

Organization charts can become very wide or tall as more levels and teams are added. Consider splitting a large organization into separate charts by department, or creating an overview that links to more detailed team charts. If the chart must fit on paper, check the print preview and use Page Layout settings to choose a suitable page orientation and scaling. Excessive shrinking may technically fit the chart on one page but make names too small to read.

Use meaningful text in each box, often a name on one line and a role on another. Do not rely on color alone to communicate status or department; readers may print in grayscale or have color-vision differences. If the workbook will be used digitally, add a clear title and any necessary notes so readers understand the chart’s scope and date.

Keep it accurate as people and roles change

SmartArt can be edited after creation, but it does not continuously refresh from an employee list. When someone changes teams, update the chart itself and verify the related positions. A useful maintenance habit is to include an as-of date or version note and identify who owns the chart. That helps readers distinguish a current reporting structure from an old copy saved or emailed earlier.

For a chart that changes often, keep a separate, well-maintained source table and compare it with the diagram during updates. A manager column makes reporting relationships easier to review than relying on memory. You can also keep one row per position or employee, depending on whether the chart represents actual people or the organization’s planned roles. Before distribution, check that departures, vacant positions, newly created teams, and temporary assignments are handled consistently.

When several people edit the workbook, agree on one authoritative copy and a review process. Excel’s collaboration and file-sharing features can help people work on a workbook, but collaboration does not eliminate the need to verify the diagram’s reporting lines. If a chart is copied into another document, remember that the copy may not update when the workbook changes.

Common problems and limitations

A frequent source of confusion is expecting Excel to create a hierarchy from a flat list. A table containing names and manager names is useful source data, but SmartArt does not automatically read that relationship and rearrange its boxes whenever the table changes. If automatic generation and ongoing synchronization are essential, consider a dedicated diagramming or HR system rather than treating a manually maintained SmartArt graphic as a live database.

  • Text does not fit: Shorten unnecessary wording, increase the chart’s available space, or split a large chart into smaller views.
  • A person appears at the wrong level: Check the text pane’s indentation or select the box and use the appropriate Add Shape or layout controls.
  • The diagram is hard to print: Preview the page, adjust orientation and scaling, or print separate department charts.
  • Changes are missing in another file: A pasted chart may be a snapshot rather than a live link. Update the destination copy or use a sharing method that preserves the source workbook.
  • The structure is too complicated: Show primary reporting lines in the org chart and explain matrix or dotted-line relationships separately.

SmartArt is also less flexible than a freeform diagram when boxes need unusual positions, custom connections, or nonstandard reporting relationships. You can create a more tailored diagram with shapes and connectors, but manual positioning takes longer and requires care when the structure changes. Neither approach should be mistaken for an official HR record unless the organization has established that process.

SmartArt, shapes, or another tool?

SmartArt is a practical choice when you want a quick, conventional hierarchy and expect only occasional edits. It helps maintain a consistent diagram structure and is generally easier to revise than a chart built entirely from individual shapes. For a small team, it may be all that is needed.

Drawing with shapes can make sense when the chart needs a custom layout, special notes, or visual relationships that SmartArt cannot represent cleanly. In Excel, use Insert > Shapes to add boxes and connector lines, then arrange them with the alignment and positioning controls. This gives you more control, but adding or moving a manager may require manually adjusting several boxes and connectors.

For larger or frequently changing organizations, a dedicated diagramming application or organizational system may be a better fit. Such tools may offer data import or more specialized chart features, but capabilities vary by product and plan. Check that the specific tool supports your data source, update process, access controls, and export needs before choosing it. Excel remains useful for preparing or reviewing the underlying employee list, even if another application produces the final diagram.

Cost and sharing considerations

SmartArt is included in Excel, so creating a basic chart does not require buying a separate org-chart add-in. Access to Excel itself depends on the Microsoft 365 subscription or license available to you. A custom SmartArt diagram also avoids the separate learning curve of adopting a new application, though the time required to manually maintain it can become significant as the organization grows.

When sharing, consider whether recipients need to edit the chart or only view it. Keep an editable workbook as the source and export or copy a view for audiences who need a fixed snapshot. Store the workbook in an approved location and limit access when the chart contains internal personnel information. A password or link setting is not a substitute for following your organization’s data-handling rules.

Frequently Asked Questions

Does Excel have an org chart template?
Excel includes SmartArt organization chart layouts under Insert > SmartArt > Hierarchy. These give you a ready-made diagram structure, but they are not the same as a template that automatically imports employee-manager relationships from a table.

Can Excel make an org chart automatically from a list?
Not with SmartArt alone. You can use a worksheet table to organize names and manager relationships, then build or update the hierarchy in the SmartArt text pane. For automatic data-driven diagrams, look for a tool that explicitly supports importing and refreshing that kind of source data.

How do I add a manager or subordinate?
Select the relevant box and use SmartArt Design > Add Shape to choose a position relative to it. You can also edit the text outline: Enter adds an item, while Tab and Shift+Tab change its level in the hierarchy.

Can I make an org chart in Excel for Mac?
Excel for Mac also supports SmartArt and hierarchy graphics, though ribbon placement and wording can differ from Windows. Look for SmartArt under the Insert tab, choose a hierarchy layout, and use the SmartArt-specific tabs that appear to edit and format it.

What is the best way to handle a very large org chart?
Use an overview plus smaller department charts, or choose a diagramming or organizational tool designed for frequent, large-scale updates. Trying to fit every employee into one Excel graphic can make the chart unwieldy on screen and unreadable in print.

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.