Yes. In Excel for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy > Organization Chart, then enter or paste names into the SmartArt Text pane and indent each person beneath their manager. If your employee data is already in rows, Excel does not automatically turn a manager-and-employee table into an org chart; first organize the reporting relationships, then build the hierarchy in SmartArt.
What Excel Can—and Cannot—Create
Excel includes organizational-chart layouts in SmartArt, so you can create a visual reporting structure without drawing every box and connector yourself. SmartArt handles the arrangement of boxes and lines as you add, remove, or move entries. You can also apply built-in colors and styles, change the chart layout, and edit the text later.
The important limitation is that SmartArt is not a direct data-import tool for a typical employee list. A table with columns such as Employee, Job Title, and Manager is useful source data, but Excel does not automatically match manager names to employees and generate a connected chart from that table with one command. You must express the relationships as a hierarchy in SmartArt, or use another tool or a custom process to build a diagram from structured data.
This distinction affects how you plan the work. A small team chart can be entered directly in SmartArt. For a larger organization, clean and verify the source list first, then decide whether manual SmartArt entry is practical or whether a diagramming tool that supports data linking is a better fit.
Prepare the Employee Data
Before building the chart, make sure the source information is consistent. A simple worksheet table might have one row per employee and columns for Employee Name, Job Title, Manager, and Department. Use one spelling for each person throughout the list, and identify the top-level leader with a blank manager field or a clear value such as No Manager. Do not leave a manager relationship ambiguous.
- Use a stable name or ID. Two employees can share a name, so an employee ID can help distinguish them in the source table. The ID usually does not need to appear in the visual chart.
- Check every manager reference. Each manager listed should correspond to a person in the employee list, except for the top leader, who has no manager in the chart.
- Look for reporting loops. Someone must not ultimately report to themselves. A circular chain cannot be represented as a normal organization tree.
- Choose what the chart should communicate. Decide whether boxes will show names only, names and titles, or additional details. More text makes a chart harder to scan.
- Decide which employees belong in this view. A company-wide chart may be too large to read on a page. A department or team view is often more useful.
Keep the source table separate from the visual chart when possible. That makes it easier to correct a title or manager relationship without losing the original record, and it gives you a reference when reviewing the finished diagram.
Create the Chart with SmartArt
In Excel for Microsoft 365 on Windows, create the diagram with these steps:
- Open the worksheet where you want the chart, then select Insert > SmartArt.
- In the SmartArt gallery, choose Hierarchy, select Organization Chart, and select OK.
- Click the chart and open the SmartArt Design tab. If the Text Pane is not visible, select SmartArt Design > Text Pane.
- Enter the top leader as the first item. Press Enter to add another item, then use Tab at the start of an item to indent it beneath the item above. Use Shift+Tab at the start of an item to move it up one level.
- Continue entering people in reporting order. Review the chart itself as you work: an indented name should appear as a subordinate of the nearest preceding person at the level above it.
For example, enter a chief executive first, then the department heads at the next level. Indent each department head one level beneath the chief executive. Enter each department’s employees below its head, indented one additional level. A person’s position in the outline—not merely their order in the employee table—determines the reporting line.
You can also select a box and use SmartArt Design > Add Shape to add a colleague or subordinate. The menu includes choices such as Add Shape After, Add Shape Before, Add Shape Above, and Add Shape Below; the available choices depend on the selected shape and layout. The Text Pane is often quicker for creating the initial outline, while Add Shape is handy for small changes to an existing chart.
Turn a Table into a Hierarchy
If your data is arranged as one employee per row, do not simply sort the rows alphabetically and expect the chart to infer the reporting structure. Instead, use the Manager column to group employees under the correct supervisors. Start with the person who has no manager, list that person’s direct reports, and then list each direct report’s own employees beneath them. Repeat until all included employees have a place.
Suppose a table contains Avery Chen, Chief Executive, with no manager; Jordan Lee, Operations Director, reporting to Avery; and Morgan Patel, Operations Manager, reporting to Jordan. The SmartArt outline should place Avery at the top, Jordan one level below, and Morgan one level below Jordan. The sequence in the original table does not matter as much as the final indentation. If you have several managers, keep each manager’s reports together in the outline to make review easier.
For a lengthy list, prepare the outline in a separate area before entering it into SmartArt. Use a temporary column or a printed review copy to sort and group employees by manager, then verify each branch against the source table. This is a manual transformation, but it reduces the chance of accidentally showing a peer as someone’s subordinate. Do not assume that Excel’s normal table sorting, filtering, or grouping changes SmartArt relationships; those actions affect worksheet data, not the chart’s hierarchy.
Make the Chart Readable
Once the reporting lines are correct, select the chart and use the SmartArt Design and Shape Format tabs to refine its appearance. SmartArt Design offers layout, color, and style choices; Shape Format includes controls for text and shape formatting. The exact set of controls can vary with the selected layout and Excel window size.
Keep box text short. A name on the first line and title on the second is usually easier to scan than a paragraph of contact details. If titles differ greatly in length, the widest text can make the whole chart spread out. Consider abbreviating standard titles consistently or creating separate charts for different departments rather than shrinking the font until it is difficult to read.
- Use a consistent format for names and job titles.
- Choose colors that distinguish levels or departments only when the distinction has a clear meaning.
- Check that connector lines remain visible and that boxes do not overlap.
- Use a page orientation and print scale that keep names legible; preview the result before sharing or printing.
SmartArt rearranges shapes as the hierarchy changes, but a large chart can still become too wide or tall for a normal worksheet view. Zooming out helps with editing the overall structure, while a page break or separate department view may be better for a readable printed copy.
Keep the Chart Accurate as People Change
A SmartArt chart is a visual object, not a live view of the employee table. If you change a manager in the source table, Excel will not automatically move that person’s box in the chart. Update both the source record and the SmartArt hierarchy, then compare them before distributing the workbook.
For recurring updates, assign someone to maintain the chart and note when it was last reviewed. A useful check is to compare every employee’s manager in the table with the person directly above them in the chart. Also check for new hires, departures, temporary reporting arrangements, and title changes. If the chart is only a snapshot for a presentation, show an as-of date so readers know when the structure was current.
Save the workbook as an Excel workbook, such as an .xlsx file, to preserve the editable chart. If recipients only need to view it, a PDF can preserve the page layout, but it is not a convenient format for editing the SmartArt. Keep an editable copy for future revisions.
Common Problems and How to Fix Them
- Everyone appears at the same level: The outline has not been indented into reporting levels. In the Text Pane, place the cursor at the start of an item and press Tab to demote it, or Shift+Tab to promote it.
- A person reports to the wrong manager: Check the outline order and indentation. A subordinate belongs beneath the nearest preceding person at the next higher level, not necessarily beneath the employee whose name is closest in the source table.
- Names or titles are cut off: Shorten the text, adjust the chart size, or choose a layout with more room. Enlarging the chart may make it extend beyond the worksheet or print page.
- The chart is too crowded: Show only the levels or department relevant to the audience, or divide the information into several charts. A single diagram is not automatically clearer just because it includes every employee.
- Changes in the source table do not appear: SmartArt does not stay linked to ordinary employee rows. Edit the SmartArt separately and verify the updated chart against the data.
If the Text Pane is closed, select the SmartArt graphic and reopen it from the SmartArt Design tab. If the chart becomes difficult to edit, make a copy of the worksheet or workbook before major restructuring so you can compare the revision with the previous version.
When to Use Another Tool
SmartArt is a sensible choice when the chart is modest in size, needs occasional updates, and can be checked manually. It is built into Excel and keeps the diagram in the workbook, which is convenient for a team document or a simple presentation. It is less suitable when the hierarchy changes frequently or must always reflect a large, authoritative employee database.
For a complex organization, consider a dedicated diagramming application or an approved organizational-chart system that can connect to structured data. Such tools may offer data import, larger-chart navigation, or automated refresh features, depending on the product and licensing. Check whether the tool supports your data source and whether it handles employee identifiers and privacy requirements appropriately. A manually drawn chart in Excel can be an alternative for a very small team, but shapes and connectors require more upkeep than SmartArt and can become misaligned when boxes move.
Frequently Asked Questions
Can Excel automatically create an org chart from an employee list?
Not directly from a standard table of employees and managers using a built-in one-click conversion. Excel’s SmartArt Organization Chart layout requires you to enter the hierarchy. A separate tool or custom workflow may support importing structured reporting data.
How do I show an assistant or a coworker at the same level?
Select the relevant SmartArt box and use SmartArt Design > Add Shape to choose an appropriate position, such as adding a colleague or an assistant where that option is available. Check the resulting layout because some layouts display these relationships differently.
Can I change the chart after I create it?
Yes. Select the SmartArt graphic to edit text in the Text Pane, change indentation, add or remove shapes, or select another hierarchy layout. Review the whole chart after a structural change because SmartArt may reposition boxes.
Will the chart update when I change the employee table?
No. A normal SmartArt organization chart is not automatically linked to employee rows. Update the chart as well as the source table, and verify that reporting lines still match.
Can I make an org chart in Excel for Mac?
Excel for Mac also provides SmartArt hierarchy graphics. The ribbon and dialog arrangement can differ slightly from Windows, so look under Insert for SmartArt and choose a hierarchy organization-chart layout. The steps for entering and indenting the outline are substantially the same.
Related
- What Column Number Is V in Excel? Find It in Seconds
- How to Combine Two Cells in Excel and Keep Both Values
- Column J Number in Excel: How to Find and Use It Easily
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Bubble Chart Data Labels: Add and Format ThemTo add labels to an Excel bubble chart in Microsoft 365 for Windows, select the chart, choose Chart…
- Dashboard from Excel Data: Build a Clear, Useful ViewYes. To make a dashboard from Excel data, organize the source as a clean Excel Table, summarize it…
- Google Sheets Pivot Tables: Create, Customize, RefreshTo create a pivot table in Google Sheets, select a range of data, choose Insert > Pivot table,…
- Insert a Live Excel Chart Into PowerPoint and Update ItTo insert a live Excel chart into PowerPoint, copy the chart in Excel, then in PowerPoint for Microsoft…
- Excel Pivot Chart Axis: Switch Rows and Columns EasilyTo switch what an Excel PivotChart shows across its category axis and in its legend, select the chart,…
- Does Google Sheets Have Pivot Tables? How to Use ThemYes. Google Sheets has pivot tables, which let you summarize and reorganize rows of data without changing the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.