Microsoft Excel Org Chart Template: Create and Customize

Charts & pivot tables · Updated November 20, 2026

To get a Microsoft Excel org chart template, open File > New and search for organization chart; available templates can vary. To make one directly in Excel for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy > Organization Chart, then enter the reporting structure in the text pane.

Where to find an Excel org chart template

Excel offers two practical starting points: a downloadable workbook template, if one appears in the template gallery, or a SmartArt organization chart created inside a blank workbook. In Excel, select File > New and search for organization chart or org chart. The gallery may show Microsoft templates or other available options. Template selection can differ by account, region, and the templates currently offered online, so a particular file is not guaranteed to appear.

Before downloading a workbook from another source, check that it is an Excel file from a source you trust. A basic chart usually does not need macros. If a template asks you to enable macros or includes unfamiliar external links, consider whether those features are necessary before enabling them. You can also start with a blank workbook and use SmartArt, which avoids relying on a particular template download.

A template is a starting layout, not a special kind of live organization database. Many templates contain shapes, connectors, or sample text that you replace yourself. SmartArt is useful when you want a quick diagram that stays together as one graphic; a worksheet built from cells and shapes may suit you better if the chart must be highly customized.

Build a chart with SmartArt

In the Windows desktop version of Excel for Microsoft 365, create a blank workbook and follow these steps:

  1. Select Insert > SmartArt. In the SmartArt dialog, choose Hierarchy, select Organization Chart, and click OK.
  2. Select the chart and open its text pane if it is not already visible. Enter one person per bullet, using the text-pane hierarchy to show who reports to whom.
  3. Use Enter in the text pane to add another entry at the same level. Use Tab to make an entry a subordinate of the preceding person, and Shift+Tab to move it up a level. Check the diagram as you work; the text pane’s indentation determines the reporting levels.
  4. To add a person in a particular place, select the relevant shape and use SmartArt Design > Add Shape. Depending on the position you need, choose an option such as adding a shape after or before the selected one, above it, or below it.
  5. Save the workbook with a clear file name. Windows uses Ctrl+S to save; on a Mac, use Command+S.

The contextual SmartArt Design and Format tabs appear when the SmartArt graphic is selected. If you do not see them, click the chart rather than a worksheet cell. Excel’s Mac ribbon has comparable SmartArt controls, though their placement and dialog details can differ by release. Excel for the web may not offer the same full set of creation and editing controls as desktop Excel; use the desktop app for a complex chart or when a command is missing.

Prepare the reporting information first

A short plan prevents much of the rearranging that makes a chart hard to read. Before entering names, decide what the chart is meant to communicate: formal reporting lines, a project team, or a department directory. Those are different views. A project lead may coordinate people who report to someone else, and forcing both relationships into one hierarchy can mislead readers.

For a straightforward reporting chart, gather each person’s display name, job title, and direct manager. Confirm spelling and titles, and agree on how to show vacancies, contractors, or interim assignments. Keep one person’s manager clear; a basic organization chart represents a hierarchy, not every collaboration or dotted-line relationship. If you need to distinguish those other relationships, label them carefully or use a separate diagram.

For example, a small sales team might have a regional director at the top, two managers beneath that director, and several representatives under each manager. Enter the director first, then each manager as a subordinate, then the relevant representatives beneath their own manager. Adding representatives under the director by mistake changes the meaning even if the names are all present.

Customize layout and appearance

Once the reporting levels are correct, select the SmartArt graphic and use SmartArt Design to choose a layout or style. The available hierarchy layouts can arrange subordinate boxes in different ways. A layout that fits a wide department may be too broad for a printed page, while a compact chart may leave too little room for long titles. Preview options and check the whole chart rather than judging one branch in isolation.

SmartArt styles and color choices can improve contrast and help distinguish levels, but restrained formatting is usually easier to scan. Use consistent text sizes, avoid relying on color alone to communicate status, and keep names and titles in a predictable order. If the chart is intended for printing, use Page Layout settings to check paper size, orientation, and print area, then inspect File > Print preview. A chart that looks clear on a large monitor may become unreadable when reduced to fit one page.

Long names, multiple titles, and large teams can cause boxes to grow or the chart to become crowded. Shorten wording only when doing so remains accurate; do not abbreviate job titles in a way readers may misunderstand. Consider splitting a large organization into separate department charts, with clear labels showing the scope of each chart, instead of shrinking every box to fit.

What SmartArt can and cannot do

SmartArt is a diagram, not a live organizational database. Typing a name into a worksheet table does not automatically update a separate SmartArt chart, and changing a chart box does not necessarily update a source list elsewhere in the workbook. That distinction matters if the organization changes frequently or if the chart is used for official records.

SmartArt works well for a stable, modest-size structure that needs to be presented visually. It lets you add, remove, and rearrange entries without drawing every connector from scratch. However, it is less suited to very large hierarchies, frequent automated refreshes, or complex matrix reporting. Before distributing a chart, compare it with an authoritative staff list and confirm that the reporting lines reflect the date and purpose stated on the sheet.

If you keep a separate employee table, record a unique identifier and a manager identifier rather than relying only on names. Names can be duplicated or changed. Excel can help store and filter that table, but building a correct, automatically refreshed hierarchy from it requires more setup than inserting SmartArt. Do not imply that a manually maintained diagram updates itself simply because its source names also exist in cells.

Common problems and fixes

  • The chart is missing a person: Open the text pane and compare its entries with the source list. A shape may be off-screen or omitted from the hierarchy.
  • A person appears at the wrong level: Check the text-pane indentation and use Tab or Shift+Tab to change the level. Selecting a shape and using the Add Shape commands can also place a new entry relative to it.
  • The chart is too wide: Try another hierarchy layout, shorten nonessential wording, or split the chart into labeled sections. Widening the worksheet columns does not necessarily resize the SmartArt boxes in the way expected.
  • Text is hard to read: Avoid shrinking the whole graphic to fit a page. Use landscape orientation, a larger print size, or multiple pages, and check Print preview.
  • Formatting changes unexpectedly: Select the SmartArt graphic and use its SmartArt tabs rather than applying worksheet formatting to nearby cells. If appearance is critical, save a separate copy before extensive changes.

Undo is available for recent edits: use Ctrl+Z in Windows Excel or Command+Z on Mac. Undo is not a substitute for saving a backup, particularly before making major structural changes or converting a graphic into separately editable objects.

Excel compared with other options

Excel is convenient when the chart belongs with a roster, planning workbook, or other spreadsheet information. SmartArt is quick to create and straightforward to edit, but its visual and data-management options are limited compared with dedicated diagramming software.

PowerPoint can be a better fit when the main goal is a presentation slide, especially if the chart needs more free-form positioning. Visio is designed for diagramming and may suit larger or more specialized organizational diagrams, depending on the features available in the user’s license. Dedicated diagramming tools can offer additional layout controls, but check their sharing, export, and data-handling requirements before choosing one. Excel, PowerPoint, and Visio availability and cost depend on the Microsoft plan or license; there is no single price that applies to every user. If you already have Excel, SmartArt is often the simplest option for a basic chart.

Frequently Asked Questions

Does Excel have a built-in org chart template?
Excel may show organization-chart workbooks in File > New, but the gallery contents can change. The built-in SmartArt route is a dependable way to create a chart without finding a separate template file: choose Insert > SmartArt > Hierarchy > Organization Chart.

How do I add a manager or employee to an Excel org chart?
Select the relevant SmartArt shape, then use SmartArt Design > Add Shape and choose where the new shape should go. You can also edit the text pane and adjust the entry’s level with Tab or Shift+Tab.

Can an Excel org chart update automatically from a list?
A standard SmartArt organization chart is not automatically linked to a worksheet roster. If the roster changes, you generally need to update the chart yourself or build a separate process designed to generate and maintain the diagram.

Can I make an org chart in Excel for the web?
Web capabilities can differ from the desktop app and may not expose every SmartArt editing option. If you cannot create or adjust the hierarchy you need, open the workbook in desktop Excel and make the changes there.

Is Excel or Visio better for an organization chart?
Excel is suitable for a simple chart kept alongside spreadsheet data. Visio is a diagramming-focused option that may be more appropriate for large or specialized diagrams; consider your license, collaboration needs, and how often the chart must be maintained.

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.