Yes—you can create an org chart from Excel data by organizing employee names and reporting levels, then inserting a hierarchy SmartArt graphic in Excel for Microsoft 365 on Windows. Excel does not automatically turn a roster into a live, data-linked org chart, so you will either build the hierarchy in SmartArt or use a tool such as desktop Visio when you need to generate a chart from a larger data file.
What Excel Can and Cannot Do
Excel includes SmartArt layouts for visualizing hierarchies, including an Organization Chart layout. You can enter names and job titles in the graphic, format the boxes, and place people at different levels. This works well for a small or moderately sized organization chart that you want to keep in a workbook.
The important limitation is that a SmartArt org chart is a graphic, not a report that continuously reads an employee table. Typing or changing a manager in the source worksheet does not automatically move that person in the chart. You must update the SmartArt separately, or choose a workflow designed to generate charts from structured source data. Keeping the data and graphic separate is manageable for a one-time presentation; it needs a deliberate update process if the roster changes often.
Prepare the Employee Data
Before building the visual, make the source list consistent. A basic roster might have columns for Employee ID, Employee Name, Job Title, Department, and Manager ID. The manager field should identify the employee’s direct manager, not a manager several levels above. An ID is often safer than matching on names because two employees can share a name or a person’s name can change.
For example, a small roster could show Elena Ruiz as the president with a blank Manager ID, Marcus Lee reporting to Elena, and Priya Shah and Owen Carter reporting to Marcus. The resulting hierarchy has Elena at the top, Marcus below her, and Priya and Owen as Marcus’s direct reports. Job titles and departments can be included in the box text if they help the intended audience.
Check the list for structural issues before you start. In particular:
- Give each employee one clear, unique identifier and one name to display.
- Use the same identifier spelling and format wherever a manager is referenced.
- Leave the top person’s manager field blank, and confirm that every other manager exists in the roster.
- Look for duplicate records, blank names, accidental spaces, and employees who report to themselves.
- Decide whether contractors, vacancies, assistants, or temporary reporting relationships belong in this version of the chart.
Excel can help you sort, filter, and review the roster, but a clean table is not by itself a finished hierarchy. A manager relationship is what determines the branches; a department label or alphabetical sort does not reliably establish who reports to whom.
Create the Chart With SmartArt
For a chart you are assembling directly in Excel, use the built-in hierarchy layout. In Excel for Microsoft 365 on Windows, follow these steps:
- Select the worksheet where you want the chart. If useful, keep the roster on a separate sheet so the source data remains easy to review.
- Choose Insert > SmartArt.
- In the SmartArt dialog, select Hierarchy, choose Organization Chart, and select OK.
- Open the SmartArt Text Pane if it is not visible. Enter the top person first, then add each direct report at the appropriate level beneath that person.
- Use the text pane’s indentation to show reporting levels. Press Enter to add another item; press Tab to demote an item one level, or Shift+Tab to promote it one level.
- Review the graphic from top to bottom, then use the SmartArt Design and Format tabs to adjust layout, colors, and appearance.
In the text pane, the outline levels create the reporting structure: a person indented beneath another person is represented as a subordinate. For the example above, Elena is the first-level entry, Marcus is indented one level, and Priya and Owen are indented beneath Marcus. Check the visual itself after entering the outline, especially when moving several people, because an unintended indent can create a plausible-looking but incorrect branch.
You can also select a box and use SmartArt Design > Add Shape to add a person in relation to the selected box. The available choices include adding a shape above, below, before, or after, and an assistant option in organization-chart layouts. The wording and available choices depend on what you select. For a larger outline, editing the text pane can be quicker than adding boxes one at a time.
Make the Chart Readable
Org charts become hard to use when they try to show every detail. Include the information readers need to understand responsibility, commonly a person’s name and role. A box might read Elena Ruiz on one line and Chief Executive Officer on the next. If department, location, or contact details matter, consider whether they belong in the chart or in the accompanying roster instead.
Use a consistent naming style, box size, and level of detail. Keep the top of the chart visually distinct without making lower-level roles look unimportant. If there are many direct reports, a wide chart may be difficult to print or view on a standard screen. SmartArt offers alternate hierarchy layouts, but changing the layout cannot make an oversized organization simple; splitting it into department-level charts may be easier to follow.
After arranging the boxes, inspect connector lines and labels at normal viewing size. A chart that looks clear when zoomed in may be unreadable when printed or inserted into a presentation. Consider landscape page orientation, print scaling, or placing separate divisions on separate sheets. Avoid using color as the only way to communicate a relationship, since the chart may be printed in grayscale or viewed by someone with color-vision differences.
Keep the Chart Current
Because SmartArt is not automatically linked to the employee table, define which version is authoritative. A practical process is to maintain the roster as the source of truth, record an update date, and check the chart against the manager column whenever roles change. For a small team, this may simply mean updating the relevant names and branches in SmartArt after each approved change.
If you expect frequent changes, keep a stable employee identifier in the roster and review reporting relationships systematically rather than relying on memory. Before sharing a revised chart, compare each manager relationship with the source list and look for employees who were omitted when the graphic was edited. You can preserve the roster and chart in the same workbook, but keeping both together does not create a live connection between them.
For a chart that must be regenerated repeatedly from a table, a purpose-built import workflow is more appropriate. Desktop Visio includes organization-chart creation options in some editions and can use structured employee information as input; availability and steps depend on the Visio version and license. Check the current Visio documentation and your organization’s Microsoft 365 licensing before relying on that route. If you stay in Excel, SmartArt is a straightforward visual option, but do not describe it as an automatically synchronized chart.
Choosing Between SmartArt, Visio, and Shapes
The best approach depends on how many people are shown, how often the chart changes, and how much control you need over its appearance.
- SmartArt in Excel: A convenient choice for a chart maintained by hand in a workbook. It is quick to format, but it does not update itself from the roster.
- Desktop Visio: Worth considering when you need a chart generated from structured data or need more diagram-specific control. Confirm that your edition supports the required organization-chart workflow.
- Excel shapes and connectors: Useful for a small chart with unusual labels or a custom visual design. Insert shapes and connector lines manually, but expect more work when positions or reporting lines change.
There is no single employee-count threshold at which one method becomes mandatory. Ten people with complicated reporting relationships may be harder to represent than many people in a simple structure. The practical test is whether the chart can be read, checked against its source, and maintained without frequent manual mistakes.
Common Problems and Misconceptions
A frequent misconception is that placing a manager column beside employee names makes Excel infer the hierarchy when SmartArt is inserted. It does not: SmartArt needs the hierarchy entered into its graphic, and the source table remains separate. Another common mistake is sorting names alphabetically and assuming that the resulting order represents reporting levels. Sorting can help find records, but it cannot replace the manager relationship.
Missing managers often cause confusion. If a Manager ID does not match an employee in the list, decide whether the record is an error, an external reporting relationship, or an intentional exception before drawing the chart. If an employee has two managers, first establish what the chart is meant to communicate: a conventional organization chart normally shows one primary reporting line, while a matrix relationship may need a different diagram or a clearly labeled secondary connection.
Large charts may become cramped, and SmartArt can rearrange boxes when the text or layout changes. Try a different hierarchy layout, shorten unnecessary wording, or divide the chart into a company overview and department views. Do not shrink the text until it is unreadable simply to fit everything on one printed page. For a chart that will be reviewed, also include a date or version note so readers know when the structure was last checked.
Frequently Asked Questions
Can Excel automatically create an org chart from a manager column?
No. Excel SmartArt does not automatically interpret a roster’s manager column and build a synchronized chart. You can use the list to assemble the hierarchy manually, or investigate a data-import workflow such as one available in some desktop Visio editions.
Can I link SmartArt boxes to cells?
SmartArt text is not a live cell link that updates the reporting structure when worksheet data changes. You can copy information from cells into the graphic, but you should expect to revise the SmartArt when the roster changes.
Can I include job titles in an Excel org chart?
Yes. Add a title below each person’s name in the SmartArt text, or include it in the box text. Keep formatting consistent and limit the detail so boxes remain easy to read.
Can I make an org chart in Excel on a Mac?
Excel for Mac also supports SmartArt hierarchy graphics. The ribbon layout can differ from Windows, but look under Insert for SmartArt and choose a hierarchy organization-chart layout. If you use a Windows-specific instruction, check the corresponding Mac ribbon label in your installed version.
What should I do if the chart is too large to fit?
Try a different SmartArt hierarchy layout, simplify box text, or create separate charts for major departments with a smaller overview chart. Choose a page orientation and print scaling that preserve readable text rather than forcing the entire organization onto one page.
Final Check Before Sharing
Before distributing the workbook, compare every box and reporting line with the current roster, confirm that names and titles are spelled correctly, and ensure the chart has a clear date or context. Check how it appears both on screen and in print, particularly if readers will use it to find decision-makers or understand accountability. Excel can make a useful org chart from Excel data, provided you treat SmartArt as a visual representation that needs to be created and maintained—not as an automatically synchronized report.
Related
- Excel Audit Rate Limits: What They Mean and How to Track
- Attendance and Leave Tracker Excel Template: Setup Guide
- Audit Plan Template Excel: Build a Usable Workbook
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Stacked Line Chart ExplainedAn Excel stacked line chart plots each series as a running total of the series before it, rather…
- Excel Pivot Table: How to Hide Blank Rows and ValuesTo hide a blank category in an Excel PivotTable, open the filter arrow for its Row Labels or…
- How to Graph Z Scores in ExcelTo graph z scores in Excel, calculate each score’s z value, then plot the results with a histogram…
- Excel Chart Filter: How to Show or Hide DataAn Excel chart filter lets you show or hide selected data series or categories without changing the chart’s…
- How to Remove a Trendline from an Excel ChartTo remove a trendline from an Excel chart in Microsoft 365 for Windows, click the trendline to select…
- Excel Pivot Table Show Report Filter Pages ExplainedIn Excel for Microsoft 365 on Windows, select the PivotTable, open PivotTable Analyze > Options, and choose Show…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.