To create an org chart in Excel for Microsoft 365 on Windows, select Insert > SmartArt > Hierarchy, choose an organization-chart layout, and select OK. Add names and roles in the Text pane, then use the SmartArt Design and Format tabs to arrange and style the chart.
SmartArt is a practical way to show who reports to whom when you need a clear, editable diagram rather than a data analysis. It works well for small and medium-sized teams, but it is not a live chart connected to worksheet rows: edits to the source data do not automatically update the graphic. Understanding that distinction helps you choose the right layout and avoid redoing the chart later.
What an Excel SmartArt org chart shows
An organization chart represents reporting relationships as a hierarchy. A typical example puts a chief executive at the top, department heads on the next level, and team members below them. In Excel, SmartArt builds this hierarchy from text entries and displays each person or role in a shape connected to the relevant manager.
SmartArt is useful when the main purpose is communication: readers need to see the structure quickly, and the chart does not need to calculate values. It can show names, job titles, departments, or a combination, but putting too much text in each box makes the structure hard to scan. For a chart that may be printed or shared, use concise labels and reserve detail such as phone numbers or responsibilities for a separate table.
Choose a layout that fits the structure
After selecting Insert > SmartArt > Hierarchy, Excel presents several layouts. The standard Organization Chart is a sensible starting point for a conventional manager-to-report structure. Other hierarchy layouts may emphasize a top-down tree, a horizontal flow, or nested levels. The names and available choices can vary by Excel version.
Choose based on how people will read the chart, not just on which preview looks decorative. A top-down layout is familiar and straightforward for a compact department. A wider layout may use space better when one manager has many direct reports. If the chart has many levels or dozens of people, a single SmartArt graphic can become crowded; splitting it into department-level charts or using a dedicated diagram tool may be clearer.
- Small team: A standard org-chart layout can show a leader, a few managers, and their direct reports on one page.
- Several departments: Use clearly labeled manager and department levels, and consider separate charts if labels become cramped.
- Project team: If people have several project leads rather than one reporting manager, an org chart may imply a hierarchy that does not exist. A matrix or responsibility diagram may describe the arrangement more accurately.
Enter names and build reporting levels
When the SmartArt is selected, a small arrow at its edge opens the Text pane. Type one person or role per line. Press Enter to add another item at the same level; use Tab to make the current item a subordinate of the preceding item, and Shift+Tab to promote it back up a level. You can also use the Text pane’s controls to change the hierarchy. The indentation in the pane corresponds to reporting levels in the graphic.
For example, enter “Jordan Lee — Director” as the first item, followed by “Avery Chen — Sales Manager” and “Morgan Patel — Operations Manager” as subordinate entries. Add sales representatives under Avery and operations staff under Morgan by indenting those entries another level. This is more reliable than trying to infer the hierarchy from box position alone.
You can also add or change chart entries from the SmartArt Design tab. Select a box, then use SmartArt Design > Add Shape to insert a shape in relation to the selected person. The menu offers choices such as adding a shape after, before, above, or below, with the exact options depending on the selected layout. Use the Text pane when several entries need reorganizing; it makes the levels easier to inspect.
Format and rearrange the chart
Select the graphic to display the contextual SmartArt Design and Format tabs. SmartArt Design includes controls for changing layouts, colors, and SmartArt styles. Format provides shape-level controls such as fill, outline, and text formatting. A restrained palette and consistent font are usually easier to read than a different color for every person.
To change the visual arrangement of reports, select a subordinate box and use SmartArt Design > Layout in the Create Graphic group. Org-chart layouts can include alternatives for distributing subordinates around a manager. If a manager has many direct reports, changing this arrangement may reduce the chart’s height or width without changing who reports to whom. Preview the result and check that connector lines remain easy to follow.
Other practical adjustments include:
- Resize the overall SmartArt graphic using its corner handles, rather than stretching only one side if that distorts the proportions.
- Increase the worksheet column widths or row heights around the chart if it overlaps nearby content.
- Use concise titles, such as “Customer Support Manager,” rather than several lines of descriptive text in every box.
- Check the chart at the size it will be printed or viewed. Text that looks readable when zoomed in may be too small on a printed page.
Update the chart and manage changes
To update an existing chart, select a shape and edit its text, or open the Text pane and change the list. Add a position with SmartArt Design > Add Shape; remove a position by selecting its shape and pressing Delete. Before deleting, check whether the shape has subordinates, since removing a manager can affect how the remaining hierarchy is represented. Review the result after edits, especially when moving someone between levels.
A common misconception is that SmartArt reads a table of employees and refreshes itself whenever the table changes. In Excel, an ordinary SmartArt org chart is a graphic, not a data-linked org-chart report. If the employee list changes, you must update the SmartArt manually. For occasional changes, this is manageable. For frequent reorganizations, a maintained employee table plus a diagramming tool or an automated process may be a better fit.
Keep a separate table as the authoritative record if accuracy matters. Useful columns might include employee name, job title, department, and manager. The table makes sorting and checking details easier, while the SmartArt serves as the presentation view. Compare the two after each update so that names and reporting lines do not drift apart.
Common problems and practical fixes
The chart looks crowded: Reduce text, widen the chart area, or split a large organization into related charts. Changing the layout can improve spacing, but it cannot make unlimited detail fit legibly on one page.
A person appears at the wrong level: Open the Text pane and check indentation. Tab makes an item subordinate; Shift+Tab moves it upward. This is often faster than dragging shapes and guessing at connector behavior.
Adding a person changes the layout unexpectedly: SmartArt automatically rearranges shapes to fit the hierarchy. Select the affected shape and try a different layout or subordinate arrangement. Then inspect all connector lines, not only the new box.
The chart does not fit when printed: Set the worksheet’s print area and page orientation, and review the print preview. A wide chart may need landscape orientation or a larger paper size. Avoid shrinking an entire worksheet so far that names become unreadable. If the chart is the main deliverable, placing it on a dedicated worksheet can make printing and sharing simpler.
Colors or fonts are hard to read: Use strong contrast between text and background, and avoid relying on color alone to distinguish departments. Include department names or other text labels so that the meaning remains clear when printed in grayscale or viewed by someone with color-vision differences.
SmartArt compared with other Excel options
SmartArt is usually the quickest built-in choice for a polished, conventional hierarchy. It automatically manages connectors and basic layout, so you can focus on the reporting structure. Its tradeoff is limited control over individual positioning and no automatic link to an employee data table.
Shapes and connector lines offer more freedom. You can draw boxes where you want them and connect them manually, which helps with unusual structures or custom annotations. However, moving a manager may require adjusting several connectors, and keeping a large diagram aligned takes more work. Shapes are best when the chart needs a bespoke appearance and the structure is relatively stable.
A worksheet table is better for searching, filtering, and checking employee records, but it does not communicate hierarchy as visually as a diagram. Microsoft Visio and other diagramming tools may be more suitable for large or frequently changing organizations, depending on the tool and how its data features are configured. PowerPoint can also be convenient when the chart is primarily for a presentation. Choose SmartArt when the hierarchy is modest and the diagram is maintained by hand; choose another method when data linkage, scale, or layout control is essential.
Accessibility and sharing considerations
Make the chart understandable beyond its colors and visual arrangement. Use meaningful names and role labels, keep text readable, and avoid abbreviations that readers may not know. If you share the workbook electronically, add alternative text for the SmartArt graphic where appropriate, using the object’s alternative-text controls. Alternative text should summarize the chart’s purpose and structure; it does not need to repeat every name if a separate accessible employee list is available.
Check reading order and accessibility with Excel’s Accessibility Checker if the workbook will be used by people relying on assistive technology. A visual org chart can be difficult to navigate as a complex hierarchy when conveyed only as a graphic, so include the same reporting information in a structured table when practical. For external sharing, also confirm that the workbook contains only information intended for the audience and that any names or roles are current.
Frequently Asked Questions
How do I make an org chart in Excel?
Select Insert > SmartArt > Hierarchy, choose an organization-chart layout, and select OK. Enter names in the Text pane, using Tab to indent a report beneath a manager and Shift+Tab to move it up a level.
Can an Excel SmartArt org chart update automatically from a table?
No. A standard SmartArt graphic is not automatically linked to worksheet rows. You need to edit the graphic when names or reporting relationships change, or use a workflow or diagramming tool designed for data-linked charts.
How do I add a subordinate in an Excel org chart?
Select the manager’s shape and use SmartArt Design > Add Shape, choosing an option that places a shape below or after the selected item as appropriate. You can also add an entry in the Text pane and indent it with Tab.
Can I create an org chart in Excel for Mac?
Excel for Mac also provides SmartArt hierarchy layouts. Use the Insert tab’s SmartArt command, choose a hierarchy layout, and edit it with the contextual SmartArt tabs. Ribbon labels and the placement of controls can differ slightly by Mac version.
What should I use for a very large organization chart?
Consider separate charts by department, a diagramming application, or a data-oriented solution if the chart must be generated or updated from employee records. A single SmartArt graphic can become difficult to read as the number of people and levels grows.
Can I move individual SmartArt boxes freely?
SmartArt arranges shapes according to its hierarchy and selected layout, so it does not provide the same free placement as drawing separate shapes. If precise, independent positioning is essential, convert or recreate the graphic with individual shapes, then plan to maintain connectors manually.
Related
- Excel Power Query Jira API Key Name: What to Enter
- Excel Power Query: Merge All Files in a Folder
- Excel Power Query Merge Table Types and When to Use Them
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Mini Chart in Cell: Add and Format SparklinesIn Excel, a mini chart displayed in a worksheet cell is called a sparkline. In Excel for Microsoft…
- Excel Not Generating Charts? Fix the Common CausesIf Excel is not generating a chart, first select a clean range that includes the labels and values,…
- Excel Bar Chart Reverse Order: Steps, Options, and FixesYes. Select the bar chart’s category axis, open Format Axis, and under Axis Options turn on Categories in…
- Chart Not Showing in Excel? Causes, Checks, and FixesIf a chart is missing or blank in Excel for Microsoft 365 on Windows, first check whether Excel…
- Excel Pivot Table Range: How to Set, Change, and Fix RangesAn Excel PivotTable range is the set of source cells the PivotTable reads, including the column headers and…
- Excel Legend Order Wrong on Combo Charts? Fix ItTo fix a wrong legend order on an Excel combo chart, select the chart, choose Chart Design >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.