Yes. In Excel for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy > Organization Chart, then enter names and job titles in the SmartArt Text Pane to create a sample org chart. A small example and the steps below show how to structure, format, and maintain it.
A simple sample org chart
Start with a reporting structure that is easy to understand. For example, a small company might use this hierarchy:
- Jordan Lee — Chief Executive Officer
- Casey Morgan — Chief Operating Officer, reporting to Jordan
- Riley Chen — Finance Director, reporting to Jordan
- Sam Patel — Operations Manager, reporting to Casey
- Taylor Brooks — People Manager, reporting to Casey
- Alex Rivera — Accounting Manager, reporting to Riley
In an organization chart, the person at the top is the senior role shown, and lines or connectors indicate reporting relationships. In this example, the CEO has two direct reports. The operations manager and people manager report to the COO, while the accounting manager reports to the finance director. The chart is a visual summary, not a complete record of every employee or responsibility.
Use real names and titles only if the chart is intended for that audience. For a reusable sample, substitute role names such as CEO, Department Head, and Team Lead. If the structure is large, show only the level of detail readers need and consider creating separate charts for departments.
Create the chart with SmartArt
SmartArt is a convenient starting point when the chart has a conventional top-down hierarchy. These steps apply to desktop Excel for Microsoft 365 on Windows:
- Open a blank worksheet or the workbook where the chart will live. Select Insert > SmartArt.
- In the Choose a SmartArt Graphic window, select Hierarchy, choose Organization Chart, and select OK.
- Select the small arrow at the left edge of the SmartArt graphic to open its Text Pane, if the pane is not already visible.
- Type the top role, then add subordinate roles beneath it. Use the Text Pane’s list indentation to show which people report to which manager. A subordinate entry is indented beneath its manager; an entry at the same level is a peer.
- Replace the sample text with names and titles, then use the SmartArt Design and Format tabs to adjust the layout and appearance.
You can also select a box and use SmartArt Design > Add Shape to add a person above, below, or beside the selected position, or to add an assistant where that option is available. Check the resulting connectors: a new box should be attached to the correct manager, not merely placed near the right department. On Mac, the SmartArt feature is available in Excel, though ribbon placement and dialog appearance can differ slightly. Excel for the web may offer a more limited editing experience than desktop Excel; if a chart is difficult to change there, open the workbook in the desktop app.
Plan the reporting relationships first
Before adding boxes, settle what the chart is meant to explain. An org chart may show formal reporting lines, a temporary project team, or a simplified leadership structure. Those are different views. A project lead may coordinate work without being someone’s manager, so placing that lead above team members could wrongly imply a formal reporting relationship.
For a useful sample, define the scope and date. For example, a chart titled “Customer Support Team — June 2026” tells readers which group it covers and when the structure was current. Decide whether to include contractors, vacant positions, assistants, and dotted-line relationships. If a reporting line is not a direct management relationship, label it clearly or explain it in a note rather than relying on an ambiguous connector.
Keep the hierarchy consistent: each person should have one clear position in the reporting tree unless the chart intentionally documents a matrix structure. In a matrix, employees can have more than one relevant manager, and a simple tree can be misleading. A note, separate functional chart, or carefully labeled connectors may communicate the arrangement more accurately than forcing it into a conventional organization chart.
Prepare a source table for future edits
SmartArt is a visual object, not a live chart generated automatically from a list of managers. Editing an employee table will not, by itself, rearrange the SmartArt boxes. For a chart that changes often, keep a separate source table so the underlying information is easier to review and update. A practical layout is:
- Employee: the person’s name or a stable identifier.
- Job title: the role displayed in the chart.
- Manager: the direct manager’s name or identifier; use a consistent label for the top role, such as CEO.
- Department: useful when filtering or preparing department-level views.
- Effective date: optional, but helpful when changes take effect at different times.
For example, the source rows could say Jordan Lee is CEO with no manager, Casey Morgan is COO with Jordan Lee as manager, and Sam Patel is Operations Manager with Casey Morgan as manager. Use one row per person, consistent spelling, and a single manager value per row for a basic hierarchy. Avoid merged cells in the source list; they make sorting and filtering harder. You can select the list and choose Home > Format as Table to make it easier to filter and maintain.
Keep the source table and chart clearly labeled, and note who is responsible for updating them. This reduces the chance that the picture is treated as current after the underlying organization changes. If the chart is maintained manually, compare it against the source list after each update, especially when employees move between departments or a manager leaves.
Make names and levels easy to read
A chart can be technically correct but difficult to use if every box contains too much text. A compact box usually needs a name and a title; lengthy responsibilities, phone numbers, or biographies belong in a directory or separate worksheet. Use a consistent pattern, such as name on the first line and title on the second, so readers can scan the chart quickly.
Use SmartArt Design to try different hierarchy layouts when the default arrangement becomes crowded. SmartArt styles and colors can help distinguish levels, but color should not be the only way to communicate meaning. Some readers print in grayscale, and color differences may be hard to distinguish. Use readable text, adequate contrast, and labels that make sense without color. Avoid shrinking the font excessively just to fit a large organization onto one page.
For a small organization, one chart may fit on a worksheet. For a larger one, create a leadership overview and separate department charts, or split the display across pages with a clear title on each page. Keep shapes aligned and connectors visible. A decorative background or many colors can make a reporting diagram less legible rather than more professional.
Update the chart without losing control of it
When someone joins, leaves, or changes manager, update both the source table and the SmartArt if you use both. Select the relevant box, revise the text, and use SmartArt Design > Add Shape or the Text Pane to adjust the hierarchy. Then check each affected branch from the top down. A correct name attached to the wrong manager is still an inaccurate chart.
It helps to add a version date near the chart title and store the workbook in a location with appropriate access controls. Organization charts can contain employee information that should not be shared broadly. Limit details to what the intended audience needs, and follow your organization’s rules for storing and distributing personnel information. If distributing a static copy, export or print a reviewed version and make clear when it was prepared.
For a chart that is frequently reorganized or includes many roles, manual SmartArt editing can become tedious. Treat the source table as the record to verify, and consider whether the workbook should instead serve as a simple presentation or as a maintained personnel directory. Excel does not automatically validate that every manager exists or that the hierarchy contains no circular reporting relationships just because the data is in a table.
Print, share, and check accessibility
Before printing, select the worksheet and use File > Print to review the preview. A wide chart may be clipped or reduced until the text is too small. In Page Layout, review Orientation, Margins, and the scaling options; landscape orientation can help with wide diagrams. Use scaling cautiously: fitting everything to one page may produce unreadable text. If the chart is large, use multiple pages or print a concise overview instead.
Consider whether the chart is understandable to someone who uses a screen reader or cannot distinguish colors. Give the chart a descriptive title, use clear labels, and avoid relying on color alone. In desktop Excel, select the SmartArt graphic and use the Alt Text option from its context menu or the Format tab to add a concise description where available. A short description can state the chart’s purpose and top-level structure, but it is not a substitute for accessible, readable text. For a complex hierarchy, provide the source table or a written list of reporting relationships as an alternative.
When sharing, remember that an Excel workbook may include hidden worksheets, comments, or other information beyond the visible chart. Review the file contents and sharing permissions before sending it. If recipients only need to view the organization, a PDF can preserve the layout, but it will not be as convenient to edit as the workbook.
SmartArt, shapes, and other options
SmartArt is usually the quickest option for a small, standard hierarchy. It keeps connected boxes together as a graphic and offers built-in organization-chart layouts. Its main limitation is that the visual structure is edited manually and is not automatically driven by a manager column in a table.
Individual shapes and connectors give more layout control, which can help with unusual structures or special annotations. The trade-off is more manual work: moving a manager may require repositioning several boxes and reconnecting lines. A table alone is easier to sort, filter, and maintain, but readers may find reporting relationships less immediate. For a large or frequently changing organization, dedicated organization-chart software or an approved HR system may be more suitable; check whether it supports the required data and access controls.
A common misconception is that an Excel org chart is automatically linked to company directory data. Creating SmartArt does not make that connection. If automatic updates are essential, verify that the chosen tool actually supports the data connection and update process your organization needs. Do not assume that a visually polished chart is a current or authoritative employee record.
Frequently Asked Questions
Does Excel have an org chart template?
Excel’s built-in SmartArt includes an Organization Chart layout, which is a practical starting point. Templates may also be available through Microsoft’s template sources, but availability can vary. The steps here work without downloading a separate template.
How do I add a person who reports to a manager?
Select the manager’s box and use SmartArt Design > Add Shape, choosing the subordinate option, or add an indented entry beneath that manager in the Text Pane. Confirm that the new box is connected to the intended role.
Can Excel build an org chart from a Manager column automatically?
Not with a standard SmartArt chart. A table with Employee and Manager columns is useful as a source record, but SmartArt must be arranged and updated as a graphic. A separate tool or custom workflow is needed for automatic generation.
How do I show two managers?
A conventional org chart represents a tree and is not a natural fit for matrix reporting. You can use clearly labeled connectors or a separate diagram, but make the relationship explicit so readers do not mistake coordination or project oversight for direct management.
Why is my chart too small when I print it?
The chart may be wider or taller than the selected paper size, causing print scaling to shrink it. Check File > Print preview, try landscape orientation, or divide the chart into readable sections instead of forcing the whole structure onto one page.
Related
- Capitalize First Letter in Excel Quickly
- Quick Search in Excel: Find Data Fast
- Superscript in Excel: Quick Key and Formatting Steps
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pivot Chart Secondary Y Axis: How to Add OneYes. In Excel for Microsoft 365 on Windows, select a PivotChart data series, open Format Data Series, and…
- Pivot Table Formula Errors in Excel: Causes and FixesA PivotTable formula error usually comes from an error in the source data, a calculated field that does…
- Excel Doughnut Chart With a Total in the Center ExplainedYes. In Excel for Microsoft 365 on Windows, create a doughnut chart, calculate the total in a worksheet…
- Excel Dashboard Software Templates: How to Choose and UseExcel dashboard software templates are ready-made workbooks that turn spreadsheet data into a visual summary, usually with charts,…
- Org Chart Program in Excel: Create and Maintain OneYes. Microsoft Excel for Microsoft 365 can create an organizational chart using SmartArt: choose Insert > SmartArt >…
- Excel Dashboard Creator: How to Build a Useful OneAn Excel dashboard creator is either a person who builds a visual report in Excel or a tool…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.