Yes. In Excel for Microsoft 365 on Windows, select Insert > SmartArt > Hierarchy, choose Organization Chart, and enter each person in the SmartArt text pane; use indents to show who reports to whom. Excel is useful for a small, mostly static org chart, but the chart is a visual object rather than a live view of an employee database, so updates generally require editing the chart.
What an Excel org chart shows
An organizational chart, or org chart, maps positions and reporting relationships. A typical chart places a leader at the top, direct reports on the next level, and their teams below. Each box can contain a person’s name, job title, department, or other brief details. The layout can help people understand who leads a team, where a role sits, and how departments connect.
Decide what relationship the chart is meant to explain before building it. A traditional org chart usually shows formal reporting lines, not every project partnership or day-to-day collaboration. A company with dotted-line reporting, temporary teams, or multiple supervisors may need annotations or a different diagram so the picture does not imply a simpler structure than actually exists.
Prepare the information before opening SmartArt
Collect and verify the reporting information first. A simple source table can help even if you plan to enter the labels into SmartArt manually. For example, use columns for Employee, Job title, Department, and Reports to. In the last column, record the manager’s name; for the top leader, use a consistent value such as blank or Top level.
Keep the source list separate from the visual chart. It is easier to review a table for missing managers, duplicate names, and spelling inconsistencies than to spot every issue in a crowded graphic. If two employees share a name, include a department or role so the chart remains unambiguous. For a larger organization, an employee ID in the source list can help distinguish people, even if you do not display the ID in the chart.
- Confirm that each person has the correct manager and that the reporting chain reaches the intended top-level role.
- Decide whether to show people, positions, or both. A chart focused on positions can remain useful while a role is vacant.
- Choose the level of detail. Names and titles may be enough; contact details or sensitive employment information usually do not belong in a broadly shared diagram.
- Set a date or version label so readers know when the chart was last reviewed.
Create the chart with SmartArt
In Excel for Microsoft 365 on Windows, open the worksheet where the diagram should sit and choose Insert > SmartArt. In the SmartArt gallery, select Hierarchy, choose Organization Chart, and select OK. The chart appears on the worksheet with a text pane for entering its hierarchy. If the pane is not visible, select the SmartArt graphic and use the control to open the Text Pane on the SmartArt Design tab.
Enter the top person or role as the first item. Press Enter in the text pane to add another item at the same level, and use Tab to indent an item beneath the person above it. Shift+Tab moves an item back up a level. For example, put the chief executive first, list department heads at the next level, then indent each department’s managers under the appropriate head. Check the visual result as you build: indentation in the pane determines reporting level, so one misplaced indent can make a sound-looking diagram incorrect.
You can also add or rearrange shapes with the ribbon. Select a shape and choose SmartArt Design > Add Shape to add a subordinate, a peer, or a shape before or after the selected one. The available options depend on the selected position. To change a person’s place in the hierarchy, use Promote or Demote on the SmartArt Design tab, or adjust the text-pane indentation. These commands change the structure, not merely the box’s position on the sheet.
Format the layout for readability
SmartArt supplies a coordinated layout and style, but the default arrangement may not suit the amount of information. Select the graphic to see the SmartArt Design and Format tabs. SmartArt Design offers layout, color, and style choices; Format provides options for selected shapes, such as fill, outline, and text appearance. The exact controls shown can vary with the selected object and window size.
Use concise labels. Long job titles and several lines of extra detail can make boxes uneven or shrink text until it is difficult to read. If the chart is too wide, consider showing fewer levels on one page, splitting the organization into department-level charts, or using a landscape worksheet and printing across multiple pages. Avoid shrinking the whole chart until the text is unreadable just to force it onto a single printed page.
Color can distinguish departments or mark a small number of special cases, but do not rely on color alone to convey meaning. Include a legend when color has a specific interpretation, and check that text and connector lines remain legible when printed in grayscale. Use descriptive worksheet names and put any explanation, date, or legend near the chart rather than leaving readers to guess what the styling means.
Keep the chart accurate as people and roles change
SmartArt does not automatically connect its boxes to a separate employee table. Changing a name in the source list will not, by itself, change the matching label in the graphic. Likewise, sorting or filtering a table does not reorganize SmartArt. Treat the source list as the record to verify against, then update the diagram deliberately whenever reporting relationships or displayed details change.
For routine maintenance, assign an owner and a review schedule. A practical process is to compare the current source list with the chart, confirm changes with the appropriate manager or HR contact, update the relevant shapes, and record the review date. For frequent reorganizations or hundreds of roles, manually maintaining boxes can become error-prone; a system that manages employee records and produces diagrams may be more suitable.
Keep a clean copy before a substantial redesign. SmartArt can be edited, but deleting or moving many shapes without checking the hierarchy can create confusing results. After editing, inspect the top-to-bottom reporting lines, confirm vacant roles and interim arrangements are represented as intended, and check the chart at normal viewing size and in print preview.
SmartArt, manual shapes, and other tools
SmartArt is usually the fastest Excel option for a conventional hierarchy with a modest number of boxes. It keeps the layout coordinated and provides commands designed for hierarchy changes. It is less flexible when the diagram needs unusual connections, mixed reporting lines, custom box placement, or detailed annotations.
For a small diagram with special requirements, use Insert > Shapes to place boxes and connector lines manually. This gives more control over positions and styles, including the ability to label different kinds of relationships. The trade-off is more upkeep: boxes and connectors must be moved and aligned by hand, and changing the structure may require substantial rearrangement. A connector that looks attached should be checked after moving shapes, particularly before sharing or printing.
Excel also supports ordinary charts and tables, but an org chart is not a standard data chart such as a column or line chart. A table is better when readers need to sort, filter, or search employee records; a diagram is better for seeing a reporting hierarchy at a glance. Dedicated diagramming or HR software may offer data-driven updates, collaboration, or more complex relationship types, depending on the product. Check a tool’s actual import, export, and licensing features before choosing it.
Sharing, printing, and access considerations
An org chart can disclose more than names and titles. Before sharing a workbook, remove details that the intended audience does not need, and consider whether the chart reveals team structures or vacant positions that should not be broadly distributed. A workbook’s worksheet protection is not a substitute for controlling who can access sensitive information. When the file is stored in a shared Microsoft 365 location, use the organization’s file-sharing permissions and follow its information-handling rules.
For printing, use File > Print to inspect the preview and adjust page orientation, margins, scaling, or page breaks as needed. The chart may be an object on a worksheet, so verify that it fits within the intended print area and that labels are not cut off. A PDF can be convenient for sharing a fixed snapshot, but it will not keep itself synchronized with later workbook edits; add a date or version to avoid confusion over which copy is current.
Frequently Asked Questions
Can Excel automatically create an org chart from a list of employees?
SmartArt lets you enter a hierarchy in its text pane, but it does not automatically turn an ordinary employee table into a chart that stays linked to that table. Plan to build and maintain the visual structure, or investigate a separate data-driven tool if automatic refresh is essential.
How do I add a person who reports to someone in the chart?
Select the manager’s shape and use SmartArt Design > Add Shape to add a subordinate shape. You can also enter the person in the text pane and indent the item beneath the manager’s entry.
Can I show two managers or dotted-line reports?
A standard hierarchy is designed around a clear parent-and-subordinate structure. For a secondary reporting relationship, use a clearly labeled connector or annotation with a manual-shape diagram, or choose a tool designed for more complex relationships. Explain the line style so readers do not mistake it for a formal reporting line.
Can the org chart be printed on one page?
Sometimes, depending on the chart’s size and label length. Check File > Print and try landscape orientation or adjusted scaling, but do not reduce the text below a readable size. Large organizations are often clearer split into related charts or printed across multiple pages.
Does the Excel org chart update when I change a name in a table?
No, not by default. SmartArt text and a separate worksheet table are independent. Update both deliberately and verify the chart after changes.
Related
- ICD-10 Z Codes List in Excel: Find, Import, and Check
- Excel Color Scales: How Conditional Formatting Works
- Close Excel Shortcut Key for Windows and Mac
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Chart Timeline: Create and Format OneIn Excel for Microsoft 365 on Windows, add a timeline that filters a chart by selecting its PivotTable…
- Excel Radar Chart With Different Scales: What WorksNo: an Excel radar chart uses one shared value scale for every series and spoke, so you cannot…
- OEE Waterfall Chart in Excel: Build and Interpret ResultsTo make an OEE waterfall chart in Excel, put the starting 100% and each staged loss in a…
- Excel Waterfall Chart: Add and Format a Subtotal BarTo add a subtotal to an Excel waterfall chart, include a row containing the cumulative subtotal in the…
- Excel Pivot Table Not Pulling All Data? Fix ItIf an Excel PivotTable is missing rows, first refresh it, then check whether its data source includes those…
- Excel Pie Chart: Create, Format, and Fix OneTo make a pie chart in Excel for Microsoft 365 on Windows, select a table with one category…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.