Yes. In Excel for Microsoft 365, you can create an org chart with Insert > SmartArt > Hierarchy > Organization Chart, then enter or paste employee names and arrange them by reporting level. Excel does not automatically turn a standard Name–Title–Reports To table into a finished chart; for a chart generated from that kind of data, Visio’s organization chart tools are a better fit.
What Excel can—and cannot—do
An organizational chart is a visual hierarchy: each box represents a person or role, and connecting lines show reporting relationships. Excel includes a SmartArt organization-chart layout, which is useful for creating a clear chart inside a workbook. You can add, move, format, and label its boxes without drawing every shape and connector yourself.
The important limitation is that SmartArt is not a live chart of your employee table. It does not read a Reports To column and automatically position every person under the correct manager. You arrange the hierarchy in SmartArt’s text pane, or build it with the chart’s shape controls. If the source data changes later, you generally need to update the chart separately.
That distinction helps answer the question behind “generate an org chart from Excel.” If you need a one-time visual that you can edit by hand, SmartArt is usually enough. If you need a chart created from structured records, especially for a larger organization, consider importing the Excel data into a dedicated diagramming tool such as Visio.
Prepare the employee data first
A little preparation makes the chart easier to build and reduces errors. Keep a clean source table in Excel, with one employee or position per row. A practical layout might include Employee ID, Name, Job Title, Department, and Reports To. The Reports To value should identify the employee’s direct manager, preferably using a stable ID rather than a name that could be shared by two people.
For example, a small table could list Maya Chen as Chief Executive Officer with no manager, Luis Ortiz as Finance Director reporting to Maya, and Priya Shah as Controller reporting to Luis. In the chart, Maya belongs at the top, Luis directly below her, and Priya below Luis. The data records the relationships; SmartArt’s text hierarchy or an import tool turns those relationships into visual levels.
- Use one consistent spelling and identifier for each employee and manager.
- Choose how to handle vacant roles, contractors, and temporary assignments before building the chart.
- Check that every manager named in Reports To also appears as an employee or role in the source data.
- Make sure the top-level person has a blank manager field, and look for accidental reporting loops.
- Decide whether the chart should show names, titles, departments, or a combination.
Excel Tables can help keep the source organized: select the data and use Insert > Table. A table makes it easier to filter and maintain records, but it does not itself create the org chart. Keep the source table intact even if you later build a separate SmartArt diagram.
Create a chart with SmartArt in Excel
In Excel for Microsoft 365 on Windows, select a worksheet location for the diagram, then choose Insert > SmartArt. In the SmartArt dialog, choose Hierarchy, select Organization Chart, and select OK. The chart appears on the sheet, along with a text pane where you can enter the hierarchy. The precise arrangement of controls can vary slightly with window size and Office updates.
Enter the top-level person first. Press Enter to add another item at the same level, and use Tab to make an item a subordinate of the item above it. Use Shift+Tab to move an item up one level. For example, enter Maya Chen, press Enter for Luis Ortiz, press Tab to place Luis under Maya, and then add Priya Shah as a subordinate of Luis. Check the resulting indentation before relying on the chart: indentation, not the order of rows in the original table, defines the reporting structure.
You can also select a shape and use SmartArt Design > Add Shape to add a subordinate, a shape before or after the selected one, or an assistant where the chosen layout supports it. Use the text pane for quick structural edits and the ribbon controls when you need to place a person in a specific relationship to a selected box. If the text pane is hidden, use the small arrow on the SmartArt graphic to show it.
When the hierarchy is correct, use SmartArt Design to choose a layout or SmartArt style, and use the Format tab to adjust individual shapes. Keep the design readable: long titles, many direct reports, and several levels can make a single-page chart crowded. You can resize the graphic by dragging its handles, but leave enough room for names and connecting lines. On Excel for Mac, SmartArt is also available from the Insert tab, though ribbon placement and dialog appearance can differ. The same basic hierarchy logic applies.
Build the chart from Excel records with Visio
If you want the software to use a spreadsheet’s reporting relationships to build the structure, Visio is a more suitable option than SmartArt. In the Visio desktop app, start an Organization Chart file or template and follow the organization-chart creation wizard. Depending on the Visio edition and interface, the template may be found by searching for Organization Chart from the new-file screen. Choose the option to use information stored in a file or database, then select the Excel workbook and map its columns when prompted.
Prepare the workbook to match the fields the wizard requests. Commonly, an import needs a field identifying each person, a field for the person’s name or label, and a field identifying the manager. Follow the wizard’s prompts rather than assuming that a column called Reports To will be recognized without mapping. Import options and availability can vary across Visio editions and versions, so check the features included with your specific desktop installation.
After import, review the chart against the source table. Confirm that the top position is correct, that each employee appears once, and that reports are under the intended managers. An imported chart is still a diagram that needs maintenance: do not assume that changing the Excel workbook will automatically refresh every Visio shape unless your particular workflow explicitly supports a data refresh.
This approach is especially useful when a hierarchy has many employees or needs a more formal diagram. It does require access to a compatible Visio desktop product, while SmartArt is available within Excel. If you only need a small chart and can arrange it manually, opening another application may add unnecessary work.
Choose the right workflow for the chart
The best method depends less on the word “Excel” than on how the finished chart will be used. SmartArt is convenient for a presentation-ready graphic in a workbook. A Visio import is more appropriate when the source is a structured employee list and the hierarchy is too large or changeable to arrange box by box. A manually drawn chart can work for a very small, unusual structure, but it takes more effort to keep shapes and connectors aligned.
- Use SmartArt for a small or medium chart, a one-time snapshot, or a diagram that must remain in the Excel file.
- Use Visio import when you want to build a diagram from employee records and have a compatible Visio desktop edition.
- Use a presentation or diagramming application if the primary deliverable is a slide or a diagram with complex visual requirements.
- Keep the source data separate when accuracy and later updates matter. Treat the chart as a view of the data, not as the only record of reporting lines.
Also consider the audience. A chart for an internal team may need names and roles, while a public-facing chart may be better with role titles only. If the organization is large, showing every employee can make the result hard to read. Department-level charts or separate charts for different teams may communicate the structure more clearly.
Common problems and how to prevent them
The most frequent issue is a person appearing at the wrong level. In SmartArt, check the text pane’s indentation and use Tab or Shift+Tab to correct the relationship. In an imported chart, check the manager values and field mapping. A single misspelled manager name or inconsistent ID can prevent an employee from appearing where expected.
Another problem is treating a reporting structure as if every relationship were a simple tree. A conventional org chart generally shows one primary manager for each person. Matrix organizations, where someone reports to both a functional manager and a project lead, need a deliberate choice: show the primary reporting line, create a separate project chart, or use a diagramming method that can communicate multiple relationships without implying that one is the other.
- Missing people: Check for blank names, excluded rows, or a manager value that does not match any record.
- Unexpected top-level boxes: Look for extra blank manager values or a hierarchy that has more than one root.
- Overlapping or tiny text: Shorten labels, widen the chart, reduce the number of levels shown, or split it into department charts.
- Out-of-date chart: Compare the diagram with the current source table after reorganizations; SmartArt does not automatically synchronize with ordinary employee rows.
- Confidential information: Include only details needed by the chart’s audience and follow your organization’s rules for sharing employee data.
Keeping the chart accurate and readable
Org charts can become outdated quickly after hiring, departures, or a reorganization. Include a “last updated” date on the worksheet or diagram, and identify who is responsible for reviewing it. For a recurring process, maintain the employee table as the source of truth and document how the chart is rebuilt. This makes it easier for another person to repeat the process and spot missing or duplicated records.
Before sharing, verify the chart from the top down and then check each manager’s direct reports. Compare names and titles with the source, confirm that vacancies are represented consistently, and ensure that connectors do not suggest a reporting relationship you did not intend. If the chart will be printed, use Print Preview to check page breaks and legibility. A large diagram may need a landscape page, a larger print size, or multiple pages rather than shrinking until the text is unreadable.
Frequently Asked Questions
Can Excel automatically make an org chart from a Reports To column?
Not with Excel’s standard SmartArt organization-chart workflow. SmartArt lets you create and edit the hierarchy, but it does not automatically map an ordinary employee table’s manager field into a finished chart. A Visio organization-chart import is a more direct option when supported by your edition.
What is the fastest way to make a small org chart in Excel?
Choose Insert > SmartArt > Hierarchy > Organization Chart, then build the levels in the text pane. Enter the top person first, use Enter for another item, Tab to create a subordinate, and Shift+Tab to promote an item.
Can I update the chart when the Excel table changes?
SmartArt does not automatically stay synchronized with a separate employee table. You need to edit the SmartArt yourself or rebuild the chart. If using Visio, confirm whether your specific import workflow offers a refresh option before relying on ongoing synchronization.
Can an org chart show two managers for one employee?
A conventional hierarchy is clearest when each person has one primary manager. For matrix reporting, decide which relationship the chart is intended to show, or create separate diagrams or a more specialized visual that clearly distinguishes the relationships.
Can I create an org chart in Excel for the web?
SmartArt features and editing options can differ between Excel desktop and Excel for the web. If you do not see the needed insertion or editing controls in the web app, use Excel for Microsoft 365 on Windows or Mac to create and adjust the SmartArt diagram.
Related
- Find Same Names in Two Excel Columns
- FIND in Excel: Syntax, Examples, and Common Errors
- Find the Max Date in Excel With Multiple Criteria Easily
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pie Chart Zero Labels: What Happens and How to Fix ItUsually, an Excel pie chart has no visible slice for a value of zero, so its label may…
- Excel Pivot Table: Remove Old Filter Values After RefreshTo remove deleted items from an Excel PivotTable filter, open PivotTable Options, set Number of items to retain…
- Pivot Chart Slicers: How to Add and Use ThemYes. In Excel for Microsoft 365 on Windows, select the PivotChart, choose PivotChart Analyze > Insert Slicer, select…
- Sort Excel Chart Data and Reorder Categories EasilyTo sort an Excel chart, sort the chart’s source data: select a cell in the data, choose Data…
- Excel Pivot Tables: How They Work and When to Use ThemAn Excel PivotTable is a tool for summarizing and exploring a larger list of data without changing the…
- Excel Pivot Chart: Count Unique ValuesYes. An Excel PivotChart can display a count of unique values, but its PivotTable must use the Data…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.