For a quick chart in Excel, arrange employees in a list, choose Insert > SmartArt > Hierarchy, then build the reporting tree in the SmartArt Text Pane; Excel does not automatically convert a manager column into a finished org chart. For automatic layout from spreadsheet data, Visio’s Organization Chart Wizard is a better fit. The methods below cover both options, how to prepare reliable employee data, and when another diagram tool makes more sense.
1. Set Up a Clean Employee List
Start with one row per person and clear columns such as Employee ID, Name, Reports To, Job Title, and Department; make the header row unique and keep the data in a continuous range without blank rows or merged cells. Convert the range to an Excel table with Insert > Table so it is easier to sort, filter, and extend as staff are added. This tidy source is worth the small setup effort because it reduces import errors and makes it easier to check that every person has a place in the reporting structure.
2. Use Employee IDs to Resolve Reporting Lines
Names alone can be ambiguous when two employees share a name, so keep a unique Employee ID and a Manager ID in the source list wherever possible. Before drawing, check that each Manager ID matches an existing employee and that the top-level leader has no manager assigned; also look for a person who reports to themselves, which would create a circular relationship. Excel does not validate these relationships automatically, but sorting and filtering the table lets you catch many problems before they become confusing branches in a chart.
3. Build a Small Chart with SmartArt
For a compact, mostly static chart, select Insert > SmartArt > Hierarchy and choose an organization-chart layout, then open the Text Pane and enter names as an outline. Press Enter to add a peer, Tab to make an entry a subordinate, and Shift+Tab to move it up a level; the chart updates as the outline changes. This is a quick native Excel option for a small team, but it does not read the Reports To column or place people automatically, so you must translate the list into the correct outline yourself.
4. Draw a Custom Chart with Shapes and Connectors
When SmartArt’s layout is too restrictive, use Insert > Shapes to create employee boxes and connector lines, then add each person’s name and role inside a shape. Choose elbow connectors when reporting lines need to travel around boxes, and connect them to the shape connection points so they remain attached when you move a box. This method gives you precise control over spacing, colors, and annotations, but it takes longer to update: moving one manager or adding a team can mean repositioning several shapes and checking every connector.
5. Import the Spreadsheet into Visio
For a chart generated from a reporting list, use the desktop version of Microsoft Visio and its Organization Chart Wizard: start with File > New, choose Organization Chart, and follow the wizard to use information stored in a file or database and select the Excel workbook. Map the employee name and the field identifying the person they report to, then map optional fields such as title or department to display more detail. This is usually the most direct route from a spreadsheet relationship list to an automatically arranged chart, although Visio is a separate application and availability of templates or wizard labels can vary by edition.
6. Clean and Standardize the Source with Power Query
If the employee list comes from several workbooks or exports, use Data > Get Data > From File > From Workbook to bring the source into Power Query, where you can remove blank rows, standardize column names, and set data types before loading a clean table back to Excel. For example, make sure Manager ID is consistently stored as text or consistently as a number rather than mixing formats that look alike but do not match. Power Query prepares and refreshes data; it does not draw the org chart, so pair it with SmartArt for a manually maintained tree or with Visio for a diagram built from the cleaned reporting data.
7. Use SmartDraw for Spreadsheet-Based Diagramming
SmartDraw offers an organization-chart workflow that can use spreadsheet data, making it an option when the built-in Excel drawing tools are not enough and Visio is not the preferred diagramming environment. Prepare a simple worksheet with one employee per row and explicit reporting relationships, then follow SmartDraw’s current import instructions and map the columns it requests; review its accepted file formats before relying on a direct workbook import. The benefit is a diagram-focused layout and editing experience, while the trade-off is working in a separate product and checking its licensing, import limits, and export options.
8. Create a Chart in Lucidchart from a CSV Export
Lucidchart can build org charts from structured data, so it is useful when a team needs browser-based collaboration rather than a chart that stays inside Excel. Save a copy of the employee table as CSV from Excel, then use Lucidchart’s organization-chart data import workflow and map the name and reporting fields required by its importer; avoid exporting unrelated worksheets or sensitive columns. This route can make sharing and commenting easier, but the chart and source workbook are separate files unless you establish a deliberate update process.
9. Choose a Layout That Matches the Organization
A single top-down chart is easy to read for a small company, but a large organization often needs separate department charts or a chart for each manager’s branch to avoid tiny labels and long connector lines. Keep department and title visible only when they help readers distinguish roles, and use consistent naming such as “Customer Support” rather than alternating between abbreviations and full names. In Excel SmartArt, a compact hierarchy can work well on one worksheet, while Visio or a diagram service is more practical when the structure spans many levels or needs several printable pages.
10. Plan How the Chart Will Be Updated
Decide whether the chart is a one-time snapshot or a recurring record before choosing a tool: a manually assembled SmartArt graphic can be fine for a quarterly presentation, but it becomes costly to maintain if reporting lines change every week. Keep the employee table as the authoritative source, record when it was last updated, and assign someone to check new hires, departures, title changes, and manager changes before publishing a revision. If you import data into Visio or another charting service, test the update process with a small change first rather than assuming the diagram will synchronize with Excel automatically.
How to Choose
Choose SmartArt when the chart is small, the structure is stable, and staying entirely in Excel matters more than automatic placement. Pick shapes and connectors when presentation control is essential and you can accept manual maintenance. For a large employee list or frequent reporting changes, prioritize a tool that imports the reporting relationship and lays out the hierarchy; Visio’s wizard is a natural choice for people who already use Visio, while SmartDraw and Lucidchart may suit teams that prefer their diagramming workflows.
Also consider the quality of your source data before comparing layouts. If manager relationships are incomplete, names are duplicated, or departments use inconsistent labels, no charting tool can reliably infer the intended structure. Confirm that the chosen tool supports the file format and fields you have, whether colleagues need to edit the result, and whether the final chart must be printed, shared as a PDF, or kept as an editable diagram. For employee information, remove personal or confidential fields that readers do not need to see.
Frequently Asked Questions
Can Excel automatically create an org chart from a Reports To column?
Excel’s built-in SmartArt does not automatically map a Reports To column into a hierarchy. You can build the tree manually in SmartArt’s Text Pane, or use a charting tool such as Visio’s Organization Chart Wizard to import structured reporting data.
What columns should an employee list contain?
Use at least an employee name and a reporting relationship, such as Reports To or Manager ID. Employee ID, job title, and department are helpful additions, especially when names repeat or you want those details displayed in the chart.
How do I show the CEO or top manager?
Make the top person a root node with no manager assigned in the source list, or place that person at the top of the SmartArt outline. Check that no other employee is unintentionally left without a reporting relationship.
Can I update an org chart when the employee list changes?
A SmartArt outline or a shapes-based chart needs manual edits when people or reporting lines change. An imported-data workflow may make rebuilding easier, but confirm whether the specific tool refreshes an existing diagram or requires you to run the import again.
Can I make an org chart in Excel for the web or on a Mac?
SmartArt availability and editing options can differ between Excel for Windows, Mac, and the web, so check the Insert ribbon in your version. Visio’s desktop Organization Chart Wizard is a separate Windows-oriented workflow; a browser-based diagram service may be more convenient when collaborators use different platforms.
Final Thoughts
For a small, stable hierarchy, SmartArt is the simplest way to make an org chart without leaving Excel, provided you are willing to enter the structure yourself. If your employee list is large or changes often, clean the reporting data first and use Visio or another importer to generate the layout. The best result begins with an accurate, unambiguous employee-to-manager list.
Related
- Excel Conditional Formatting Based on Color: How It Works
- Conditional Formatting in Excel: Compare Dates
- Comparison Spreadsheet Template Excel: Setup and Examples
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Histogram X-Axis: Set the Range and BinsIn Excel for Microsoft 365 on Windows, select the histogram’s horizontal axis, open Format Axis, and adjust Bin…
- Excel Pie Chart: Combine Small Values into One SliceTo combine small values in an Excel pie chart, select the data and choose Insert > Insert Pie…
- Adding an Excel Chart to PowerPoint: Link, Embed, or CopyTo add an Excel chart to PowerPoint, select the chart in Excel and press Ctrl+C, switch to PowerPoint,…
- Create an Excel Dashboard With AI: A Practical GuideYes. To create an Excel dashboard with AI, prepare clean, column-based data, ask Microsoft Copilot or another AI…
- Excel Dashboard Sample: A Practical Sales TemplateAn Excel dashboard sample is a one-page summary that turns a structured data table into a quick view…
- Excel Pivot Chart Tutorial: Create and Customize ChartsTo create a PivotChart in Excel for Microsoft 365 on Windows, select a clean data range or Excel…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.