To build an org chart in Excel for Microsoft 365 on Windows, select Insert > SmartArt > Hierarchy > Organization Chart, then enter each person and reporting relationship in the SmartArt text pane. Use SmartArt Design > Add Shape to add roles, and format the result so reporting lines and labels remain easy to follow.
What an Excel org chart shows
An organizational chart, or org chart, is a visual map of roles and reporting relationships. A typical chart places a leader at the top, managers below, and the people reporting to those managers on lower levels. It can help employees understand who is responsible for a function, where to direct a question, and how teams fit together.
The chart represents a chosen view of the organization, not every detail of how work gets done. A person may collaborate with several teams but report to only one manager. In a conventional hierarchy chart, the solid connecting lines should represent the reporting structure you intend to communicate. If the organization has matrix reporting, temporary project teams, or dotted-line relationships, explain those separately rather than implying that every connection has the same meaning.
Excel is useful for a compact chart, a small department, or a diagram that needs to sit beside other workbook information. SmartArt provides a quick starting point, while drawing shapes gives more control. Neither option automatically guarantees that the chart stays synchronized with a staff list; changes usually need to be reflected in the diagram as well.
Prepare the reporting information first
Decide what the chart is meant to answer before arranging boxes. A company-wide chart may need to show only executives and department heads, while a team chart may need individual roles and vacancies. Trying to include every employee, title, location, and reporting note in one view often makes the result too crowded to read.
Make a simple, authoritative list before creating the graphic. Useful fields include:
- Name: Use the name employees recognize and spell it consistently.
- Job title: Keep titles concise enough to fit in a box.
- Reports to: Identify the direct manager, rather than a project contact.
- Optional details: Add a department, location, or vacancy label only if it helps readers interpret the chart.
Check that each person has the intended manager and that the reporting chain leads to the top role. A circular relationship, such as one manager reporting to a subordinate, cannot be represented as a normal hierarchy. Decide how to handle vacant positions and shared roles, too. For example, a box labeled “Open — Marketing Manager” can make a vacancy visible without suggesting that a named employee holds the role.
Create the chart with SmartArt
In Excel for Microsoft 365 on Windows, click the worksheet where you want the chart and choose Insert > SmartArt > Hierarchy > Organization Chart. Select the organization chart layout and click OK. Excel inserts a graphic that you can move and resize like other worksheet objects. If the SmartArt window or gallery looks different on your computer, check that you are using the desktop Excel app; the web and Mac interfaces can arrange commands differently.
Click the small arrow at the edge of the SmartArt graphic to open its text pane, or use SmartArt Design > Text Pane. Enter a role on each line. In the text-pane hierarchy, press Enter to add another item at the current level, Tab to make an item subordinate to the item above it, and Shift+Tab to move it up a level. For example, enter the chief executive first, then add department heads as subordinate entries, followed by the employees who report to each head.
Take care when indenting: the visual order in the text pane determines the reporting structure. If the hierarchy is wrong, correct it there before adjusting colors or box sizes. For a small chart, entering and indenting the names is generally faster than drawing each box individually.
Add, remove, and rearrange roles
Click the relevant box, then choose SmartArt Design > Add Shape. The menu offers options for inserting a position in relation to the selected one, such as a subordinate or a colleague at the same level. Choose the relationship deliberately: adding a shape in the wrong position can imply a different manager. You can also edit the structure in the text pane, which is often clearer when several roles need to move together.
To remove a position, select its shape and press Delete. Review the subordinate boxes first: removing a manager may also remove or affect the display of roles beneath that manager, depending on what you select and how the SmartArt is arranged. If a person changes teams, update both the person’s entry and their hierarchy level, then check the connecting lines and the surrounding structure.
SmartArt can rearrange the graphic as you add or move entries. This is convenient, but it may shift other boxes or change the spacing. After a structural edit, scan the whole chart rather than assuming only the selected box changed. Undo is available with Ctrl+Z on Windows; on Mac, use Command+Z. Undo is useful for a recent edit, but it is not a substitute for keeping a separate source list or saving a version before a large redesign.
Format for readability
When the hierarchy is correct, select the SmartArt graphic and use the SmartArt Design and Format tabs to adjust its appearance. SmartArt styles and color variations can create visual consistency quickly, but restrained formatting is usually easier to read than a different color for every person. Use color to communicate a real distinction, such as departments or locations, and include a key if readers might not know what the colors mean.
Keep labels short. A name and title may be enough; long biographies, phone numbers, and responsibility lists tend to make the boxes too small or the overall graphic too large. If those details matter, place them in a separate table on another worksheet and label the relationship between the chart and the table. Use a readable font size, strong contrast, and consistent capitalization. Check the chart at the size at which people will actually view or print it.
Resize the graphic using its corner handles to preserve its proportions. Avoid shrinking it until titles become illegible. If the chart is wider than the printable page, choose a landscape page orientation or print the chart on more than one page rather than compressing it excessively. In Excel, page setup and print preview can help reveal clipped edges, unexpected page breaks, or text that looks fine on screen but is too small on paper.
SmartArt or manually drawn shapes?
SmartArt is a strong choice when the structure is a straightforward hierarchy and you want Excel to manage the arrangement as you add entries. It offers layouts and styles without requiring you to connect every box yourself. Its trade-off is that you have less precise control over individual box placement, and a complex chart can become cramped as SmartArt rearranges the elements.
For a custom layout, use Insert > Shapes to add rectangles for roles and connector lines to show reporting relationships. Connectors are preferable to ordinary lines because they can remain attached to shapes as you move them. The process takes more manual work: you must position, format, align, and reconnect objects carefully. Select multiple shapes and use the alignment and distribution commands available on the Shape Format tab to keep rows orderly.
A worksheet table is better when readers need to sort, filter, or search employees, but a table alone does not communicate hierarchy as quickly as a diagram. Some organizations maintain both: a staff list as the structured source and a simplified chart for communication. Excel does not turn an arbitrary manager-name table into a fully maintained org chart with one click; plan for manual updates or a separate diagramming process if the structure changes often.
Common problems and practical fixes
The boxes are in the wrong reporting order. Check indentation in the SmartArt text pane. Each subordinate should be indented beneath the correct manager. Correct the hierarchy before trying to fix it by dragging boxes.
The chart is too crowded. Show fewer levels, split the organization into department-level charts, or shorten labels. A chart is not required to display every detail in the employee directory. If splitting it, include the department leader on each relevant view so readers can see how the pages connect.
Lines or shapes move unexpectedly. SmartArt controls its own layout, so manual positioning may not behave like a group of independent shapes. With drawn shapes, check that you used connectors and that they attach to the intended boxes. Make a copy before substantially rearranging a complex graphic.
Readers confuse a project lead with a manager. Use the chart for formal reporting lines and label other relationships clearly in a separate view or note. Do not rely on color or line style alone unless the distinction is explained and accessible to readers who may not distinguish those colors.
The chart is outdated. Give it an owner and a review date, and state when it was last updated. When roles change, compare the diagram against the approved staff list. An attractive chart is not reliable if employees cannot tell whether it is current.
Sharing, printing, and keeping it current
Place the chart on a dedicated worksheet when it is a major deliverable, or keep it beside related information when the chart is small. Give the sheet a descriptive name and add a short note with the effective date and the team or organization covered. If the workbook contains sensitive personnel details, share only the information necessary for the audience and follow your organization’s access rules; hiding a worksheet is not the same as protecting confidential information.
Before sharing, check the chart at normal zoom and in print preview. Confirm that names are not cut off, the highest role is visible, connector lines are clear, and page breaks do not divide the chart awkwardly. If someone needs to review the structure but should not edit it, consider sharing a PDF or another read-only copy rather than relying only on worksheet protection. Keep the editable workbook in an approved location and make sure its owner knows how updates are handled.
A useful maintenance routine is simple: identify a responsible owner, compare changes with the source list, make the updates, and review the chart after edits. For a stable small team, occasional updates may be enough. For a rapidly changing organization, a manually maintained SmartArt graphic can become a second record that drifts from the official directory. In that case, clarify which record is authoritative and whether a dedicated organizational-chart tool is more suitable.
Frequently Asked Questions
Can Excel create an org chart automatically from a list?
Excel’s Organization Chart SmartArt gives you a hierarchy graphic, but it does not automatically infer every reporting relationship from an ordinary employee table. You enter or arrange the hierarchy in SmartArt, or build a separate diagram from shapes. Keep a structured staff list as a reference if you need to verify reporting lines.
How do I add a subordinate in Excel SmartArt?
Select the manager’s box and use SmartArt Design > Add Shape to choose the subordinate option. You can also open the text pane and indent the role beneath the manager with Tab. Check the resulting connection to make sure the chart shows the intended manager.
Can I make an org chart in Excel for Mac?
Excel for Mac includes SmartArt, though the ribbon layout and wording can differ from Excel for Windows. Look for SmartArt under the Insert tab, choose a hierarchy layout, and use the SmartArt design controls to edit it. Keyboard shortcuts also differ: Mac commonly uses Command where Windows uses Ctrl.
Can Excel org charts show dotted-line reporting?
You can represent additional relationships with manually formatted connectors or a clearly labeled note, but a standard hierarchy layout is designed to show a main reporting tree. Use a legend and make the distinction obvious. If matrix relationships are central to the organization, a custom diagram may communicate them better than a conventional org chart.
How do I print an org chart on one page?
First reduce unnecessary detail and check the chart’s dimensions. Then review page orientation, margins, and scaling in Excel’s page setup and print preview. Fit-to-page scaling can help, but it may make text too small; splitting a large chart across pages or making department-specific charts can be more readable.
Related
- Excel Lock Slicer in Place? Position and Protect It
- Excel Slicer: Connect One Slicer to Multiple PivotTables
- Excel Slicers for Multiple Tables: How to Connect Them
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Speedometer Chart: Build a Gauge Step by StepTo build a speedometer chart in Excel, make a doughnut chart from your gauge ranges, hide its lower…
- Excel Not Making Graphs Correctly? Fix Common CausesIf Excel is not making graphs correctly, first check that the chart uses the intended data range, treats…
- Chart Area in Excel: Definition and How It WorksIn Excel, the chart area is the entire region occupied by a chart, including the plot area and…
- Pie Chart Creation in Excel: A Practical Step-by-Step GuideTo create a pie chart in Excel for Microsoft 365 on Windows, place category names in one column…
- Excel Chart: How to Align Zero on a Secondary AxisTo align zero on an Excel chart’s secondary axis with zero on its primary axis, set fixed minimum…
- Excel Pivot Table Date Filter: Last 30 DaysTo filter an Excel PivotTable to the last 30 calendar days, add a helper column to the source…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.