Yes. Microsoft Excel for Microsoft 365 includes an org chart option in SmartArt: select Insert > SmartArt > Hierarchy > Organization Chart, then enter names and roles in the chart. It is a practical way to show reporting relationships inside a workbook, although it does not automatically turn a list of employees into a chart or keep the chart synchronized with changes to that list.
What Excel’s org chart is
An organizational chart, or org chart, shows how roles or people are arranged in a workplace. Boxes typically represent employees or positions, and connecting lines show reporting relationships. Excel provides an org chart as a type of SmartArt graphic, rather than as a dedicated worksheet feature that reads a company directory.
The chart is useful for a small team, a department, a project group, or a simple explanation of who reports to whom. For example, a department chart might show a director at the top, two managers beneath that person, and several team members reporting to each manager. You can add names, job titles, and other short details to the boxes.
SmartArt keeps the graphic’s components connected as a visual hierarchy. This makes basic edits easier than drawing every box and line individually. However, the information is stored in the SmartArt graphic; it is not automatically linked to a table of employee records or to an HR system.
How to create an org chart in Excel
In Excel for Microsoft 365 on Windows, start with a blank worksheet or open the workbook where you want the graphic. Use the ribbon to insert the chart:
- Select Insert > SmartArt.
- In the Choose a SmartArt Graphic window, select Hierarchy.
- Choose Organization Chart, then select OK.
- Click a box and type its text, or open the text pane using the small arrow at the left edge of the graphic.
- Enter the reporting structure, then resize or reposition the graphic to fit the worksheet.
The first entry is generally the top role. Add subordinate roles beneath it by creating lower levels in the text pane or by using the SmartArt controls. If you already have names in cells, you can copy them as a reference, but Excel will not infer who reports to whom just because names appear in a column. You need to build the hierarchy explicitly.
Excel for Mac also has SmartArt and an Organization Chart choice under the Hierarchy category. Ribbon appearance and shortcuts can differ from Windows. Excel for the web may not offer the same complete set of SmartArt creation and editing controls as the desktop app; if a control is missing or the chart is difficult to edit, open the workbook in desktop Excel.
Add people and define reporting lines
When a SmartArt graphic is selected, the contextual SmartArt Design tab appears. Use SmartArt Design > Add Shape to add a box in relation to the selected one. The available choices include adding a shape after, before, above, or below, and adding an assistant where the layout supports it. The exact effect depends on which box is selected, so check the result before adding several entries.
The text pane is a convenient way to create levels without repeatedly opening menus. Each bullet represents a shape. Press Enter to add another item at the current level, Tab to demote an item to a subordinate level, and Shift+Tab to promote it. These keys work while the insertion point is in the SmartArt text pane; they do not change the worksheet’s cell indentation when you are typing in a cell.
For example, a simple structure could be entered as a director, followed by two managers at the next level, with staff members indented beneath their respective manager. If a person appears under the wrong manager, select that entry in the text pane and promote or demote it, or use the Add Shape controls to adjust the structure. Review the connecting lines after edits, especially when moving a role between branches.
Format the chart for readability
SmartArt Design offers layout, color, and style controls for the selected graphic. Different organization chart layouts can arrange branches in different ways, while SmartArt styles change the visual treatment of boxes and connectors. Use these options to make the chart easier to scan, not merely more decorative.
- Keep labels concise. A name and job title are usually easier to read than a paragraph of responsibilities.
- Make levels visually clear. Use a layout and text size that distinguish the top role from subordinate roles without making lower levels too small.
- Allow room to grow. Leave space around the chart if you expect to add roles later.
- Check the printed page. A chart that looks clear on screen may become difficult to read if Excel scales it down to fit one printed page.
You can move the graphic by dragging its border and resize it with the handles around its edge. To change the wording in one box, click into that box and edit the text. If you need extensive individual formatting, be cautious: manually overriding the appearance of many boxes can make future updates slower and less consistent.
SmartArt versus a table or manually drawn shapes
SmartArt is usually the best starting point when the main goal is a clean, editable hierarchy. It keeps the boxes and reporting lines together as a single graphic and makes it relatively straightforward to change text or add a role. It is less suited to detailed employee records, frequent automated updates, or very large organizations that need filtering and searching.
A worksheet table is better for structured information such as employee ID, department, manager, location, and start date. Tables are easier to sort, filter, and analyze, but a normal table does not display reporting relationships as a branching diagram. Many organizations maintain the authoritative employee data in a separate system and create a simplified chart for communication.
You can also draw boxes and connectors using Excel’s shapes tools. This provides more control over placement and appearance, but each component may need to be adjusted separately when the structure changes. That approach can be reasonable for a small, one-time diagram, but becomes cumbersome when people move between teams or new reporting levels are added.
For a presentation, PowerPoint may be more convenient because the chart can be sized and arranged on a slide. For specialized diagramming or large, data-heavy structures, a dedicated diagramming product may offer more suitable tools. The best choice depends on whether you need a simple picture, structured employee data, or a diagram that must be maintained regularly.
Important limitations and common problems
The most common misconception is that Excel will create an org chart automatically from a list of employees. The built-in SmartArt chart does not determine reporting relationships from names, job titles, or manager fields. You must enter the hierarchy in the graphic. Likewise, changing a name in a worksheet cell will not update a separate SmartArt box unless you edit that box yourself.
Charts can become crowded when there are many direct reports, long titles, or multiple management levels. Try shortening labels, increasing the graphic’s size, or splitting a large organization into department-level charts. Avoid shrinking the font until it is hard to read. A single chart that includes every employee is not always the clearest way to explain a large organization.
If a new entry appears at the wrong level, inspect its indentation in the text pane. If boxes or connector lines seem to move unexpectedly, check which shape was selected before using Add Shape and consider switching to another hierarchy layout. If the SmartArt Design tab is not visible, click the graphic first; contextual tabs appear only when the relevant object is selected.
Converting SmartArt to ordinary shapes can allow more independent editing, but it also gives up some of SmartArt’s convenient hierarchy behavior. After conversion, changes to the structure may require manual edits to boxes and connectors. Keep an editable SmartArt version or a backup copy before making a conversion that you may not be able to reverse easily.
Sharing, printing, and keeping the chart current
An org chart inserted in a workbook can be saved and shared as part of the Excel file. Before sending it, consider whether every recipient needs access to the names and roles shown. A chart may disclose internal reporting details, so follow your organization’s rules for sharing employee information and avoid including unnecessary personal data.
For printing, use print preview to check that the whole graphic fits and that labels remain legible. Depending on the worksheet layout, you may need to adjust the print area, page orientation, or scaling. A wide chart often works better on a landscape page. If the chart is intended for a presentation or a document, copying it into the destination file and checking the final layout can be more reliable than assuming worksheet print settings will suit every use.
For a chart that changes often, set a maintenance routine: assign someone to update it when reporting lines change, keep a source list of names and managers, and verify the diagram against that list before sharing. This does not create automatic synchronization, but it reduces the chance that the visual chart becomes outdated while the underlying roster is current.
Frequently Asked Questions
Does Excel have a built-in org chart template?
Excel includes an Organization Chart SmartArt layout, which you can insert through Insert > SmartArt > Hierarchy. It is a built-in graphic option, though it is not the same as an automatic template populated from your employee records.
Can Excel make an org chart automatically from a list?
Not with the standard SmartArt Organization Chart. You need to create the reporting levels in the graphic yourself. A list containing a manager column can help you plan the structure, but SmartArt does not automatically read that column and build the chart.
Can I add an assistant or another reporting level?
Yes. Select the relevant box and use SmartArt Design > Add Shape. Depending on the selected shape and chart layout, you can add a subordinate role or an assistant. Use the text pane’s indentation controls to adjust levels.
Can I make an org chart in Excel for the web?
Web Excel may have fewer SmartArt creation or editing options than the desktop application, and available controls can change. If you cannot find the needed hierarchy layout or cannot make a specific edit, open the workbook in Excel for Microsoft 365 on Windows or Mac.
Will the chart update when I change a name in a cell?
No. SmartArt text is separate from worksheet cell values, so editing a cell does not automatically change the chart. Update the text in the SmartArt graphic as well, or use a process that checks the chart against a maintained source list.
Related
- Company Invoice Template in Excel: Setup and Tips
- Compare Lists in Excel: Find Matches and Differences
- Combine Two Cells in Excel and Keep Both Text
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- How to Create an Org Chart in Excel: Steps and TipsTo create an org chart in Excel for Microsoft 365 on Windows, select Insert > SmartArt > Hierarchy…
- How to Add a Combo Chart in Excel: A Clear WalkthroughTo add a combo chart in Excel for Microsoft 365 on Windows, select your data, choose Insert >…
- Excel Gantt Chart Bar Formula: Setup and Date TipsFor a date-grid Gantt chart in Excel, use the conditional-formatting formula =AND(H$1>=$B2,H$1<=$C2). With task start dates in column…
- Excel Pivot Table Subtotals: How to Show, Change, and Fix ThemIn Excel for Microsoft 365 on Windows, select a cell in the PivotTable and choose PivotTable Design >…
- Set Up a Waterfall Chart in Excel: A Practical GuideTo set up a waterfall chart in Microsoft Excel for Microsoft 365 on Windows, place each category in…
- Edit Legend in Excel Line Charts: Names, Position, and StyleTo edit a legend in an Excel line chart, select the chart and go to Chart Design >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.