Yes. In Excel for Microsoft 365 on Windows, the easiest org chart maker is SmartArt: choose Insert > SmartArt > Hierarchy > Organization Chart, then enter names and reporting levels in the Text Pane. SmartArt builds the boxes and connector lines for you; you can then adjust the structure, appearance, and page layout.
The quickest way to make an org chart
Start with a blank worksheet or open the workbook where you want the diagram. Select a clear area of the sheet, then use the ribbon path Insert > SmartArt > Hierarchy > Organization Chart. In the Choose a SmartArt Graphic window, select the organization chart layout and click OK. Excel inserts a graphic with sample boxes.
To replace the sample text, click the small arrow on the left edge of the graphic to open the Text Pane. Type the top leader’s name first, then add each direct report on a new line. Use Tab to indent a line and make it a subordinate of the line above; use Shift+Tab to move it back up a level. You can also type directly into a box by clicking its placeholder text.
For example, a simple outline might be:
- Alex Rivera
- Jordan Lee, indented once as a direct report
- Sam Patel, indented twice under Jordan
- Taylor Kim, indented once as another direct report to Alex
The indentation matters: a person’s position in the outline determines the reporting relationship, not the order of boxes on the worksheet. After entering the names, close the Text Pane or click outside it. Drag the graphic’s corner handles to resize it while keeping its proportions.
Prepare the reporting information first
A little preparation makes the chart easier to build and maintain. Decide what the graphic is meant to show: the formal reporting hierarchy, a project team, a department, or a simplified view for a presentation. An org chart becomes confusing if it tries to show every collaboration or dotted-line relationship as though it were a direct reporting line.
Before opening SmartArt, assemble the information in a simple list. Useful fields include employee name, job title, manager, department, and, if relevant, location. Confirm spelling, titles, and who reports to whom. If you have dozens or hundreds of people, check whether the intended audience needs every name; splitting the chart by department is often easier to read than squeezing everyone into one diagram.
Plan what text will appear inside each box. A name and a short role label are usually more readable than a full job description, phone number, and several other details. If you want to show both name and title, enter concise text in the box and check that it fits at the size you expect to print or share. Excel does not automatically verify that the manager field in a separate data table matches the SmartArt reporting structure.
Build and change the hierarchy
The Text Pane is usually the fastest way to establish the overall structure because it lets you see the hierarchy as an outline. Each top-level bullet represents a top-level box; indenting a bullet creates a lower level. This is especially useful when creating the first draft or reorganizing several teams at once. For small edits, selecting a box and typing over its text may be quicker.
You can also add or remove positions from the graphic. Select the box that should anchor the change, then use SmartArt Design > Add Shape. The menu offers placement choices such as adding a shape after or before the selected box, or adding one above or below it. Choose the relationship carefully: a shape added below is normally a subordinate, while one added alongside is generally a peer. Available choices can depend on the selected layout and box.
To remove a position, select its box and press Delete. If you delete a manager who has subordinates, inspect the resulting structure and reconnect or reposition those boxes as needed. You can move a box within the hierarchy using the Text Pane’s indentation controls or SmartArt Design options. After a substantial change, review the chart from the top down rather than assuming the layout still communicates the intended reporting lines.
Format the chart for readability
Click the SmartArt graphic to reveal its contextual ribbon tabs, including SmartArt Design and Format. The SmartArt Design tab provides layout and style options; Format provides controls for selected shapes, text, and other graphic details. Choose a restrained style with enough contrast between text and background. A decorative effect may look attractive on screen but print poorly or make small labels harder to read.
Use a consistent approach to names and titles. For instance, put a person’s name on the first line and a short role on the next, or use one line with a separator if space is limited. Keep capitalization and title abbreviations consistent throughout. If a branch contains many more people than another, a single uniform chart may still become unbalanced; try a different hierarchy layout, widen the graphic, or split the view into separate department charts.
SmartArt applies layout changes to the graphic, but it may rearrange boxes when you add or remove entries. Do not rely on a specific box remaining at an exact screen coordinate after editing. If visual alignment is important, finish the content and hierarchy first, then make final appearance adjustments and review the graphic again after any later structural changes.
Fit, print, and share the org chart
Org charts are often wider than a normal worksheet table. Before printing, use Page Layout > Orientation > Landscape if that gives the chart more room. Check the page breaks in Print Preview and adjust the print area or scaling so the diagram is not split awkwardly across pages. Scaling a very large chart onto one page can make the text too small to read, so printing across multiple pages or making separate department charts may be better.
If the graphic sits over worksheet cells, those cells may show through around it, but they are not part of the SmartArt itself. You can keep the chart on a dedicated worksheet for a cleaner handoff. For a document or presentation, copy and paste the graphic into the destination application, then inspect its size and text there. If the recipient needs to update the hierarchy, share the workbook rather than only a picture or PDF; a static export does not preserve editable SmartArt structure.
Before sharing, check the workbook for other information that should not be included, such as hidden sheets or unrelated employee data. An org chart can contain personal or internal information. Share it only with the people who need it, and use your organization’s normal access controls and data-handling rules.
What SmartArt can and cannot automate
SmartArt is a quick visual tool, not a live reporting database. Its boxes are edited as part of the graphic. If you change a manager’s name in a separate worksheet table, the SmartArt text does not automatically update from that cell. Likewise, changing the SmartArt does not automatically maintain a clean employee roster in a table. For a small chart that changes occasionally, this manual approach is often perfectly adequate.
For a frequently updated company directory, decide how changes will be controlled. One person can maintain the SmartArt and verify each revision against the current roster, or the organization can use a dedicated HR or diagramming system with appropriate data connections. Excel can store and organize employee information, but simply placing names and manager names in columns does not turn them into an automatically synchronized SmartArt chart.
SmartArt is also not ideal for showing every type of relationship. A solid hierarchy works well for clear manager-to-report lines, but matrix reporting, temporary project teams, vacancies, and dotted-line relationships may need labels or a separate diagram. Adding many crossing connectors to one chart can make it harder to understand than showing the relationships in a separate table or project diagram.
Excel SmartArt compared with other options
For a compact, mostly static hierarchy, SmartArt is usually the simplest Excel option because it creates a coordinated diagram without requiring you to draw every box and line yourself. A manually drawn diagram using shapes gives more control over unusual layouts, but takes longer to arrange and is more tedious to maintain. Either way, the chart is a visual object rather than a database that validates reporting relationships.
A table with columns for employee and manager is often better when the main need is searching, sorting, filtering, or checking records. It is less immediately visual than an org chart, but handles a large roster more practically. Dedicated organizational chart or HR software may be a better fit when the chart must stay synchronized with employee records, support complex structures, or be updated by multiple people under controlled permissions. Availability and cost depend on the product and any licenses an organization already has.
Excel for Mac has SmartArt features, though the ribbon arrangement can differ from Windows. Look for SmartArt under the Insert tab and use its design controls after selecting the graphic. Excel for the web may not offer the same creation and editing controls as the desktop app; if you cannot find the SmartArt commands, open the workbook in desktop Excel. Avoid assuming that every version has an identical interface.
Common problems and practical fixes
- Everyone appears at the same level: Check the Text Pane indentation. A new line is not automatically a subordinate; use Tab to indent it beneath the correct manager.
- A box is attached to the wrong manager: Move its outline entry to the right level and position in the Text Pane, then inspect the chart to confirm the relationship.
- Names or titles are clipped: Shorten the text, widen the graphic, or reduce text size modestly. Check the final view at normal reading size rather than only zoomed in.
- The chart looks crowded: Split it by department, remove nonessential details, or use a wider page. Shrinking every label is rarely the best first fix.
- The layout changes after editing: SmartArt rearranges boxes to fit its selected layout. Complete structural edits before making final visual adjustments.
- The chart prints too small: Review page orientation, print area, and page scaling. A second page or a separate chart may be clearer than forcing the whole hierarchy onto one sheet.
Frequently Asked Questions
Does Excel have a built-in org chart template?
Excel includes SmartArt organization chart layouts, which are the quickest built-in way to create a chart. You can also look for workbook templates, but a template may need changes to fit your hierarchy and may not update automatically from employee data.
How do I add a subordinate in Excel SmartArt?
Select the manager’s box, then choose SmartArt Design > Add Shape > Add Shape Below. Alternatively, use the Text Pane and create an indented entry beneath that manager. Check the resulting chart to verify the new box is attached to the intended person.
Can an Excel org chart update automatically from a table?
Not when it is an ordinary SmartArt graphic. Changes to a separate employee table do not automatically synchronize with its boxes. If frequent automatic updates are essential, consider a purpose-built system or a controlled process for regenerating and checking the diagram.
Can I make an org chart in Excel for free?
SmartArt is included with supported desktop editions of Excel, but access to Excel itself depends on the license or plan you have. Some organizations provide Microsoft 365 through work or school. Check your account’s included apps and the features available in your Excel version.
What is the best way to make a large org chart in Excel?
Keep a complete roster in a table, then make smaller SmartArt charts by department or reporting area if a single graphic becomes difficult to read. For a large hierarchy that must stay current, evaluate whether a dedicated org chart or HR tool is more suitable than manually maintaining a diagram.
Related
- Copy an Entire Excel Spreadsheet to a New File
- Copy and Paste X Times in Excel: Repeat Cells or Rows
- Convert H:M:S to a Number in Excel
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pivot Table Divide by Zero Error: Causes and FixesAn Excel PivotTable’s #DIV/0! usually comes from a division formula in its source data or a calculated field…
- How to Rename a Legend in an Excel ChartTo rename a legend entry in an Excel chart, select the chart, go to Chart Design > Select…
- Google Sheets Gantt Chart for Project TimelinesTo make a project timeline Gantt chart in Google Sheets, put tasks and start dates in columns, calculate…
- Wedding Seating Chart in Google Sheets: A Practical GuideYes. You can make a wedding seating chart in Google Sheets by keeping guest details and table assignments…
- Excel Bar Graph: Count Occurrences and Chart ResultsTo count how often each category appears in Excel and show the totals in a bar graph, make…
- Excel Pivot Table: Add a Calculated Column or FieldYes—but the right method depends on what you mean by a calculated column. In Excel for Microsoft 365…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.