Yes. In Excel for Microsoft 365 on Windows, turn a small employee list into an org chart by choosing Insert > SmartArt > Hierarchy > Organization Chart, then entering each person in the SmartArt text pane and setting their level with Tab or Shift+Tab. Excel does not automatically convert an ordinary table into a live, data-linked org chart; for a larger list you can import the Excel data into Visio’s Organization Chart Wizard, if your Visio edition includes it.
What Excel can and cannot do
An org chart shows reporting relationships: who reports to whom, usually with a top-level leader and progressively lower levels. The important information is therefore not just an employee’s name and job title, but also the identity of their manager. A table with columns for Employee, Title, and Manager can serve as the source for a chart, but it is not itself the chart’s hierarchy.
Excel’s built-in SmartArt tool provides prepared hierarchy layouts, including an Organization Chart layout. It is useful for a compact chart that you can format and print alongside other spreadsheet content. You can add, remove, and rearrange shapes, but SmartArt does not automatically read a Manager column or stay synchronized with the rows in your table. If the source list changes, you must update the SmartArt separately.
That distinction matters when choosing a method. For a one-time chart of a small team, SmartArt is straightforward. For a large workforce, frequent staffing changes, or a chart that should be generated from a structured source, an import workflow in Visio is generally more appropriate. Excel formulas can help check and organize your source data, but a formula alone does not create a visual org chart.
Prepare the Excel list first
Before drawing anything, make the reporting data unambiguous. A practical source table might have one row per person and columns named Employee ID, Name, Job Title, and Manager ID. Using a manager’s unique ID instead of their name helps distinguish people who share a name. If your organization does not use IDs, use a manager name consistently and check for duplicates.
Each person should normally have one direct manager. The head of the organization can have a blank manager field, or a clear label such as “No manager,” depending on the import method. Avoid placing several employees in one cell or using merged cells in the source table: separate rows and fields are easier to validate and import.
- Check that every nonblank manager value matches a person in the employee list.
- Look for duplicate employee records and inconsistent spellings of names or titles.
- Confirm there is a single top-level person, unless the intended chart has multiple roots.
- Check that reporting relationships do not form a loop, such as A reporting to B while B reports to A.
- Decide whether the chart should show names only, or names plus titles, departments, or locations.
For example, a table could contain Maya Chen, President, with no manager; Luis Ortega, Sales Director, reporting to Maya; and Priya Shah, Account Manager, reporting to Luis. Those manager relationships define the branches. Sorting the original table alphabetically may make it easier to find people, but it does not by itself establish the hierarchy.
Create a small chart with SmartArt
For a modest number of people, build the chart directly in the worksheet. First decide the hierarchy from your source list. Then use the following steps:
- Select a blank cell where there is room for the chart. Choose Insert > SmartArt, select Hierarchy, choose Organization Chart, and select OK.
- Open the SmartArt text pane using the small arrow on the left edge of the graphic if it is not already visible. Enter the top person first.
- Press Enter to create another item at the same level. Press Tab while the insertion point is at the start of a new item to make it a subordinate level; use Shift+Tab to promote it back up a level.
- Continue entering names in reporting order. For example, enter the president, then the sales director as a subordinate, then the account manager as a subordinate of the sales director.
- Review the visual tree against the Manager column. If a person is under the wrong manager, change the text-pane level or select the shape and use SmartArt Design > Promote or Demote.
You can also select a shape and choose SmartArt Design > Add Shape to add a position relative to it. The menu includes choices such as Add Shape Below and Add Assistant. The exact controls shown can depend on which shape is selected. To remove someone, select their shape and press Delete; then check that the remaining reporting structure is still correct.
Typing directly into the text pane is usually more reliable than pasting a copied Excel table and expecting Excel to infer each reporting relationship. A flat paste does not tell SmartArt which manager belongs above each employee. If you paste names, still inspect and set the hierarchy levels deliberately. Keep the source table in the workbook as the reference, rather than treating the picture as the only record.
When Visio is a better choice
Visio’s Organization Chart Wizard is designed to build an org chart from structured data, including an Excel file. In eligible Visio desktop editions, look for the Organization Chart template under File > New and follow the wizard’s option to create a chart from information stored in a file. The prompts let you identify fields for names and reporting relationships; the exact screens vary by Visio version and available license.
Prepare the Excel source with one employee per row and a clear field that identifies that employee’s manager. The wizard needs to know which column contains the person’s name and which value identifies the person they report to. A consistent employee ID and manager ID pair is often less ambiguous than names alone. Review the field mapping before creating the diagram, then inspect the result for missing people, misplaced branches, or unexpected top-level positions.
Visio is worth considering when the chart contains many people, must be laid out or printed at a larger scale, or needs to be recreated from a maintained data source. It is not simply an Excel command, and access depends on the Visio edition and license. If the template or import option is unavailable, check your organization’s Microsoft licensing or use SmartArt for a smaller, manually maintained chart. Do not assume that changes to the Excel file will automatically update an existing diagram; confirm the refresh or re-import process available in your particular Visio setup.
Choose a layout people can read
A chart is useful only if readers can follow it. Keep each box short enough to scan. Names and job titles are common; adding phone numbers, locations, or several lines of extra detail can make the diagram crowded. If readers need those details, keep them in the source table or provide a separate directory.
For a team with several branches, use consistent naming and formatting across equivalent roles. A wide organization may become difficult to read on a standard worksheet or printed page. Consider splitting it into separate department charts with a clear indication of where each department reports, rather than shrinking every box until the text is tiny. SmartArt offers hierarchy layouts and design choices on the SmartArt Design and Format tabs, but decorative colors should not obscure the reporting lines.
Think about what the chart is meant to communicate. A formal reporting chart should show direct managers, not every project collaborator. If a person reports to one manager but works closely with another team, adding a second connecting line can imply a different authority structure. Explain any unusual relationships in a legend or accompanying note instead of relying on readers to guess.
Keep the chart accurate when the list changes
SmartArt is a visual object rather than a live view of the employee table. When someone joins, leaves, changes title, or changes manager, update both the source list and the chart, then compare them. A simple review routine can prevent a polished diagram from becoming out of date:
- Assign someone responsibility for maintaining the source list and chart.
- Record a last-reviewed date near the chart, especially if it is shared or printed.
- After edits, compare each employee’s manager in the table with their parent shape in the chart.
- Keep an unchanged copy of the source data before a major restructuring or bulk import.
If reporting lines change often, manually editing SmartArt can become tedious. In that case, preserve the Excel table as the authoritative record and investigate a repeatable Visio import or an organizational charting tool approved by your workplace. The key is to define which file is the source of truth; otherwise, two versions can drift apart.
Common problems and how to fix them
Everyone appears at the same level. The names may have been entered as siblings. In the SmartArt text pane, use Tab to demote a person under the preceding level and Shift+Tab to promote them. Then check the shape positions against the manager field in the source.
A person is under the wrong manager. Do not fix this by dragging boxes until they look right. Change the hierarchy level or use the SmartArt Design controls so the structure matches the actual reporting relationship. For imported charts, revisit the mapped manager field and check for inconsistent IDs or spelling.
The chart is too wide or text is clipped. Reduce unnecessary detail, enlarge the graphic area, or split the chart by department. A page orientation or print scaling change may help, but scaling a complex chart to fit one page can make names unreadable. Check Print Preview before distributing it.
The list has two managers for one person. A conventional org chart usually represents one primary reporting line. Decide which relationship the chart is intended to show. For matrix reporting, use a clear primary manager and describe secondary or project relationships separately; otherwise the diagram can suggest a structure that the source data does not support.
Frequently Asked Questions
Can Excel automatically make an org chart from a Manager column?
Not with SmartArt alone. SmartArt lets you create a hierarchy, but you must set the levels yourself. Visio’s Organization Chart Wizard can use structured Excel data in eligible desktop editions, subject to the available template and license.
Can I paste an Excel list directly into SmartArt?
You can enter or paste text into the SmartArt text pane, but a flat list does not reliably communicate who reports to whom. After pasting, set the hierarchy levels and verify every branch against the manager data.
How do I add a manager or employee to an Excel org chart?
Select the relevant SmartArt shape and use SmartArt Design > Add Shape to choose where the new position belongs. For a source-data-based Visio chart, update the source and use the re-import or refresh procedure supported by that Visio setup.
Will my SmartArt org chart update when I edit the spreadsheet?
No. A SmartArt chart is not automatically linked to the employee rows. Update the SmartArt as well as the table, or use a workflow designed to regenerate the chart from its source data.
Can an org chart show dotted-line or multiple reporting relationships?
A basic hierarchy is clearest when it shows one primary manager per person. You can add explanatory notes or separate connectors for secondary relationships, but label them carefully so readers can distinguish them from the main reporting structure.
Protect and share the finished chart
Org charts can contain employee names, job titles, and internal reporting information. Before sending a workbook outside its intended audience, check the organization’s sharing rules and remove details that recipients do not need. Use appropriate file permissions, and remember that hiding a worksheet is not the same as restricting access to its contents.
For a final quality check, compare the chart with the source list, confirm that names and titles are current, and review the workbook at the size where people will actually view or print it. A clear, accurate chart starts with clean reporting data; the SmartArt or Visio diagram is only the visual presentation of that information.
Related
- Simple Inventory Tracking in Excel: A Practical Setup
- Excel Insert Row Shortcut: Windows, Mac, and Tips Guide
- Excel Shortcut to Switch Between Sheets
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Pareto Chart in Excel: Create and Format a Clear AnalysisIn Microsoft Excel for Microsoft 365 on Windows, select raw category observations and choose Insert > Insert Statistic…
- Combo Chart Icon in Excel: Where to Find and Use ItIn Excel for Microsoft 365 on Windows, find the combo chart icon on the Insert tab, in the…
- Power Pivot Basics: Data Models, DAX, and PivotTablesPower Pivot is an Excel feature for building data models: it can combine tables from different sources, connect…
- Excel Waterfall Chart Total Column: How to Add OneTo make a column a total in an Excel waterfall chart, select that individual column, right-click it, and…
- Excel Power Pivot Tables: How They Work and When to Use ThemAn Excel Power Pivot table usually means a PivotTable built from Excel’s Data Model, where Power Pivot can…
- Excel Donut Chart: How to Create, Format, and Use OneAn Excel donut chart displays how categories contribute to a whole, using colored segments arranged around a central…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.