Microsoft Excel Org Chart Add-Ins and Built-In Options

Charts & pivot tables · Updated November 20, 2026

Microsoft Excel for Microsoft 365 does not require an add-in to make a basic org chart: use the built-in SmartArt Organization Chart. An add-in may help if you need extra design, collaboration, or automated data handling, but SmartArt itself does not automatically keep a chart synchronized with an employee list in cells.

Does Excel have an org chart add-in?

Excel includes an organization-chart layout as part of SmartArt, so many people searching for an “Excel org chart add-on” are looking for a feature that is already available. In Excel for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy > Organization Chart. You can then enter names and job titles in the graphic or its text pane.

That built-in option is not the same as a separate add-in. An Office add-in is an optional extension, usually obtained through Microsoft’s add-in catalog or an organization’s administrator. Add-ins are made by different publishers and may offer features such as templates, imports, or sharing. Their names, prices, and availability can change, so check the listing and publisher rather than assuming every result is a Microsoft product.

There is also a different category called Excel add-ins, which can include files that extend Excel’s calculations or automation. These are not necessarily visual org-chart tools. In short, start with SmartArt for a small, manually maintained chart; look for an add-in or a separate diagramming product when you have a specific need SmartArt cannot meet.

Make a basic org chart with SmartArt

SmartArt is a good fit for a team chart that has a manageable number of people and does not need a live connection to a personnel system. To create one in Excel for Microsoft 365 on Windows:

  1. Open the worksheet where you want the chart, then select Insert > SmartArt.
  2. In the SmartArt gallery, choose Hierarchy, select Organization Chart, and select OK.
  3. Enter a name and role in the first box. Use the SmartArt text pane to enter additional names, with indentation showing reporting levels.
  4. Select the graphic and use the SmartArt Design tab to add shapes, change the layout, or apply a style. Use Shape Format for options such as fill, outline, and text formatting.

To add a person, select the shape that should be related to the new one and choose SmartArt Design > Add Shape. The menu offers placement choices such as adding a shape after or before the selected one, adding a subordinate, or adding an assistant. The choice matters: a subordinate is placed below a manager, while a colleague at the same level belongs beside that manager.

You can also use the text pane to adjust the hierarchy. In that pane, Enter adds another entry, while Tab and Shift+Tab can change an entry’s level. Check the resulting chart after changing indentation, especially if it contains several reporting layers. On Excel for Mac, SmartArt is also available from the Insert tab, although ribbon labels or arrangement can vary by release. Excel for the web may have a different selection of editing commands; if a command is missing, open the workbook in the desktop app.

What SmartArt can and cannot do

SmartArt gives you a visual hierarchy without requiring a separate diagramming program. It is convenient for a department overview, a project team, or a presentation-ready chart that changes occasionally. You can resize the graphic, choose among hierarchy layouts, and format it to fit a worksheet or a printed page.

The key limitation is that a SmartArt org chart is a graphic, not a live report built from an employee table. If you change a manager’s name in a worksheet cell, that change will not automatically update the corresponding SmartArt shape. Likewise, SmartArt does not by itself validate that every employee has one manager, identify duplicate employee records, or fetch current job information from a company directory. Keep the source list and graphic consistent by updating both, or use a workflow designed to import and refresh data.

This distinction helps avoid a common misconception: because the chart is inside Excel, it is not necessarily linked to the workbook’s rows and columns. SmartArt can be edited in Excel, but that does not make it a data-connected chart.

When an add-in is worth considering

An add-in becomes more attractive when the chart is large, changes often, or needs capabilities beyond styling. Depending on the product, an org-chart tool may offer a guided editor, employee-data import, profile information, shared editing, or export options. These features are product-specific; confirm them in the current listing and documentation before choosing an add-in.

Consider a human-resources workbook with 250 employees and columns for employee ID, name, title, and manager ID. Rebuilding a SmartArt graphic each time reporting lines change would be tedious and prone to mistakes. A tool that supports importing those fields and regenerating a hierarchy could save work. But if the chart is a simple six-person team that changes once a year, installing and learning an add-in may add more overhead than value.

For an organization-wide chart, also ask whether the proposed tool can handle vacant roles, multiple locations, long titles, and privacy restrictions. A quick demonstration using a copy of representative data is more useful than choosing based only on a gallery image.

Find and install an Office add-in

In Excel for Microsoft 365 on Windows, look for Insert > Get Add-ins to browse available Office add-ins. Depending on the Excel build and account, you may also see My Add-ins for add-ins already associated with your account. Search for terms such as “organization chart” or “org chart,” then inspect the publisher, description, compatibility notes, and permissions shown for each result.

Work or school accounts may be managed by an administrator. The administrator can restrict which add-ins are available, and an organization may provide an approved catalog instead of allowing users to install items freely. An add-in that is unavailable in your catalog is not necessarily broken; it may be blocked by policy or unsupported for your account or platform.

Do not confuse the Office add-in catalog with the Excel add-ins list. To inspect traditional Excel add-ins on Windows, use File > Options > Add-ins. That page is primarily for managing Excel add-ins, including some that provide commands or analysis features; it is not a dedicated org-chart marketplace. On Mac, add-in management and catalog access may appear in different ribbon or application menus, so follow the commands shown in your current Excel release.

How to choose an org-chart tool

Before installing anything, decide what the chart must do. A short requirements list makes it easier to compare SmartArt, add-ins, and separate diagramming software without paying for features you will not use.

  • Data source: Does it accept a spreadsheet, and which columns or identifiers does it require? Can it refresh a chart after edits, or does each update require a new import?
  • Chart complexity: Can it display assistants, vacant positions, multiple departments, or people with more than one reporting relationship in the way your organization needs?
  • Output: Can you keep the chart in the workbook, print it legibly, or export it in the file format your audience needs?
  • Compatibility: Does it work with your Microsoft 365 account, Windows or Mac version, and Excel for the web if your team uses a browser?
  • Administration and support: Who maintains the add-in, how are updates handled, and can your IT team approve it?
  • Total cost: Check whether the product is free, subscription-based, charged per user, or subject to a separate license. A free installation may still have paid features or usage limits.

Try a small, non-sensitive sample first. Confirm that the import produces the reporting relationships you expect, and test what happens when a manager changes or a row is removed. This catches mapping problems before you rely on the tool for a complete organization chart.

Alternatives for larger or frequently updated charts

If SmartArt is too manual, a dedicated diagramming product may be a better fit than an Excel add-in. Microsoft Visio is one option for creating diagrams, including organization charts, and some diagramming products can import structured data. Licensing, import capabilities, and the exact steps depend on the product and plan, so check current requirements before building a process around one.

Another option is to keep the authoritative employee list in an approved business system and generate or publish the chart from that source. This can reduce duplicate updates, but it may require IT support and careful decisions about who is allowed to see employee details. For a one-time chart, a separate presentation or diagram file may be simpler than adding a data-refresh workflow to Excel.

Choose the source of truth deliberately. If Excel is only a copy of information maintained elsewhere, decide who updates the workbook and how often it is refreshed. If the chart is used for decisions, include an “as of” date so readers know whether the reporting lines are current.

Common problems and practical fixes

The chart becomes crowded: A single hierarchy can grow wider than a worksheet page. Try a different SmartArt layout, enlarge the chart, shorten nonessential text, or split the organization into department-level charts with a clear link to the full structure. Avoid shrinking text until it becomes unreadable.

A new shape appears in the wrong place: Select the intended manager or colleague before using SmartArt Design > Add Shape, then choose the appropriate relationship. If the hierarchy is still wrong, adjust the entry’s indentation in the text pane and inspect the result.

The chart does not change when cells change: That is expected for a manually created SmartArt graphic. Update its text separately or use a tool that explicitly supports importing and refreshing data. Do not assume that selecting a cell range creates a continuing link to SmartArt.

The add-in is missing or will not load: Check that you are signed in with the expected Microsoft account, confirm that your Excel version and platform are supported, and ask your administrator whether add-ins are restricted. If a workbook will be shared, test it on the recipients’ setup too; an add-in available to one user may not be installed or permitted for everyone.

Privacy, permissions, and cost

Organization charts can reveal names, roles, reporting lines, and sometimes sensitive details. Before using an add-in, read its privacy information and the permission prompt. Determine whether data is processed locally or sent to an external service, who can access stored charts, and how the provider handles deletion. Use fictional or anonymized records while evaluating a tool, and follow your organization’s data-handling rules.

SmartArt is included as a built-in Excel feature, so it does not require a separate org-chart add-in purchase. Third-party add-ins may be free, paid, or limited to a trial, and prices or plan features can change. A separate diagramming product may have its own license requirements. Compare the complete cost with the time saved, especially if only one person will create the chart or updates are rare.

Frequently Asked Questions

Is there a free org chart maker in Excel?
Yes. Excel’s built-in SmartArt includes an Organization Chart layout, so you can create a basic chart without installing a separate add-in. SmartArt is not a live, automatically refreshed view of an employee table.

Can I create an org chart from an Excel employee list?
SmartArt does not automatically turn a cell range into a maintained org chart. You can enter the names and reporting levels manually, or look for a tool whose current documentation specifically supports importing your list and mapping manager relationships.

Can Excel automatically update an org chart when an employee changes?
Not when the chart is a standard SmartArt graphic. Update the graphic yourself, or use a data-connected tool that supports refreshes and test its behavior with your own workbook structure.

Do I need Visio to make an org chart in Excel?
No. SmartArt is enough for many basic charts. Visio or another diagramming product may be useful for a larger or data-driven chart, but it is a separate option rather than a prerequisite for Excel’s built-in layout.

Why can’t I install an org-chart add-in?
Your account administrator may limit add-ins, the product may not support your platform or Excel version, or it may no longer be listed. Check the catalog and compatibility information, then ask your organization’s administrator if the account is managed.

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.