Yes. In Excel for Microsoft 365 on Windows, you can turn employee names and reporting relationships into an org chart with Insert > SmartArt > Hierarchy > Organization Chart. Excel does not automatically convert a manager-and-employee table into a finished chart, so you must arrange the relationships in SmartArt’s text pane or use a separate diagramming tool for a larger, frequently updated chart.
What Excel can and cannot do
Excel includes organization-chart layouts through SmartArt. These are useful for a small or moderately sized hierarchy that you want to present in a workbook, print, or share. You can add names, job titles, and reporting levels, then adjust the layout and appearance using the SmartArt controls.
The important limitation is that a normal Excel table is not a live source for a SmartArt org chart. A table with columns such as Employee, Title, and Manager does not have a built-in command that automatically maps every manager relationship to a box and connecting line. SmartArt stores the diagram as a graphic, separate from the rows in your table. If someone changes jobs in the source data, the chart will not update itself.
That distinction helps set expectations: Excel is a reasonable choice when the hierarchy is stable and the chart is relatively compact. If you need automatic refreshes, hundreds of employees, or repeated reporting from changing data, consider a tool designed to generate diagrams from structured data.
Prepare the employee data first
Before drawing the chart, make the source data consistent. Keep one employee per row and use clear column headings. A practical starting layout is Employee, Job Title, Manager, and Department. The Manager value should match the employee’s manager as written in the Employee column. For the top person in the organization, leave Manager blank or use a consistent label such as CEO, provided you understand how you will treat that row when building the chart.
For example, a simple table might contain:
- Jordan Lee | Chief Executive Officer | blank | Executive
- Ravi Shah | Sales Director | Jordan Lee | Sales
- Casey Morgan | Sales Manager | Ravi Shah | Sales
- Alex Kim | Account Executive | Casey Morgan | Sales
Check that each non-root employee has one intended manager, that every manager name refers to a person in the data, and that there are no accidental spelling variations. Avoid merged cells and blank rows within the list. If two people share a name, include a distinguishing detail in the chart label or use an employee ID in your source records to help you verify the relationships.
Sorting the table by name or manager can make it easier to inspect, but sorting alone does not create the hierarchy. The chart needs a top-down outline: the CEO first, the CEO’s direct reports beneath that person, and each manager’s reports at the next level.
Create the org chart with SmartArt
- In Excel for Microsoft 365 on Windows, select a blank cell near where you want the diagram, then choose Insert > SmartArt.
- In the Choose a SmartArt Graphic window, select Hierarchy, choose Organization Chart, and select OK.
- Click the SmartArt graphic and open its text pane. If the pane is not visible, use SmartArt Design > Create Graphic > Text Pane.
- Enter the top person on the first line. Add each direct report on a new line and demote it one level in the text outline. Add that person’s direct reports one level below them, continuing down the reporting structure.
- Use the text pane’s promote and demote controls to correct a person’s level. In the outline, Tab demotes a selected line and Shift+Tab promotes it; make sure the text pane has focus before using these keys.
Each line in the outline represents a box, and its indentation determines its place in the hierarchy. You can label a box with just a name or include a title, for example “Ravi Shah — Sales Director.” Keep labels short enough to fit. If you have the employee table open beside the SmartArt, work through it manager by manager and check each person’s level as you go.
You can also add or remove boxes after creating the outline. Select a shape, then use SmartArt Design > Create Graphic > Add Shape to add a colleague or subordinate. For a reporting change, it is usually clearer to revise the outline and then inspect the resulting chart than to rely on moving boxes visually, because the text outline controls the reporting levels.
Make a large chart readable
An org chart can become difficult to read long before the data becomes difficult to store. A wide team of direct reports may stretch across the worksheet, while several management levels can make the graphic too tall for a printed page. SmartArt offers different layouts, but changing layouts cannot remove the underlying complexity.
Try these practical adjustments:
- Use names and concise job titles rather than long descriptions or contact details.
- Choose a layout from SmartArt Design > Layouts that better accommodates the shape of your hierarchy.
- Resize the graphic using its corner handles, then check that text remains legible at the intended print or screen size.
- Split a very broad organization into separate department charts, and make the parent department or executive clear on each one.
- Use consistent capitalization and label order, such as name on the first line and title on the second.
For a chart intended for printing, check the page before distributing it. Use Page Layout options to set orientation and scaling, and open File > Print to review the preview. Scaling an enormous chart onto one page may technically fit it, but make the words too small to read; multiple pages or department-level charts may be more useful.
Format and check reporting relationships
Select the SmartArt graphic to see the contextual SmartArt Design and SmartArt Format tabs. SmartArt Design provides layout and color choices, while SmartArt Format provides options for selected shapes, such as shape styling and text formatting. Choose a restrained color scheme and use color consistently. For instance, a department color can help readers scan the chart, but color should not be the only way to communicate a reporting distinction.
Review the chart against the source table before sharing it. Start at the top and trace each connector down: every employee should appear once, every box should sit beneath the correct manager, and each branch should stop at the intended level. Check any unusually wide or deep teams closely. A diagram may look plausible even when a line was indented one level too far.
For a sensitive or internal chart, include only the information needed to explain the structure. Phone numbers, personal email addresses, and other employee details are generally unnecessary for an org chart. Also consider whether every viewer should receive the workbook, particularly if it contains the source roster on another sheet.
Updating the chart when the data changes
SmartArt and the employee table are separate objects. Adding a row to the table will not add a box to the chart, and changing a manager in the table will not reroute the corresponding connector. To update the diagram, edit the SmartArt text pane or its shapes, then compare the result with the current table. If the organization changes often, plan for this manual checking as part of the update process rather than assuming the graphic stays current.
A simple maintenance routine is to keep the source roster in a clearly named worksheet, include an “as of” date near the chart, and record who is responsible for revising it. When a manager changes, update the outline, inspect the affected branch, and verify that the old and new reporting relationships are represented correctly. Keeping the data and diagram in the same workbook makes comparison convenient, but it does not create a data connection between them.
Common problems and fixes
- Everyone appears at the same level: The text pane lines are not indented into a hierarchy. Demote reports beneath their manager and check the outline before formatting.
- A person is under the wrong manager: Compare the outline with the Manager column. Correct the person’s indentation level; do not assume sorting the table will fix the diagram.
- Names are cut off: Shorten labels, enlarge the graphic, or choose a more suitable layout. Shrinking the text too much makes the chart hard to use.
- The diagram is too wide: Separate it into department charts or use a layout that better suits the reporting structure. A single chart is not always the clearest option.
- Changes in the roster do not appear: This is expected because the SmartArt graphic is not automatically linked to the table. Update the graphic and verify it manually.
- There is no single top-level person: Decide whether the chart should show a shared leadership group, a parent organization, or separate charts. A conventional organization chart is easiest to interpret when its top level is explicit.
Excel, Visio, and other options
For a small chart maintained occasionally, Excel SmartArt keeps the visual close to the spreadsheet data and is straightforward to edit. PowerPoint also provides SmartArt hierarchy diagrams and may be more convenient when the chart is primarily for a presentation. In either case, SmartArt is a diagram you maintain; it is not automatically synchronized with an employee table just because both are in Office.
For more complex data-driven diagrams, Microsoft Visio may be a better fit where the relevant Visio edition or plan is available. Visio includes organization-chart capabilities intended for building diagrams from organizational information, but available features and licensing depend on the product and plan. Check current Microsoft documentation and your organization’s licensing before relying on a particular import or refresh workflow. Other diagramming products may also offer data import, but their compatibility, privacy terms, and update behavior vary.
Excel for Mac also has SmartArt through Insert > SmartArt, though the ribbon arrangement and available controls can differ from Windows. Excel for the web may not expose the same editing experience for every SmartArt feature. If you cannot find a control or edit the diagram in the browser, open the workbook in the desktop Excel app and use the Windows or Mac steps for that version.
Frequently Asked Questions
Can Excel automatically make an org chart from a list of employees?
No, not from a standard employee-and-manager table with a built-in one-click conversion in Excel. You can create the graphic with SmartArt, but you must build or adjust its hierarchy separately, or use another tool with a suitable data-driven workflow.
What columns do I need for an org chart in Excel?
At minimum, keep an employee name and the name of that employee’s manager. Job title and department are useful additions for labels and checking the chart. Use a consistent top-level convention for the person or group with no manager.
Can an Excel org chart update when I change the employee table?
Not when it is made with ordinary SmartArt. Changes to the table do not automatically alter the graphic. Edit the SmartArt and verify it against the revised data, or investigate a diagramming option designed for data-linked organizational charts.
How do I add a subordinate in SmartArt?
Select the relevant shape and use SmartArt Design > Create Graphic > Add Shape, choosing the appropriate subordinate option. You can also edit the text pane outline and place the new employee one level below the manager.
Can I make an org chart with several departments?
Yes. Put each department under its appropriate manager in the hierarchy. If the resulting chart is too broad or small to read, create separate department charts and identify the leader or parent group connecting them.
Is SmartArt available in Excel for Mac?
Excel for Mac includes SmartArt, typically accessed through Insert > SmartArt. Ribbon placement and some editing details differ by platform and version, so use the desktop app if the web version does not provide the controls you need.
Related
- Freeze in Excel: Keep Rows and Columns Visible on Screen
- Freeze a Specific Row in Excel: Steps, Limits, and Tips
- Freeze Panes in Excel: Keep Rows and Columns Visible
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Google Sheets Pivot Tables: Create, Edit, and AnalyzeYes. In Google Sheets, select a range of data and choose Insert > Pivot table, then use the…
- Excel Trendline Equation: How to Get It From Data in ExcelTo get an Excel trendline equation from data, make a chart, select its data series, and add a…
- Pivot Chart Examples for Excel: Sales, Trends, and MoreUseful Excel PivotChart examples include monthly sales by region, expenses by department, inventory by product category, and support…
- How to Insert a Dynamic Excel Chart in PowerPointTo insert a dynamic Excel chart in PowerPoint for Microsoft 365 on Windows, select the chart in Excel,…
- Google Sheets Chart Legend Labels: Edit and FixIn Google Sheets, chart legend labels usually come from the headings in the chart’s source data: edit the…
- Pivot Table Error Messages: Causes and FixesA PivotTable error message in Excel is not one single error: the wording points to the cause, such…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.