Yes. You can build an org chart in Excel by choosing Insert > SmartArt > Hierarchy > Organization Chart, then entering employee names and arranging them by reporting level. Excel does not automatically convert a typical employee table into a live, linked org chart; for charts that need to update from workbook data, consider Visio or another purpose-built tool.
What Excel can and cannot do
Excel includes Organization Chart layouts in SmartArt, so you can create a visual reporting structure without drawing every box from scratch. SmartArt is useful for a small or medium chart that you can maintain by hand. It provides boxes, connectors, and layout choices, and lets you add, remove, or reorganize positions.
The important limitation is that the SmartArt graphic is not a live view of an employee table. If you change a person’s manager in the worksheet, Excel will not automatically move that person’s box. You must update the SmartArt separately. This distinction matters when a chart is used for regular staffing reports: the worksheet and diagram can drift out of sync unless someone owns the update process.
There are therefore two different tasks people may mean by “build an org chart from Excel data”: create a diagram in an Excel workbook based on a list, or import workbook records into a tool that can generate and refresh a diagram. SmartArt handles the first task well when the hierarchy is manageable. Visio’s organization-chart features are a better fit for importing structured employee records and producing larger diagrams.
Prepare the employee data first
A well-structured source list makes the chart easier to build and check, even if you plan to enter the hierarchy into SmartArt manually. Keep one employee per row, with separate columns for information such as employee ID, name, job title, department, and manager ID or manager name. Use consistent spelling and avoid combining several details in one cell.
For example, a basic list might have columns named Employee ID, Name, Title, and Manager ID. The chief executive’s Manager ID can be blank. Other rows point to the ID of the person they report to. IDs are safer than names as references: two employees can share a name, and names may change, while a unique ID can still identify the correct record.
Before charting, check the data for issues that can make the hierarchy ambiguous:
- Confirm that each employee appears only once and each non-top-level employee has a valid manager.
- Check for manager IDs that do not match any employee ID, and for an employee accidentally listed as their own manager.
- Look for reporting loops, such as A reporting to B while B reports to A. A normal org chart must have a top point and no circular chain.
- Decide how to represent contractors, vacancies, assistants, and dotted-line relationships before creating the graphic.
A conventional org chart shows one clear reporting parent for each position. If your organization has matrix reporting, project leads, or several kinds of authority, a single hierarchy may leave out important relationships. Decide whether to show only solid-line reporting or to create a separate diagram for other relationships.
Create a chart with SmartArt in Excel
In Excel for Microsoft 365 on Windows, click the worksheet where the chart should go, then choose Insert > SmartArt > Hierarchy and select Organization Chart or another suitable hierarchy layout. On the Mac, use Insert > SmartArt and choose a hierarchy layout; the exact gallery presentation can vary by Excel release. SmartArt places an editable graphic on the sheet, but it does not read the employee rows as a data source.
To enter names, select the SmartArt graphic and open its text pane using the small arrow on the graphic’s left edge, if the pane is not already visible. Each bullet in the pane represents a box. Type a person’s name and, if useful, their title. Press Enter to add another item at the same level. Use Tab to make an item a subordinate of the item above it, and Shift+Tab to move it up a level. You can also use the SmartArt Design tab’s Add Shape controls to add positions through the ribbon.
For instance, a simple outline could place the chief executive at the top, two department heads beneath that person, and each team member beneath the appropriate department head. Add the executive first, create the department heads as direct reports, and then demote each team member under the correct head. Review the resulting connectors carefully: the order and indentation in the text pane determine who reports to whom.
When the hierarchy is in place, use the SmartArt Design tab to choose a layout and style. For an organization chart, the standard Organization Chart layout is often clearer than decorative alternatives. Select a box to edit its text. If a position is missing, use Add Shape to insert it in relation to the selected box; options can include adding a subordinate, colleague, or assistant. The available controls depend on the selected layout and shape.
Format the chart for real-world use
Keep each box readable. A name and title are usually more useful than a long list of responsibilities, phone numbers, and notes. If viewers need contact details, include a separate employee directory or a link to an approved source rather than shrinking every box to fit a crowded chart.
Use a consistent naming convention, such as name on the first line and title on the second. If you use color to distinguish departments or employment types, add a small legend and do not rely on color alone to convey meaning. Check that the hierarchy remains understandable in grayscale and when printed. In Excel, use the SmartArt Design and Format tabs to adjust the graphic’s layout and appearance; resizing the graphic or changing worksheet print settings can also affect how it appears on paper.
For a chart that spans several levels, test it at the size people will actually use. A layout that looks clear on a large monitor may become too small when placed in an email or printed on one page. Consider splitting a large organization into department-level charts, or sharing a digital version that readers can zoom. Include a date or version label so users can tell whether the chart is current.
When importing Excel data into Visio makes sense
If you want a diagram generated from employee records rather than manually arranged in SmartArt, Visio is a more suitable Microsoft option. The desktop Visio organization-chart workflow can use information stored in a file, including an Excel workbook, and guide you through identifying the columns that contain employee names, unique IDs, and reporting relationships. The workbook needs to describe the hierarchy clearly; Visio cannot reliably infer a manager relationship from names or department labels alone.
In Visio, start an Organization Chart diagram and follow the organization-chart wizard to indicate that the information is already stored in a file. Select the workbook and map the appropriate columns when prompted. The wizard can use employee and manager identifiers to create reporting boxes, after which you can adjust layout, formatting, and displayed fields. Menu wording and wizard availability can vary between Visio plans and versions, so check that your installed Visio edition includes the desktop organization-chart import workflow.
Importing should not be confused with a permanent two-way connection. A diagram created from a workbook may require a refresh or a new import when the source changes, depending on the Visio workflow and version. Confirm how your particular setup handles updates before relying on it as a live chart. Keep the source workbook in a stable location and document which file is authoritative.
Common problems and practical checks
- Boxes appear under the wrong manager: Review the indentation in the SmartArt text pane, or verify that the manager ID mapping is correct in an import workflow.
- The chart is too wide: Reduce unnecessary text, use a more compact layout, or divide the chart into connected department views. Avoid making the font so small that the chart becomes unusable.
- Names are not unique: Use employee IDs in the source data and include titles or departments in the display where that helps distinguish people.
- Several people seem to report to one person, but some are dotted-line reports: Choose a clear rule for what the chart represents. A standard hierarchy graphic may not communicate matrix relationships accurately.
- Updates are missed: Set an owner and review date, and compare the diagram with the authoritative employee list whenever staffing changes.
Also check privacy before sharing the workbook or diagram. An org chart can reveal names, roles, vacancies, and reporting relationships. Share only the information the audience needs, and use your organization’s normal access controls for employee data. For accessibility, give the chart a descriptive label where supported and provide the hierarchy as text or a table as well; a visual graphic alone may be difficult for some readers to navigate.
Choosing between SmartArt, Visio, and other options
Choose SmartArt when the chart is straightforward, the audience needs a convenient visual, and a person can update it manually. It is built into Excel and is generally the simplest option for a one-off chart or a small team. Its main tradeoff is maintenance: the source table and diagram are separate representations.
Choose Visio when the hierarchy is large, when importing structured records is important, or when you need diagramming controls beyond a basic SmartArt graphic. Check the licensing and version requirements before planning a workflow; Visio availability and features depend on the plan or application edition. There is no need to buy another tool for a simple chart that SmartArt can handle.
Other alternatives include a dedicated HR system’s reporting feature or an organizational chart application approved by your workplace. These can be useful when charts must stay aligned with a frequently changing employee directory, but their data connections, permissions, and export options vary. Whichever tool you choose, identify the authoritative employee record and decide who is responsible for correcting errors.
Frequently Asked Questions
Can Excel automatically create an org chart from a table?
Not with SmartArt alone. SmartArt lets you build an organization chart in Excel, but you arrange its boxes separately from a normal worksheet table. To generate a diagram from employee-manager records, use a supported import workflow such as Visio’s desktop organization-chart wizard.
Can I link a SmartArt org chart to cells?
SmartArt does not automatically link each box to a worksheet row so that changes to the table update the reporting structure. You can edit the SmartArt manually after source data changes, or use a tool designed to import and refresh organizational data.
What columns should an Excel org chart file contain?
At minimum, include an employee name, a unique employee identifier, and the identifier of that employee’s manager. Job title and department are useful display fields. Use a blank manager reference for the top position and make sure every other manager reference points to a valid employee.
Can an org chart show two managers for one employee?
A basic hierarchy is designed to show one parent relationship for each position. If an employee has both a solid-line manager and a dotted-line lead, decide which relationship the chart should emphasize, or use a diagram designed to show multiple connections.
Will my chart update when the Excel data changes?
A SmartArt chart will not update from worksheet edits automatically. A Visio import may offer a way to refresh or recreate the diagram, but the exact behavior depends on the Visio version and workflow. Verify it with a copy of your data before making it part of a recurring process.
Related
- Excel Merge Cells: Combine Content Without Losing Data
- Excel Merge Blank Cells Below: Steps and Alternatives
- Excel: Merge Cell Data Into One Cell
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Can You Power Pivot Two Excel Sheets? How to Do ItYes. In Excel for Microsoft 365 on Windows, turn each sheet’s data range into an Excel table, add…
- Excel Pie Chart: Change the Color of a SliceTo change one slice in an Excel pie chart, click the chart, then click the slice again so…
- Excel Histogram: Add Bins and Control Their WidthsTo add or change bins in an Excel histogram, select the chart’s horizontal axis, open Format Axis, and…
- Pivot Chart Definition, Uses, and How It WorksA PivotChart is an interactive chart linked to a PivotTable that summarizes and displays data by categories, measures,…
- Move a Pivot Chart to Another Sheet in ExcelIn Excel for Microsoft 365 on Windows, select the PivotChart, choose Chart Design > Move Chart, select Object…
- Excel Pie Chart From PivotTable: How to Create OneYes—you can create a pie chart directly from an Excel PivotTable by selecting a cell in the table…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.