Org Chart in Excel: How to Create, Format, and Update

Charts & pivot tables · Updated November 19, 2026

Yes. In Microsoft Excel for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy > Organization Chart, then enter employees and arrange them by reporting level. SmartArt is the quickest way to make a visual org chart; the key is to enter the reporting relationships correctly and remember that the chart does not automatically stay connected to a separate employee list.

What an Excel org chart can show

An organizational chart, or org chart, represents how people or roles relate within a team. Its connectors typically show who reports to whom, while boxes can include names, job titles, departments, or other brief details. A simple chart might put a department head at the top, managers on the next level, and each manager’s direct reports below.

Excel is useful when you want a chart alongside other workbook information, need a visual for a meeting, or want to make a modest hierarchy without switching applications. It can also be practical for a team roster that changes occasionally. It is less suited to a very large, frequently changing organization if you expect the picture to rebuild itself automatically from a staff table.

There are two common approaches: use SmartArt’s built-in organization chart layout, or draw boxes and connectors yourself. SmartArt handles hierarchy and spacing for you. Manual shapes allow more freedom in appearance, but require more work to keep aligned when reporting lines change.

Prepare the reporting structure first

Before opening SmartArt, decide what the boxes and lines should mean. A reporting chart is not necessarily the same thing as a project team diagram, a department directory, or a list of everyone who collaborates. Keeping the purpose clear helps avoid showing relationships that the chart cannot explain.

Make a clean source list with one person or role per row. Useful fields include employee name, job title, and the name or identifier of the direct manager. For example:

  • Jordan Lee — Operations Director — no manager listed
  • Amir Patel — Warehouse Manager — Jordan Lee
  • Casey Morgan — Inventory Coordinator — Amir Patel
  • Riley Chen — Delivery Manager — Jordan Lee

This list makes the intended hierarchy easier to check, but it does not automatically generate or control a SmartArt chart. For the example, Jordan is at the top; Amir and Riley are peers beneath Jordan; Casey is beneath Amir. Confirm that each person has the correct manager and that the structure has no accidental loops or unexplained duplicate entries.

Create an org chart with SmartArt

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

  1. Open the worksheet where the chart should appear and select a blank area. Leave enough room for the graphic to expand.
  2. Choose Insert > SmartArt. In the SmartArt gallery, select Hierarchy, choose Organization Chart, and select OK.
  3. Click the text pane control at the edge of the SmartArt graphic if the text pane is not already visible.
  4. Enter the top person or role first. Press Enter to add another item at the same level, and use Tab to make an item a subordinate of the item above it. Use Shift+Tab to promote an item to a higher level.
  5. Review the outline and check that every subordinate is indented beneath the correct manager. Close the text pane when the structure is in place.

In the example, enter Jordan first. Add Amir and Riley as the next-level entries, then add Casey as a subordinate of Amir. The text pane’s indentation is what defines the hierarchy; typing names in a particular visual order without setting their levels will not establish the reporting lines correctly.

Excel for Mac also provides SmartArt from the Insert tab, with Hierarchy layouts and an Organization Chart option. The ribbon and dialog arrangement can differ slightly by update, but the basic workflow is the same: insert the hierarchy graphic, enter the outline, and use the SmartArt design controls. Excel for the web may have a different set of editing options, so use the desktop app if a control in the instructions is not available in your browser.

Edit levels, roles, and reporting lines

To revise an existing SmartArt chart, select the graphic and edit the text in its text pane, or click an individual shape and change its text. In the text pane, Enter adds another item at the current level. Tab demotes the selected outline item; Shift+Tab promotes it. Check the resulting diagram after changing levels, since promoting or demoting an item can alter the relationships of items around it.

You can also add a shape from the ribbon. Select the relevant box, then choose SmartArt Design > Add Shape. The menu offers choices such as adding a shape after or before the selected one, above it, or below it; the available commands depend on the selected shape and layout. For example, use Add Shape Below to add a direct report to a selected manager. Use the text pane when you need to reorganize several levels, since the outline makes the structure easier to inspect.

To remove a person, select their shape and press Delete, or remove their entry in the text pane. Before deleting a manager, decide what should happen to their direct reports: those employees may need to be moved under another manager rather than removed with the old reporting line. A chart can look tidy while still being inaccurate, so compare it with the source list after substantial edits.

Format the chart for readability

Select the SmartArt graphic to reveal its contextual tabs, including SmartArt Design and Format. SmartArt Design includes layout and style options; Format offers controls for selected shapes, such as shape fill and outline. A restrained design is usually easier to read than a different color, border, or font treatment for every box.

Helpful formatting choices include:

  • Use consistent box sizes and text styling for people at the same level.
  • Put names and titles on separate lines when that makes each box easier to scan. Edit the shape text directly and adjust its size if the text wraps awkwardly.
  • Use color to identify meaningful groups, such as departments, and add a short key if the colors might not be obvious.
  • Choose a layout that gives long names room and keeps the reporting lines easy to follow.
  • Increase the graphic’s size or reduce unnecessary wording rather than shrinking text until it is difficult to read.

SmartArt applies layouts and styles to the graphic as a whole, which helps maintain consistency but can limit fine control. If one box needs an unusual size or position, first see whether another hierarchy layout solves the problem. Extensive one-off adjustments can be lost or become awkward when the hierarchy changes.

Know the limits of SmartArt

The most important limitation is that SmartArt is a visual object, not a live view of an employee database. If a person’s manager changes in a worksheet table, Excel will not automatically move that person’s SmartArt box. You must update the chart yourself. Similarly, editing a name in the chart does not necessarily update a separate roster.

SmartArt is a good fit when the hierarchy is relatively small, changes are occasional, and the chart’s purpose is clear. It may become cumbersome when the organization has many levels, hundreds of people, multiple reporting relationships, or regular personnel updates. A conventional org chart usually shows one primary reporting line per person; matrix organizations, where someone reports to multiple leads, need a legend or a different diagram so the lines are not misleading.

Another common misconception is that sorting a staff table will produce a reporting hierarchy. Sorting can order rows by department or manager name, but it does not by itself create the parent-child relationships or visual connectors. A clear manager field is useful source data, yet a separate step or tool is still needed to render and maintain the chart.

SmartArt, manual shapes, or another tool?

Choose the method based on how often the structure changes and how much visual control you need:

  • SmartArt: Best for a straightforward hierarchy that should be quick to build and easy to restyle. Its built-in organization layout keeps branches connected as you edit the outline.
  • Shapes and connectors: Useful for a small diagram that needs custom placement, extra annotations, or a design that SmartArt cannot provide. On the Insert tab, Excel provides Shapes; you can draw rectangles and connector lines, but must realign them when boxes move.
  • A dedicated diagramming or HR system: Consider this when the chart is large, changes frequently, or must be generated from maintained employee records. Check whether the specific product supports your organization’s data source and permissions before relying on automatic updates.

Excel can hold the source roster and a SmartArt graphic in one workbook, but keeping both consistent takes an explicit process. For example, designate the roster as the authoritative record, review it before each chart update, and check names and manager relationships after editing the graphic. That small routine is often more dependable than assuming the visual object will synchronize on its own.

Print, share, and maintain the workbook

Org charts often become hard to read when printed because a wide hierarchy is scaled to fit a single page. Use File > Print to preview the result. If the chart is clipped, adjust the worksheet’s print area or page orientation, or scale the content appropriately. On the Page Layout tab, review options such as Orientation and Scale to Fit. Avoid scaling the page so far down that names become illegible; a wider page or multiple pages may be better.

Keep the chart on a dedicated worksheet if it competes with tables or calculations. Add a visible title and, where needed, a date such as Updated November 2026 so readers know when the information was reviewed. If the workbook is shared, make sure collaborators know whether they should edit the roster, the chart, or both. A short note explaining that the chart is manually maintained can prevent someone from treating an outdated graphic as current.

For external sharing, consider whether employee names, roles, or reporting lines are appropriate to disclose. Excel does not determine whether a particular chart should be shared; follow your organization’s data-handling and access rules. A PDF can be convenient for viewing, but it is a snapshot rather than an editable source, so retain the workbook if later updates are expected.

Frequently Asked Questions

Can Excel create an org chart automatically from a table?
Not with the standard SmartArt organization chart workflow. You can use a table as a reference, but you must build or update the SmartArt hierarchy yourself. If automatic generation and synchronization are essential, look at a diagramming or HR tool that explicitly supports your data source.

How do I add a subordinate in Excel SmartArt?
Select the manager’s shape and choose SmartArt Design > Add Shape > Add Shape Below. You can also add an entry in the text pane and indent it with Tab so that it sits beneath the correct manager.

Can I put a job title under each name?
Yes. Edit the shape text and include both the name and title, usually on separate lines. Keep the wording concise, then check the layout and font size to ensure that the box remains readable.

Can one employee appear under two managers?
A standard organization chart is designed to show a straightforward hierarchy, typically with one parent position for each subordinate. For a matrix structure, consider a separate relationship diagram or clearly label secondary reporting lines so viewers do not confuse them with primary management.

Why did my chart not change when I edited the employee list?
SmartArt is not automatically linked to a separate worksheet roster. Update the names and reporting levels in the graphic, then compare it against the roster to confirm that the two match.

Can I make an org chart in Excel for Mac?
Yes. Excel for Mac includes SmartArt hierarchy graphics. Use the Insert tab to add an Organization Chart, then edit its outline and format it with the contextual SmartArt controls; some ribbon details can vary by version.

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.