Does Excel Have an Org Chart Template? What to Know

Charts & pivot tables · Updated November 19, 2026

Yes. Excel for Microsoft 365 on Windows includes an Organization Chart layout in SmartArt, which you can use to build a hierarchy directly in a worksheet. You can also look for downloadable workbook templates, but what appears in Excel’s template gallery can vary; the built-in SmartArt option is the dependable starting point.

What Excel provides for organization charts

Excel’s built-in option is a SmartArt graphic, not a standard chart such as a column or pie chart. The Organization Chart layout is part of the Hierarchy category. It represents reporting relationships with boxes connected by lines, so you can show who reports to whom and include details such as a person’s name, role, or department.

SmartArt is useful when you want a visual hierarchy without drawing every box and connector yourself. It provides a structured layout and tools for adding, removing, and rearranging positions. It is not the same as a database-backed organization chart: by default, the names and titles in the graphic are entered into the SmartArt object, rather than automatically linked to a separate employee table.

Excel may also show templates in its New workbook screen, and Microsoft’s online template offerings can change over time. Searching there for organization chart or org chart is worth trying if you want a preformatted workbook. However, a gallery result is not guaranteed to appear in every installation, account, or region. If you simply need to make a chart, you do not need to find a separate template first.

How to insert an organization chart in Excel

In Excel for Microsoft 365 on Windows, start with a blank worksheet or the workbook where the chart should live. Use the ribbon path Insert > SmartArt > Hierarchy, then select Organization Chart and choose OK. The chart is inserted on the sheet as a movable graphic.

To enter the first names and positions, click a shape and type, or open the SmartArt Text Pane using the small arrow at the left edge of the graphic. The text pane presents entries as an indented outline: entries at the same level are peers, and indented entries are subordinate to the item above them. You can use this outline to build a basic structure before refining the design.

A practical first pass looks like this:

  1. Enter the leader or top role in the first box.
  2. Add direct reports as items at the next level.
  3. Add each person’s reports beneath that person, keeping the outline’s indentation consistent with the reporting structure.
  4. Review the chart from top to bottom to check that each reporting line is represented correctly.

When the SmartArt graphic is selected, Excel displays contextual SmartArt tabs, including SmartArt Design and Format. If those tabs are not visible, click the graphic once. On Excel for Mac, SmartArt is also available from the Insert tab, though ribbon placement and the appearance of controls can vary slightly by release. Excel for the web may not offer the same full set of SmartArt creation and editing controls as the desktop app; if a needed command is missing, open the workbook in desktop Excel.

Adding people and changing reporting levels

After inserting the first graphic, select a box and use SmartArt Design > Add Shape to add another position. The menu offers choices such as adding a shape after or before the selected one, above it, or below it. The exact choices depend on which box is selected. For a typical reporting chart, adding a subordinate below a manager creates a lower-level role; adding a colleague at the same level creates a peer.

You can also manage the hierarchy from the Text Pane. Pressing Enter in the outline adds an entry, while Tab and Shift+Tab change an entry’s indentation level in many SmartArt text-editing contexts. Check the resulting chart rather than relying on indentation alone, especially when reorganizing several levels. A small shift in level can change the implied reporting relationship.

To remove a position, select its shape and delete it, or remove its entry in the Text Pane. Before doing so, check whether the box has subordinate positions: deleting a manager can also affect the way the lower-level entries are arranged. If you are making a substantial restructure, save a copy first so you can compare or restore the earlier version.

Formatting the chart for readability

SmartArt’s design options can change the graphic’s colors, style, and arrangement. With the chart selected, use SmartArt Design to browse available SmartArt styles and color variations, and use Format for shape-level formatting. The available choices depend on the selected layout and Excel version. A restrained color scheme and consistent text usually make a reporting chart easier to scan than using a different color for every box.

Text length and chart size matter. A chart with short names and job titles may fit comfortably on a worksheet, while long titles, phone numbers, and biographies can make boxes crowded. Consider including only details that help readers understand the structure. If the chart is too wide, try a different layout or split the organization into departments rather than shrinking the text until it is difficult to read.

Excel worksheets are larger than a printed page, so check the result in Print Preview before distributing a paper copy or PDF. Set an appropriate print area if the sheet contains other data, and review page orientation, scaling, and page breaks. A chart that looks clear on screen may become tiny if Excel tries to fit a broad organization onto one page.

SmartArt versus a downloadable Excel template

SmartArt is usually the fastest choice for a modest chart that needs to be created and edited in Excel. It gives you an editable hierarchy and basic styling without requiring a separate file. A downloadable template may be preferable when you want a predesigned worksheet with instructions, a specific page layout, or space for extra fields. Before using one, confirm that it is an Excel workbook and that its layout suits your purpose.

Templates are starting points, not proof that the chart is correct. You still need to check names, job titles, and reporting lines, and decide whether the design is readable when printed or shared. Some files may include extra formatting or features you do not need. If a template contains macros, Excel may display a security warning; do not enable macros unless you trust the file and understand why they are required.

Another option is to draw the chart with ordinary worksheet shapes and connector lines. That offers precise control over each box, but manual diagrams can take longer to build and maintain. Moving one manager may require repositioning multiple boxes and reconnecting lines. For a chart that changes often, the convenience of SmartArt or a purpose-built charting tool can outweigh the control of drawing every object yourself.

What SmartArt does not update automatically

A frequent misconception is that an Excel org chart will automatically stay synchronized with an employee list elsewhere in the workbook. A SmartArt graphic does not ordinarily establish that kind of live connection simply because its text resembles a table. If someone changes a name or reporting manager in a separate list, the chart will not automatically revise itself; you must edit the graphic or use a workflow designed to generate charts from data.

For a small team with occasional changes, updating SmartArt by hand may be entirely reasonable. For a large company or a frequently changing structure, repeated manual edits can introduce inconsistencies. You may want to keep a clearly maintained source list and use a dedicated organizational-chart tool or a data-driven process that supports your organization’s requirements. Confirm that any chosen tool supports the specific Excel version and data format you use.

Also distinguish an organization chart from a staff directory. An org chart communicates hierarchy and reporting relationships; a directory is better suited to searchable details such as email addresses, locations, and phone numbers. Trying to put every directory field into each SmartArt box can make the chart too dense to serve either purpose well.

Choosing the right approach for your chart

Before building anything, consider the chart’s size, how often it changes, and how people will use it. These factors help determine whether SmartArt is enough or whether a different format will save time:

  • Small, stable team: SmartArt is often a straightforward fit for showing a few reporting levels.
  • Large or frequently changing organization: Consider whether manual edits will be manageable and whether a dedicated data-driven option is needed.
  • Presentation or handout: Prioritize readable text, sensible page orientation, and a layout that works at the final viewing size.
  • Directory or contact list: Use a table or directory for detailed contact information, with an org chart as a separate overview if useful.
  • Confidential structure: Decide who should receive the workbook and remove information that recipients do not need.

For example, a small nonprofit could use a top box for its executive director, a row of department leads below, and staff under the relevant lead. If it needs to show volunteers who do not report to a single manager, forcing them into a strict hierarchy may give readers the wrong impression. A team diagram or directory could communicate those relationships more accurately.

Sharing, printing, and protecting information

An organization chart can reveal internal reporting lines, role changes, or team structure. Treat it like other workplace information: share it only with the intended audience, follow your organization’s policies, and avoid adding personal details that are unnecessary for the chart’s purpose. If the workbook contains other sheets or data, check those too before sending the file; hiding a worksheet is not the same as removing its contents.

When sharing a finished chart, consider whether recipients need an editable workbook or only a fixed view. A workbook is useful when authorized colleagues should update the chart. A PDF can be convenient for viewing and printing, but it is not a substitute for keeping an editable source if the structure will change. Check the exported or printed version for clipped text, unreadable scaling, and connector lines that are hard to follow.

Frequently Asked Questions

Is there an org chart template built into Excel?
Excel includes a built-in Organization Chart SmartArt layout. It may also show downloadable templates in its New workbook gallery, but those listings can vary. Use Insert > SmartArt > Hierarchy > Organization Chart if you want to start directly in the worksheet.

Can Excel make an org chart from a list of employees?
SmartArt lets you enter names and arrange them in a hierarchy, but it does not automatically infer reporting relationships from an ordinary employee list. You must represent the hierarchy in the SmartArt text outline or use a separate tool or workflow that builds a chart from structured data.

Can I add a photo to an Excel organization chart?
You can add pictures or other objects to a worksheet, but placing and sizing separate photos alongside SmartArt boxes may require manual formatting. If photos are essential, check that the chosen layout or charting tool supports them cleanly before entering information for a large organization.

Can I edit an Excel org chart in the browser?
Excel for the web can handle many workbook tasks, but SmartArt creation and editing capabilities may differ from desktop Excel. If you cannot find a needed SmartArt command, open the file in the desktop version. Check the web app’s current controls before relying on it for a complex redesign.

Is an Excel org chart the same as a Visio org chart?
No. Excel’s SmartArt layout is a convenient way to create a hierarchy inside a workbook. Visio is a separate diagramming application with its own organization-chart tools and workflows. Which is appropriate depends on the chart’s complexity, maintenance needs, and the software available to you.

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.