Yes. In Microsoft Excel for Microsoft 365 on Windows, the quickest way to build an org chart is Insert > SmartArt > Hierarchy > Organization Chart. Add names and roles in the SmartArt Text Pane, then use SmartArt Design > Add Shape to show reporting relationships; Excel does not automatically turn a staff list into a chart that stays linked to the list.
Choose the right way to build the chart
For a compact chart with a clear chain of command, SmartArt is usually the best starting point. It supplies connected boxes and reporting lines, and it rearranges them as you add or remove people. It works well for a department, a small company, or a simplified view of a larger organization.
Use individual shapes and connectors instead when you need unusual layouts, dotted-line relationships, extensive notes, or precise control over every position. Manual drawing gives you flexibility but also means you must move boxes and reconnect lines when the structure changes. A chart that needs frequent updates, multiple views, or hundreds of roles may be better maintained in an organizational chart application or a dedicated diagramming tool.
Before choosing, consider the audience and purpose. A chart for onboarding may need names, titles, and managers. A planning chart may show vacant positions or teams instead. Avoid adding details that readers do not need: an org chart is most useful when its reporting relationships are easy to understand at a glance.
Prepare the employee information first
A little preparation reduces editing later. Decide what one box represents: an individual employee, a position, a team, or a department. Then settle on a consistent level of detail. Mixing some people’s full titles with others’ department names, for example, can make the chart confusing.
A simple source list in a worksheet can help you check the structure before building the visual. Useful columns include employee name, job title, department, and manager. Include a unique identifier if two employees have the same name. The manager field is particularly useful for checking that every position has the intended parent and that you have not accidentally created a reporting loop.
- Use one row per person or position, and keep names and titles consistent.
- Check that each manager is present in the list, except for the person at the top of the chart.
- Decide how to represent vacancies, contractors, shared roles, and temporary assignments.
- Keep private information, such as personal phone numbers or sensitive employment details, out of a chart unless the audience genuinely needs it.
This list is a planning aid, not a live data connection. If you change a manager in the worksheet, the SmartArt chart will not automatically move that employee to a new branch. You must update the chart separately or use a tool designed to generate diagrams from structured data.
Create an organization chart with SmartArt
In desktop Excel for Microsoft 365 on Windows, create the chart on a blank worksheet or on a sheet set aside for the diagram. Choose Insert > SmartArt, select Hierarchy, choose Organization Chart, and select OK. If the SmartArt Design tab is not visible, click the chart to display its contextual tabs.
Enter the top role first, then build the reporting levels beneath it. To use the Text Pane, select the small arrow at the left edge of the SmartArt graphic if the pane is hidden. Type a person or position on each line. Press Enter to create another item at the same level. Press Tab to indent an item as a subordinate, or Shift+Tab to move it up a level. Check the result in the chart as you work: indentation determines the hierarchy, not the order in which names appear in your source list.
You can also select a box and add a shape from the ribbon. Choose SmartArt Design > Add Shape, then select the relationship you need:
- Add Shape Below creates a direct report under the selected box.
- Add Shape After adds a peer at the same level, following the selected box.
- Add Shape Before adds a peer before the selected box.
- Add Assistant adds an assistant role associated with the selected manager, rather than an ordinary direct report.
Click a box to edit its text. To remove a position, select its box and press Delete; check the resulting layout because removing a parent can affect the way its subordinate boxes are arranged. If the chart is too small to read while editing, zoom in with the status-bar zoom control rather than shrinking the text to fit the whole worksheet.
Represent teams and reporting lines accurately
An org chart is a model of reporting relationships, not necessarily a map of every collaboration or approval path. In a conventional hierarchy, each person appears under their manager, and peers sit at the same level. If someone reports to two managers, forcing both relationships into a standard hierarchy may create ambiguity or imply a structure that does not exist.
For matrix organizations, dotted-line reporting, project teams, or cross-functional groups, explain the relationship with a legend or use a diagram type that supports multiple connectors. SmartArt Organization Chart is built around a hierarchy, so it is not a reliable way to express every complex relationship. One practical option is to create a primary reporting chart and a separate project or team diagram, rather than crowding both kinds of information into one picture.
Decide how to show vacant roles and shared services before adding them. A label such as Vacant can be clearer than leaving a blank box, while a shared service may need a note identifying its functional relationship. Keep these conventions consistent throughout the chart.
Format the chart for readability
After the reporting structure is correct, select the SmartArt graphic and use SmartArt Design to try a different layout or visual style. The Layout options can change how subordinate boxes hang from a manager; the available choices depend on the selected SmartArt layout. Change Colors and SmartArt Styles offer coordinated visual treatments. Use color to communicate a real distinction, such as departments, rather than assigning a different decorative color to every person.
Keep box text short enough to scan. A name on one line and a title on another is often easier to read than a long sentence containing title, location, and contact details. If a box becomes crowded, consider shortening a title consistently or moving extra information to a nearby table. Avoid shrinking type until it is unreadable simply to fit an oversized hierarchy on one screen.
For a small chart, use a restrained font size, clear contrast, and enough space between branches. Make sure labels and connecting lines remain distinguishable when printed in grayscale. If color communicates department membership, also include department names or another visual cue so the meaning is not dependent on color alone.
Know what SmartArt can and cannot do
SmartArt is convenient because it handles many routine layout adjustments, but its graphic is not a database. It does not automatically validate names against an employee list, find missing managers, or synchronize a manager change from a separate table. Adding or editing a line in the Text Pane changes the graphic; editing a source worksheet does not.
Large charts also become difficult to read. A long chain of levels may produce tiny boxes, and a manager with many direct reports may create a very wide branch. Rather than squeezing everything onto one page, consider separate charts by department, a top-level overview with links to detailed sheets, or a digital diagram that readers can zoom and navigate.
SmartArt can reflow as the content changes, so a chart may look different after adding a subordinate or changing a level. Review the entire graphic after structural edits; do not assume that the automatic layout preserved the grouping or page balance you intended. If precise placement matters, a manually drawn diagram may be more suitable, although it requires more maintenance.
Maintain, share, and print the chart
Assign responsibility for updates and add a last-reviewed date near the chart. For a useful review, compare every box against the current source list, confirm managers and titles, and check that departed employees and newly vacant positions are handled according to your organization’s convention. If the chart is distributed as a PDF or image, update those copies whenever the workbook changes.
Before sharing, review workbook access and remove unrelated sheets or information that recipients should not see. Hiding a worksheet is not a security boundary: someone with access to the workbook may be able to unhide it. Share only the information and file that the audience is authorized to receive.
For printing, select the chart and check its size and orientation in File > Print. The Page Layout tab provides controls such as Orientation, Margins, and page scaling. Fit-to-page scaling can make a wide chart fit on one sheet, but it may shrink the text too much. If that happens, print across multiple pages, use a larger paper size where available, or split the chart into readable sections. Always check Print Preview before distributing copies.
Alternatives when Excel is not enough
Excel is a sensible choice when the chart is modest in size, changes occasionally, and belongs alongside tabular planning information. Other tools may fit better when the diagram is the main deliverable or must stay synchronized with structured employee data.
- PowerPoint: Useful when the chart is part of a presentation. It offers SmartArt and slide-sized layout space, but the chart still needs updating when the organization changes.
- Visio: Designed for diagramming and offers organization-chart capabilities. Available features and data-driven workflows depend on the Visio version and license.
- Diagramming applications: These may offer more flexible connectors, collaboration, or larger canvases. Check export options and access controls before using them for staff information.
- HR or directory systems: If the organization already maintains authoritative manager and position records in a system, use its reporting or export features where available instead of treating a manually maintained chart as the source of truth.
For many teams, Excel remains adequate if one owner maintains the source list and the visual chart together, then checks them against each other on a defined schedule. The important distinction is that the worksheet can help manage the information, while a SmartArt org chart is a visual representation that needs its own update.
Frequently Asked Questions
Can Excel make an org chart automatically from a list of employees?
Not with a standard SmartArt org chart. You can use a list to plan and check the hierarchy, but you must enter or rearrange the SmartArt content yourself. A specialized diagramming or HR tool may offer data-driven chart creation.
How do I add a manager or direct report in Excel?
Select the relevant box, then choose SmartArt Design > Add Shape > Add Shape Below to add a direct report. To add a peer, use Add Shape After or Add Shape Before.
Can I show two managers for one employee?
A standard hierarchy is intended to show a parent-child structure, so two reporting lines may be misleading or awkward. Consider a separate matrix or project-team diagram, or clearly explain any additional relationship with a legend.
Why is SmartArt missing or unavailable in Excel for the web?
SmartArt features in Excel for the web are more limited than in desktop Excel, and the available commands can vary. If you cannot create or edit the chart there, open the workbook in desktop Excel. On Mac, use the Insert tab and its SmartArt command; ribbon labels or placement may vary slightly by release.
Can the chart update when I change the employee table?
No. A SmartArt chart does not stay linked to a separate employee table, so a changed manager, title, or name must be reflected in the graphic as well. Keep the source list and chart under a clear update process to reduce mismatches.
Related
- Meal Planning Spreadsheet Template: Build a Weekly Plan
- Meal Planner Template Excel: Build a Useful Weekly Plan
- Meal Planner Spreadsheet Template: Build a Weekly Plan
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Pivot Chart Filters in Excel: How to Add and Use ThemYes. In Excel for Microsoft 365 on Windows, select the PivotChart and use its field-button drop-downs to filter,…
- Creating a Histogram in Excel: Steps, Bins, and TipsTo create a histogram in Microsoft Excel for Microsoft 365 on Windows, select your numeric data, then choose…
- Creating a Waterfall Chart in Excel: A Step-by-Step GuideTo create a waterfall chart in Excel for Microsoft 365 on Windows, put each step of the change…
- Excel Trendline Only Some Data Points? Fix ItIn Excel, a trendline is normally calculated for an entire chart series, not for individually selected points. To…
- Excel Gantt Chart With Dependencies: How to Build OneYes. In Excel for Microsoft 365 on Windows, you can build a Gantt chart whose task dates update…
- How to Print an Excel Graph on a Full Page in ExcelTo print an Excel graph across a full page, select the chart, choose Chart Design > Move Chart…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.