To make an org chart in Excel for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy > Organization Chart, then enter each person and role in the chart’s text pane. Excel can also build a chart from individual shapes, but neither approach automatically turns a typical employee data table into a live, data-linked org chart.
What an Excel org chart shows
An organizational chart, or org chart, represents reporting relationships: who manages whom, how teams are grouped, and where roles sit in a hierarchy. A basic chart might show a director at the top, department managers beneath, and team members below them. It is a visual summary of structure, not a complete directory or a substitute for a detailed employee database.
Excel is useful when the chart is modest in size, the information already lives in a workbook, or the chart needs to sit beside budgets, staffing plans, or other spreadsheet content. It can be an appropriate choice for a small business, project team, department, or temporary planning exercise. A very large organization chart, or one that changes frequently, may be harder to maintain in Excel than in software built specifically for diagramming or organizational data.
Build a basic chart with SmartArt
SmartArt is the quickest built-in option for creating a conventional hierarchy in Excel desktop. Start with a blank worksheet or select a clear area in an existing one. Then follow these steps:
- On the ribbon, select Insert > SmartArt.
- In the SmartArt gallery, choose Hierarchy, select Organization Chart, and click OK.
- Select the chart’s text pane. If it is not visible, select the SmartArt graphic and use SmartArt Design > Text Pane.
- Type the top role first. Press Enter to add another item at the same level, and use Tab or Shift+Tab in the text pane to demote or promote an item in the hierarchy.
- Review the structure and use SmartArt Design > Add Shape to add roles in the intended relationship. The available commands include options such as adding a shape below or after the selected one.
- Resize and position the graphic, then check that names and reporting lines are readable at the size at which people will view or print it.
For example, a small chart could place “Operations Director” at the top, “Warehouse Manager” and “Customer Service Manager” on the next level, and each manager’s direct reports underneath. Use one text entry per person or role. Keep titles and names in a consistent order, such as “Jordan Lee — Warehouse Manager,” so readers can scan boxes without guessing which text is the job title.
Plan the reporting hierarchy before entering names
The quality of the diagram depends more on accurate relationships than on decoration. Before building it, confirm the scope: is it a formal reporting chart, a project-team view, or a chart of positions that are currently vacant? Those are different views and should not be mixed without explanation. Decide whether the chart includes contractors, temporary staff, assistants, or only permanent positions, and add a date or “as of” note if the structure may change.
A simple planning table can help, even though Excel will not automatically convert it into a SmartArt org chart. For instance, record each person’s name, role, department, and manager in separate columns. A manager column makes it easier to check that each person has one intended reporting line and that no manager is missing. It also gives you a practical source to consult when you update the visual chart later.
- Check that each person or position appears once unless the chart intentionally represents a matrix or shared responsibility.
- Confirm spelling, job titles, and manager relationships with an authoritative internal source.
- Decide how to display vacancies, leave, dotted-line relationships, and shared roles before choosing a visual convention.
- Use a consistent level of detail; listing some people by full name and others only by department can be confusing.
Format the chart for easy reading
Select the SmartArt graphic to reveal its contextual tabs. SmartArt Design offers layouts, colors, and styles; the Format tab provides controls for selected shapes. A restrained design usually works better than a colorful box for every team. Use color to convey a defined distinction—such as department or role type—and include a legend if readers might not know what the colors mean. Do not rely on color alone to communicate a relationship.
Keep text short enough to fit inside each box. Names and job titles are usually more useful than long descriptions of responsibilities. If a title is lengthy, use a deliberate line break or a shorter approved title rather than shrinking the font until it is difficult to read. Use the same font and text alignment across comparable boxes, and make higher-level roles visually distinct without making lower levels look insignificant.
Large charts often become too wide for a standard printed page. Before printing, use File > Print to inspect the preview, then consider landscape orientation, a larger paper size, or printing the chart across multiple pages. Scaling a wide chart to one page can make the text unreadably small. For a workbook shared on screen, leave enough white space around the diagram and avoid placing it over cells that contain important data.
Use shapes when the hierarchy needs more control
SmartArt is convenient, but its preset layouts can be restrictive when a chart has unusual groupings, annotations, or visual conventions. For a custom diagram, use Insert > Shapes to add rectangles or other shapes for roles, then add connector lines between them. Connectors are preferable to ordinary lines because they can remain attached to shapes when those shapes are moved, depending on the connector and its endpoints.
Build the chart from the top down. Place the highest role, add the next tier, and connect each manager to the relevant direct reports. Keep boxes aligned and evenly spaced; Excel’s shape-formatting and alignment controls can help, but a very large diagram requires careful manual adjustment. Group related shapes when the layout is settled so that a team can be moved as a unit. Grouping is a convenience, not a data relationship: changing a manager’s name in a source table will not update the text inside a shape.
Shapes make it easier to draw dotted-line reporting, vacancies, or special roles, but custom styling can also make the chart harder to interpret. Use a clear legend for nonstandard lines and box treatments. If a relationship is too complex to represent clearly on one page, separate the chart into department views or use a purpose-built diagramming application rather than adding more crossings and tiny text.
Understand what Excel will and will not update
A SmartArt org chart is an editable graphic. The names and reporting levels entered in its text pane belong to that graphic; they are not automatically connected to a separate roster in worksheet cells. Likewise, text typed into shapes is not a live link to employee records. If someone changes teams or a role is renamed, you must update the chart yourself and check that its levels and connections still make sense.
This distinction is a common source of confusion: storing a roster in rows does not by itself create a dynamic org chart. Excel’s ordinary chart feature is designed for plotting data, while an org chart is a structured diagram. A worksheet table can still be valuable as the controlled source of names and manager relationships, but the visual graphic needs a separate maintenance step unless you use an external tool or a custom process designed for that purpose.
For a workbook that will be revised regularly, assign an owner and a review schedule. Keep the source roster and the diagram together, label the chart with its last-updated date, and compare the two after changes. If several people edit the workbook, agree on who approves reporting changes; simultaneous edits or an outdated copy can otherwise leave readers looking at conflicting structures.
Common problems and practical fixes
- Names appear at the wrong level: Select the item in the SmartArt text pane and adjust its indentation with Tab or Shift+Tab, then verify the resulting reporting line in the graphic.
- Boxes are crowded or text is clipped: Shorten the displayed text, enlarge the chart, or choose a layout with more room. Avoid solving every fit problem by making the type smaller.
- The chart is too broad: Break it into department-level charts with a clear link to the overall structure, or use landscape printing and a suitable page size.
- A person has two managers: Decide whether the chart is showing formal reporting or a matrix relationship. If it is a matrix, label the line styles and explain the distinction rather than implying two identical direct-report relationships.
- The chart does not match the roster: Compare names and manager assignments against the source list, and add an “as of” date so readers can judge whether the chart is current.
Excel compared with other ways to make an org chart
Excel’s main advantages are familiarity, availability in many workplaces, and the ability to keep a diagram near related spreadsheet information. SmartArt can produce a straightforward hierarchy without drawing every box manually. Its main limitations are manual maintenance, limited suitability for large structures, and the effort involved in arranging a heavily customized chart.
PowerPoint can be more convenient when the chart is primarily for a presentation, because slides offer a flexible canvas. Visio is designed for diagramming and may suit more complex organizational visuals, depending on the organization’s licensing and available features. Dedicated HR systems may provide organizational views from maintained employee records, but capabilities and access depend on the specific system. These options do not remove the need to verify the underlying reporting data.
There is no universal size at which Excel stops being suitable. A small, stable team may be easy to represent with SmartArt; even a smaller group can become awkward if it has many cross-functional relationships or frequent changes. Choose based on how often the chart changes, who must maintain it, how it will be shared, and whether a static visual is sufficient or a data-connected view is required.
Frequently Asked Questions
Can Excel make an org chart from a list of employees?
Excel can store an employee list, but a normal table does not automatically become a SmartArt org chart. Create the SmartArt hierarchy separately, or use another tool or a custom workflow if you need the diagram to be generated from employee records.
How do I add a manager or subordinate in Excel SmartArt?
Select the relevant item in the SmartArt graphic and use SmartArt Design > Add Shape to choose the appropriate position, such as adding a shape below. You can also organize entries in the text pane by changing their indentation and then confirm that the visual hierarchy is correct.
Can I link an org chart box to a cell?
Excel shapes can in some cases display a cell’s contents when selected and linked through the formula bar, but that does not create an automatic reporting hierarchy from a roster. It also does not remove the need to position boxes and connectors or verify the manager relationships.
Can I make an org chart in Excel for the web?
Feature availability and editing controls can vary between Excel for the web and the desktop app. For the steps above, use Excel for Microsoft 365 on Windows; if SmartArt commands or layout controls are unavailable in your browser session, open the workbook in the desktop application.
Is SmartArt better than drawing the chart with shapes?
SmartArt is generally quicker for a standard reporting hierarchy and easier to reorganize through its text pane. Individual shapes offer more visual freedom, but require more manual work to align, connect, and keep consistent.
Related
- Excel Reverse Undo Shortcut: What Works and What Doesn’t
- Excel Reverse Worksheet Order: How to Do It
- Excel Repair Software Free Full Version: What Works?
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pivot Table Rows Side by Side: Layout, Steps, and TipsTo put PivotTable row fields side by side in Excel for Microsoft 365 on Windows, click inside the…
- 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…
- Excel Pivot Chart: How to Change the Data Source SafelyTo change an Excel PivotChart’s data source, select its associated PivotTable, choose PivotTable Analyze > Change Data Source,…
- Excel Histogram Formulas: Calculate Bin CountsTo apply a formula to histogram data in Microsoft Excel for Microsoft 365 on Windows, put your numeric…
- Circular Radar Chart in Excel: Create and Format ItTo make a circular radar chart in Excel for Microsoft 365 on Windows, arrange your categories in one…
- Excel Chart Labels: Add, Format, and Fix ThemIn Excel for Microsoft 365 on Windows, select a chart, then choose Chart Design > Add Chart Element…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.