Yes, you can make an org chart from employee data in Excel, but Excel does not automatically turn a normal table into a finished, data-linked hierarchy. The simplest built-in method is to use the table as a reference and recreate its reporting structure in SmartArt; for automatic generation from a workbook, Visio is a more suitable option.
What Excel Can—and Cannot—Do
Excel for Microsoft 365 includes SmartArt graphics, including an Organization Chart layout. You can use SmartArt to show who reports to whom, format the boxes, and place the finished diagram on a worksheet. However, SmartArt is not a direct view of an Excel table: it does not automatically read a Manager column, build a hierarchy, and keep the chart synchronized when table rows change.
This distinction matters. A table is structured data, with one record per person and fields such as name, role, and manager. An org chart is a visual hierarchy, usually represented as boxes connected by reporting lines. Excel can hold both, but the native SmartArt chart is maintained separately from the rows. If someone changes a manager in the table, you must also update the chart.
For a small team or a chart that will be updated occasionally, that manual step may be perfectly reasonable. For a large organization, frequent staffing changes, or a chart that must be regenerated reliably, consider importing the Excel data into an organizational-chart tool instead of relying on SmartArt alone.
Prepare the Employee Table
Before drawing anything, make the source data consistent. A useful table has one row per employee and separates information into columns rather than combining it in a single cell. For example, use Employee ID, Name, Job Title, Department, and Manager ID. An optional Manager Name column can help readers, but an ID is a safer link when two employees share a name.
Keep the table straightforward: use one header row, avoid merged cells, and do not insert blank rows inside the data. Select the range and choose Insert > Table, or press Ctrl+T on Windows, then confirm that the table has headers. On Mac, use Command+T to create a table. A named Excel table is easier to filter and maintain than a loose range, although SmartArt will not automatically connect to it.
Check the reporting relationships before building the visual. Usually, the top person has a blank manager field, and each other employee has one direct manager. Make sure every manager reference points to a person who appears in the table. Look for misspellings, duplicate IDs, and people who report to themselves. If a person has two formal managers, decide how the chart should represent that relationship: a standard tree-shaped org chart generally works best when each person has one primary reporting line.
- Example: ID 101, Maya Chen, Chief Executive Officer, no manager.
- Example: ID 102, Luis Romero, Finance Director, manager 101.
- Example: ID 103, Aisha Patel, Analyst, manager 102.
This information describes the hierarchy clearly: Maya is at the top, Luis reports to Maya, and Aisha reports to Luis. The IDs make the relationships unambiguous even if names repeat.
Build the Chart with SmartArt
In Excel for Microsoft 365 on Windows, open the worksheet where you want the visual, then choose Insert > SmartArt > Hierarchy and select Organization Chart. The exact gallery layout may vary slightly by release. Excel inserts a SmartArt graphic and opens a text pane where you can enter the reporting structure.
- Type the top person in the first text-pane line.
- Press Enter to create another line for a person at the same level.
- Press Tab at the start of a line to make that person a subordinate of the entry above. Use Shift+Tab to promote a person one level.
- Continue entering names and roles until the hierarchy matches the table. Put a role on the same line as a name if you want both in one box, or use a concise name-and-title format.
For example, enter Maya Chen — CEO as the first item, Luis Romero — Finance Director as a subordinate, and Aisha Patel — Analyst as a subordinate of Luis. The indentation in the text pane determines the reporting levels; it is not enough to list the employees in table order. Review the result against the Manager ID or Manager Name field so that each person appears under the correct manager.
You can also select a box and use the SmartArt Design tab to add a shape, promote or demote a person, or change the layout. The text pane is often the quickest way to establish levels, while the ribbon is useful for corrections and styling. SmartArt is available in Excel for Mac as well, though ribbon placement and some controls can differ. Excel for the web may offer a more limited editing experience; if a command is missing, open the workbook in the desktop app.
Make the Layout Readable
An org chart is useful only if readers can follow it. Start with a layout that fits the number of levels and people. A compact department may fit in a conventional top-down chart. A group with many direct reports may become very wide, while an organization with many layers may become too tall to read on one screen or printed page.
Keep box text brief. Names and job titles are usually enough; adding phone numbers, email addresses, locations, and lengthy role descriptions can make the boxes too crowded. If readers need those details, keep them in the employee table and use the chart to show structure. Apply colors consistently—for example, by department—but do not rely on color alone to convey meaning, since charts may be printed in grayscale or viewed by people with color-vision differences.
To make a chart easier to share, place it on a separate worksheet and give that sheet a clear name. Use Page Layout controls to check orientation, paper size, and print area before printing. A chart that looks clear on a large monitor may be tiny on a single printed page; splitting it by department or using a larger page can be more legible than shrinking all the boxes.
Keeping the Chart Current
SmartArt and the employee table are separate objects. Adding a row to the table does not create a new chart box, and changing a manager in the table does not move an existing box. Treat the chart as a maintained visual, not as a live report. When the source data changes, compare the affected employee and their reporting line, then edit the SmartArt text pane or use the SmartArt Design controls to update the graphic.
A practical maintenance routine is to make the table the authoritative record and update the chart only after checking the change against that source. Keep a revision date near the chart, or include a short note stating which table or reporting period it represents. If the chart is distributed outside the workbook, export or copy it only after the update is reviewed. This reduces the chance that an old image continues circulating after the organization has changed.
For recurring updates, keep the source table tidy and record a stable employee ID for each person. A name-only process becomes error-prone when names change or are duplicated. Also decide how to handle vacancies, contractors, temporary assignments, and open positions before drawing; consistent rules make charts from different periods easier to compare.
When Visio Is a Better Fit
If you need to create an org chart from Excel data rather than manually recreate the hierarchy, Microsoft Visio desktop is a relevant alternative. Its Organization Chart Wizard can use information stored in an Excel workbook to build a diagram. In supported desktop versions, start with File > New > Organization Chart and follow the wizard’s option for information stored in a file or database, then select the workbook and map the relevant fields. The available wizard and import choices depend on the Visio version and license.
Prepare the workbook with clearly labeled fields such as employee name, unique identifier, and reports-to identifier or manager name. Follow the wizard’s prompts for the column that identifies each person and the column that identifies that person’s manager. Test the import on a copy of the file first, especially if the workbook contains multiple sheets or unrelated data. An import can create the initial diagram, but do not assume that every later edit to the Excel table will instantly update the shapes; check the specific linking and refresh options available in your Visio version.
Visio is more appropriate when the hierarchy is large, the layout needs more control, or the chart is part of a formal diagramming workflow. It may require a separate Visio license, so it is not automatically the cheapest choice. For a small, rarely changing team, Excel SmartArt is often simpler and avoids adding another application to the process.
Common Problems and How to Avoid Them
- Everyone appears at one level: The text-pane entries are not indented into the correct hierarchy. Use Tab to demote a subordinate and Shift+Tab to promote an entry, then compare the structure with the manager column.
- The wrong person appears as a manager: The table may have inconsistent names or an incorrect manager reference. Confirm relationships using stable IDs and review the source before editing the chart.
- The chart is too wide or crowded: Reduce unnecessary box text, split the diagram into department-level charts, or use a diagramming tool designed for larger structures.
- A table edit does not change the chart: This is expected for SmartArt. Update the graphic separately or choose a workflow that imports and manages the data in a dedicated diagramming tool.
- The chart contains a loop: A reporting chain cannot sensibly lead back to an earlier person. Check for self-reporting or circular manager references in the source data before building the chart.
One common misconception is that formatting the source as an Excel Table makes the org chart dynamic. Tables help organize and maintain rows, but they do not supply a built-in hierarchy engine for SmartArt. The visual and the records remain separate unless you use another workflow that explicitly imports or links the data.
Other Options for Sharing the Structure
If a diagram is not essential, a filtered employee table can sometimes communicate reporting relationships more accurately than a crowded chart. Add department and manager columns, then sort or filter the records for the audience. For a presentation, a simplified chart by department may be clearer than one diagram containing every employee. For a large, frequently changing organization, use an organizational-chart or diagramming product whose data-import and refresh behavior meets the update requirements.
The right choice depends on scale, update frequency, and how readers will use the result. SmartArt suits a modest hierarchy that people can maintain by hand. Visio or another purpose-built tool is worth considering when the chart must be generated from data, carefully arranged, or maintained as part of a repeatable process. Whichever method you choose, keep the source data clean and make clear which version of the organization the diagram represents.
Frequently Asked Questions
Can Excel automatically create an org chart from a table?
No. Excel SmartArt can make an organization chart, but it does not automatically read a standard employee table and build or synchronize the hierarchy. You can enter the structure manually in SmartArt or use a suitable import workflow such as Visio’s Organization Chart Wizard.
What columns should an org-chart table have?
At minimum, include each employee’s name and their manager. A unique employee ID and manager ID make relationships more reliable, especially when names repeat. Job title and department are useful optional fields.
How do I make someone a subordinate in SmartArt?
Open the SmartArt text pane, select the relevant line, and press Tab at the start of the entry to indent it under the item above. Use Shift+Tab to move it back up a level. Check the resulting boxes against the source table.
Will an Excel org chart update when I add a new employee?
Not if it is a standard SmartArt graphic. Add the employee to the chart and place the box in the correct reporting position. A Visio import may help generate a diagram from data, but confirm its update and refresh behavior in your version.
Can I make an org chart in Excel for Mac?
Excel for Mac includes SmartArt hierarchy graphics, though some ribbon controls and their locations may differ from Windows. The same key limitation applies: a SmartArt chart is not automatically synchronized with an employee table.
Related
- Excel MAX Between Dates: Find the Highest Value in a Range
- Excel MAX Between Two Dates: Find the Highest Value
- Excel Material List Template: Plan, Price, and Track
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pivot Table Range: How to Set, Change, and Fix RangesAn Excel PivotTable range is the set of source cells the PivotTable reads, including the column headers and…
- AG Grid Pivot Table: Setup, Features, and Common IssuesAn AG Grid pivot table is a data view that groups records into rows and generates columns from…
- Excel Combo and Stacked Charts: How to Combine ThemYes. In Excel for Microsoft 365 on Windows, you can combine stacked columns with another chart type, such…
- Excel Pivot Table Won’t Group Dates? How to Fix ItIf an Excel PivotTable will not group dates, first check that every value in the source date column…
- Pie Chart in Excel: How to Create, Format, and Label ItTo create a pie chart in Excel for Microsoft 365 on Windows, select a column of category names…
- Linear Trendline in Excel: Make One and Show Its EquationTo make a linear trendline in Excel for Microsoft 365 on Windows, select your paired data, choose Insert…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.