Org Chart Program in Excel: Create and Maintain One

Charts & pivot tables · Updated November 20, 2026

Yes. Microsoft Excel for Microsoft 365 can create an organizational chart using SmartArt: choose Insert > SmartArt > Hierarchy > Organization Chart, then enter names and roles. Excel is convenient for a straightforward chart, but its SmartArt diagram is not automatically connected to a staff list, so changes to your source data will not update the chart on their own.

What Excel offers for org charts

Excel does not have a separate, dedicated org-chart wizard. Its built-in option is SmartArt, a collection of diagrams that includes hierarchy layouts. The Organization Chart layout displays reporting relationships as boxes connected by lines. A manager appears above direct reports, while people at the same level can appear alongside one another.

SmartArt works well when the goal is a clear visual for a small or medium-sized team, a presentation, or an internal document. It keeps boxes and connectors together as a diagram, which is generally easier to arrange than drawing every element separately. You can also change the chart’s appearance using built-in color and style options.

There is an important distinction between an org chart and an employee table. A table can hold detailed, filterable records, such as employee IDs, departments, and manager names. SmartArt is primarily a visual diagram. It does not behave like a database or a special Excel chart type that reads reporting relationships from columns. If the structure changes often or includes many people, consider keeping the employee list as the authoritative record and treating the SmartArt chart as a separately maintained display.

Create an org chart with SmartArt

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

  1. On the ribbon, select Insert > SmartArt.
  2. In the SmartArt Graphic chooser, select Hierarchy, choose Organization Chart, and select OK.
  3. Click a box and type a person’s name. Add a job title on another line if that makes the chart easier to read.
  4. Open the Text Pane if it is not visible, then enter the rest of the names and organize them into levels.
  5. Use the SmartArt Design tab to add boxes or adjust the layout, then resize and position the graphic on the worksheet.

The text pane is often the quickest way to build the first draft. Press Enter to create another item at the current level. Press Tab to indent an item and make it a subordinate, or Shift+Tab to promote it to a higher level. Check the result as you go: an indentation mistake can imply that someone reports to the wrong person even when every name is spelled correctly.

You can also select a box and use SmartArt Design > Add Shape. The options include adding a shape after or before the selected item, adding one above or below it, and adding an assistant. Which choice makes sense depends on the selected person’s position and the relationship you need to show. If the SmartArt Design tab is not visible, click the diagram first; SmartArt’s contextual tabs appear when the graphic is selected.

Plan the hierarchy and enter names

Before adding dozens of boxes, decide what the chart is meant to explain. A company-wide view may show executives and department heads, while a team chart may show only one department and its immediate reporting lines. Trying to show every employee in a single view can make labels too small to read. A useful chart shows enough levels to answer the reader’s question without cramming in unrelated detail.

Use consistent labels. For example, a box might show “Maya Chen” on the first line and “Operations Manager” on the second. If the chart is meant to emphasize reporting relationships, avoid adding long descriptions or contact details inside every box. Those details are usually easier to maintain in a separate staff table.

For a simple example, suppose a department has a director, two managers, and four specialists. Put the director at the top, the managers below, and assign two specialists to each manager. This makes the reporting structure visible at a glance. If one specialist supports both managers but reports to only one, place the person under the actual manager and explain the support arrangement separately; a standard hierarchy diagram is not ideal for displaying multiple reporting lines.

Confirm the structure with the person responsible for the information before sharing it. An attractive diagram can still be misleading if a dotted-line relationship is presented as a direct reporting line, or if a vacant role looks like an occupied position. A short note or legend can clarify conventions such as open positions, temporary assignments, or secondary reporting relationships.

Format and position the chart

With the SmartArt selected, use SmartArt Design to explore the layout gallery, change colors, or apply a SmartArt style. Choose a restrained design that keeps the text readable. Strong colors can help distinguish departments, but using a different color for every person adds visual noise and may make the chart harder to interpret when printed in grayscale.

Keep wording and box treatment consistent. Use the same order for names and titles, apply a common font size, and avoid squeezing long job titles into narrow boxes. If the layout becomes crowded, try a different hierarchy layout or divide the chart into related sections instead of shrinking the text until it is difficult to read. SmartArt’s layout choices can arrange lower-level boxes in different ways, so try alternatives before manually moving individual elements.

The graphic sits on the worksheet like an object, so you can move it and resize it. Leave enough space around it for labels and connectors, and check whether it overlaps cells or other content. To prepare a printed copy, review the page in Print Preview. On Windows, Page Layout includes Orientation and the Scale to Fit controls; landscape orientation or fitting the content to one page wide may help, though forcing a large chart onto one page can make the text too small. It can be better to print a large chart over several pages or split it into sections.

Consider accessibility as well as appearance. Make sure the information is not communicated by color alone, use readable contrast, and provide a clear title or brief explanatory note near the diagram. If someone needs the underlying names in a format they can sort or search, provide a separate table rather than expecting the diagram to serve both purposes.

Update the chart when the organization changes

SmartArt does not automatically synchronize with a separate Excel range of employee records. If a manager changes, a role is added, or a team is reorganized, edit the SmartArt itself: select the relevant box, change its text, and use SmartArt Design > Add Shape or the text pane to revise the structure. Then review the whole chart, not just the changed box, because adding a person may affect spacing and make other labels harder to read.

For a chart that is updated periodically, keep a separate source list with one row per person and columns such as Name, Job Title, Department, and Manager. Agree on who is allowed to update that list and who is responsible for revising the visual. A simple change checklist can reduce errors:

  • Confirm the new reporting relationship and effective date.
  • Update the source list and the SmartArt diagram.
  • Check spelling, titles, vacant roles, and every affected reporting line.
  • Record when the chart was last reviewed, and replace older shared copies.

For frequent changes, this two-part process may become inconvenient. A specialized diagramming tool or an organization’s approved HR system may provide a better way to create or distribute current charts. Before choosing one, check whether it can use the organization’s existing data and whether access to staff information is appropriately controlled.

When to use shapes instead of SmartArt

SmartArt is the practical starting point for most simple charts, but it can feel restrictive when boxes need unusual positions, different connector styles, or nonstandard relationships. In those cases, you can create the diagram manually with shapes and connectors. On Windows, use Insert > Shapes to add rectangles for people and connector lines to show reporting links. Enter names and titles in the shapes, then arrange and format them individually.

Manual drawing gives you more control, but it also creates more maintenance work. Moving a manager may require you to move several boxes and reconnect lines. A connector that looks attached to a box may not remain attached if it was drawn as an ordinary line rather than an appropriate connector. Zoom in and check connections after rearranging the diagram, and group related shapes when that helps keep a section together.

Choose SmartArt when speed and a consistent hierarchy matter more than fine-grained control. Choose manual shapes when the visual structure needs to depart from a conventional hierarchy and the chart is small enough to maintain carefully. For a large, frequently revised structure, neither method is necessarily the best long-term source of truth.

Common problems and practical limits

A common misunderstanding is that an org chart made in Excel will update as soon as the employee table changes. It will not: SmartArt text and hierarchy are edited within the graphic. Another frequent issue is treating every relationship as a simple manager-to-report link. Cross-functional teams, shared supervision, and dotted-line relationships may need a legend or a different diagram, because a basic hierarchy can imply a single, direct chain of command.

Charts can also become unreadable when they include too many levels or long titles. Consider separate charts for departments, a high-level chart with links to detailed team charts, or a table for information that does not fit naturally into boxes. Avoid sharing a chart that contains personal information beyond what its audience needs. A workbook shared through OneDrive or SharePoint may be accessible to people with permission to the file, so review sharing permissions and remove unnecessary details before distribution.

Finally, check the chart after opening it on another device or exporting it. Excel for Mac also supports SmartArt, though ribbon presentation and some interface details can differ from Windows. Excel for the web may display and edit many workbook features, but the available controls can vary. If the chart is important, verify its layout in the version recipients will use and inspect the exported or printed result.

Alternatives to an Excel org chart

Excel is a reasonable choice when the chart belongs in a workbook or needs to be assembled quickly. PowerPoint can be more convenient when the main purpose is a presentation slide, while Microsoft Visio is designed for diagramming and may suit more involved organizational diagrams. A dedicated HR or organizational-management system may be more appropriate when charts must reflect frequently changing personnel data, subject to the system’s capabilities and the organization’s policies.

These options solve different problems. A diagramming app can offer more layout control; a personnel system may provide a managed data source; Excel combines a familiar worksheet with a basic diagram feature. Compare the effort of keeping the chart current, the number of viewers, data sensitivity, and whether people need to edit or simply view it. For a small team chart revised occasionally, SmartArt may be entirely sufficient. For a large enterprise chart, ease of initial drawing is less important than reliable updates and governance.

Frequently Asked Questions

Does Excel have an org chart template?

Excel includes SmartArt hierarchy layouts, including Organization Chart, which you can use without downloading a template. You can also look for workbook templates in Excel, but template availability can vary. SmartArt is usually the quickest built-in option for a basic chart.

How do I add a direct report in Excel SmartArt?

Select the manager’s box, then choose SmartArt Design > Add Shape > Add Shape Below. Alternatively, use the text pane and indent the new item beneath the manager. Check the resulting placement to confirm the intended reporting relationship.

Can an Excel org chart update automatically from a table?

A standard SmartArt organization chart does not automatically update from an employee table. You need to make changes in the diagram as well as the source list. If automatic or managed updates are essential, investigate a dedicated diagramming or HR tool that supports the organization’s data and access requirements.

Can I make an org chart in Excel on a Mac?

Yes. Excel for Mac supports SmartArt hierarchy diagrams. The ribbon and some controls may look different from Excel for Microsoft 365 on Windows, so follow the equivalent Insert and SmartArt options shown in your Mac edition.

Is Excel good for a large company org chart?

It can work for a static overview, but a very large chart may be difficult to read and costly to update manually. Consider splitting it into department-level views or using a tool that can manage the underlying reporting data and generate diagrams more consistently.

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.