Yes—Excel includes a built-in way to make an org chart: choose Insert > SmartArt > Hierarchy > Organization Chart, then enter names and roles in the Text Pane. You can also start with a workbook template if one is available, or build a chart with shapes when you need more control over its layout.
What an Excel org chart shows
An organizational chart is a visual map of roles and reporting relationships. A typical chart places the most senior role at the top, managers below, and their direct reports beneath them. It can help employees understand who reports to whom, show the structure of a department, and make gaps or unusually wide spans of control easier to notice.
A chart is not the same thing as a staff directory. A directory may list contact details, locations, or job titles without showing reporting lines. An org chart focuses on structure, so it is usually clearest when each box contains only the information people need to identify a person and their role. For example, a box might say “Maya Chen” and “Operations Manager.” Adding phone numbers, biographies, and long descriptions can make the chart difficult to read.
Before building one, decide whether the chart should represent the whole organization, one department, a project team, or a temporary reporting structure. A focused chart is usually more useful than trying to fit every employee into a single crowded page.
What an Excel template can and cannot do
Excel’s SmartArt organization-chart layout gives you a ready-made visual structure, so you do not have to draw every box and connector from scratch. It is a practical starting point for a small or moderately sized chart, a presentation, or a printed reference. Microsoft 365 workbooks may also show templates in the New workbook gallery, but the available choices can vary. Search the gallery for “org chart” or “organization chart” if you want to check.
A template is a starting layout, not necessarily a live connection to employee records. SmartArt does not automatically turn a table of names and manager IDs into a current chart. If someone changes teams, you generally need to edit the SmartArt or the shapes yourself. Likewise, a downloaded template may contain sample names, formatting, or instructions that need replacing.
For a chart that will change often, keep a separate, well-maintained employee list as the source of truth. Treat the visual chart as a communication tool and check that it agrees with the authoritative records before sharing it. This avoids the common misconception that an org-chart template automatically stays synchronized with HR data.
Create a basic org chart with SmartArt
In Excel for Microsoft 365 on Windows, use the following steps to create a chart in a worksheet:
- Open a blank workbook or the workbook where you want the chart. Select the worksheet and, if useful, a starting cell near the top-left area where the chart will sit.
- Choose Insert > SmartArt. In the SmartArt graphic chooser, select Hierarchy, choose Organization Chart, and select OK.
- Open the Text Pane if it is not visible. You can use the small arrow on the SmartArt graphic’s edge to show or hide the pane.
- Enter the top role first, then enter subordinate roles beneath it using the hierarchy in the pane. A new line at the same text level creates a peer; Tab demotes an entry to a lower level, and Shift+Tab promotes it. Check the displayed hierarchy as you type, since indentation determines reporting level.
- Replace any sample text with real names and titles. Keep each entry concise so it fits in its box, and review the chart for missing, duplicated, or incorrectly nested people.
- Select the graphic and use the SmartArt Design and Format tabs to adjust the layout, colors, and appearance. Save the workbook, then inspect it in Print Preview if the chart will be distributed on paper.
You can also select a shape and choose SmartArt Design > Add Shape to add a person in relation to that selection. The available choices include adding a shape after or before, above or below, and an assistant where the selected layout supports it. The exact options depend on which shape is selected and the SmartArt layout. If the Text Pane and the picture appear inconsistent, use the pane to inspect the indentation and levels.
On Excel for Mac, SmartArt is also available from the Insert tab, though names, placement, and dialog details can vary slightly by release. The instructions above are for Excel for Microsoft 365 on Windows; if a command is not in the same place on Mac, look for SmartArt on the Insert ribbon and its contextual design controls after selecting the graphic.
Choose SmartArt, shapes, or a downloaded template
The best starting point depends on how much control you need and how often the chart changes. SmartArt is usually the quickest choice when the chart follows a conventional top-down hierarchy. It gives you coordinated layouts and makes it easy to add or remove positions, although its automatic spacing may not suit every complex structure.
- Choose SmartArt for a quick, conventional reporting chart that needs modest formatting and can be edited as a single graphic.
- Choose individual shapes and connectors when you need unusual spacing, special annotations, or more precise control over each box. Use Insert > Shapes to add shapes and connector lines; connectors are designed to attach to shapes and remain connected when boxes move.
- Choose a workbook template when its page setup, colors, and included fields already fit your purpose. Review its source and remove sample information before sharing it.
- Choose a dedicated org-chart or diagram tool when the organization is very large, has many cross-functional or dotted-line relationships, or needs automated data updates and specialized publishing features.
SmartArt is not inherently more accurate than shapes, and shapes are not automatically easier to maintain. For a small chart, SmartArt often saves time. For a chart with several reporting conventions, custom shapes can make the relationships clearer, but they require more manual alignment and connector maintenance.
Prepare the information before formatting
A short source table can make planning and checking easier, even though SmartArt does not automatically build itself from that table. Useful columns might include employee name, job title, manager, department, and location. Keep one person per row, use consistent spellings for names and titles, and identify the intended top role clearly. If there are multiple people with similar names, include a distinguishing detail in the source list rather than crowding the chart boxes.
Consider how to represent roles that do not fit a simple hierarchy. For example, a project lead may coordinate work across two departments without being the direct manager of both teams. A solid connector usually implies a reporting relationship; using the same line to mean both management and collaboration can mislead readers. You can explain a dotted line or other convention in a small legend, but avoid using so many line styles that the chart becomes hard to interpret.
For a department chart, include only the roles needed to explain that department’s structure. If you need to show vacancies, label them as open positions rather than leaving an unexplained empty box. If the chart is a snapshot, include an “as of” date in a visible but unobtrusive place. This signals that staffing can change and helps prevent an old chart from being treated as current.
Make the chart readable and printable
Readability matters more than decorative effects. Use a consistent format for names and titles, make text large enough for the intended screen or printed page, and allow space between branches. A simple color scheme can distinguish departments or management levels, but color should not be the only way to communicate meaning. Readers may print in grayscale or have difficulty distinguishing particular colors.
Large charts often become unreadable when forced onto one printed page. Use Print Preview to see how Excel will paginate the worksheet. Depending on the chart’s size, you may need landscape orientation, a larger paper size, or multiple pages rather than shrinking everything until the labels are tiny. Page Layout settings can help control orientation and print area; check the final output rather than assuming the on-screen view will print well.
Keep a little open space around the chart so it does not overlap worksheet content. If you add notes or a legend, place them where they do not interrupt the reporting lines. A useful test is whether a reader unfamiliar with the team can identify the top role, follow a line to a person, and understand any special conventions without asking for an explanation.
Common problems and practical fixes
- Names appear at the wrong level: Check indentation in the SmartArt Text Pane. A line indented too far may become a subordinate when it should be a peer; use Tab or Shift+Tab to change its level.
- Text is cut off or boxes look cramped: Shorten titles where appropriate, enlarge the graphic, or choose a less crowded layout. Avoid shrinking the font so much that the chart is no longer readable.
- The chart changes size unexpectedly: SmartArt can rearrange shapes as entries are added or removed. Review the whole graphic after each substantial edit instead of assuming only the new box has changed.
- Connectors do not follow a box: With separately drawn shapes, use connector lines attached to the shapes rather than ordinary line shapes placed nearby. Check the connections after moving or rearranging boxes.
- The chart does not match the employee list: Compare each person’s manager and department against the source records, and note the chart’s effective date. Do not assume that a template updates when the underlying worksheet data changes.
- The printed chart is too small: Use Print Preview, consider landscape orientation or multiple pages, and simplify the scope before reducing text to an unreadable size.
Keep the chart current and share it carefully
Decide who owns updates and what event triggers a review: a reorganization, a manager change, a hiring round, or a regular monthly or quarterly check. For a small team, a named owner and a dated review may be sufficient. For a larger organization, use the approved employee directory or HR process to verify reporting relationships before publishing a revision.
Use a clear file name and date, and consider keeping a separate working copy from the version distributed to staff. Before emailing or posting the workbook, check for hidden sheets, sample content, comments, and information that is not needed by the audience. An org chart can disclose employee names, roles, and reporting arrangements, so share it through the appropriate channel and follow your organization’s privacy and access rules.
If a chart must be updated by several people, agree on one editable master rather than letting multiple copies circulate. A PDF can be convenient for a read-only reference, but it will not replace the editable workbook when the structure changes. Keep the Excel file as the working version and export a fresh distribution copy when needed.
Frequently Asked Questions
Does Excel have an org chart template?
Excel has a built-in Organization Chart SmartArt layout under Insert > SmartArt > Hierarchy. Workbook templates may also appear in the New gallery, but availability varies. SmartArt is a ready-made layout, not an automatic connection to a staff database.
How do I add a person who reports to a manager?
Select the manager’s shape and use SmartArt Design > Add Shape > Add Shape Below, or add an entry at the next indentation level in the Text Pane. Confirm that the new box appears under the intended manager.
Can Excel make an org chart automatically from a list?
A normal SmartArt org chart does not automatically generate or refresh from a list of employees and managers. You can keep a source table for checking, but the SmartArt graphic must be edited separately unless you use a specialized tool or a custom automation process.
Can I show dotted-line reporting in an Excel org chart?
It is possible to add or format lines with shapes, but explain what a dotted line means in a legend. SmartArt’s standard organization chart is best suited to a straightforward hierarchy, so complex matrix relationships may be clearer in a diagramming tool.
How do I print an org chart on one page?
Check File > Print and review the preview. Landscape orientation or a larger page may help, but forcing a large chart onto one page can make text too small. Consider splitting it into department-level charts when a single page is not readable.
Related
- Meal Planning Excel Sheet: Build a Weekly Planner
- Meal Planning Template Excel: Free Options and Setup
- Meal Planning Spreadsheet Template: Build a Weekly Plan
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Pivot Chart Grand Totals: Why Excel Leaves Them OutNo. In Microsoft Excel for Microsoft 365, a PivotChart does not plot a PivotTable’s grand total, even when…
- Excel Chart Series Name: Change It and Fix Series LabelsTo change an Excel chart series name in Microsoft 365 for Windows, select the chart, choose Chart Design…
- Excel Pie Chart Legend on Slices: How to Add LabelsYes. In Excel for Microsoft 365 on Windows, select the pie chart, then choose Chart Design > Add…
- Excel Donut Chart Total in the Middle?To put a total in the middle of an Excel doughnut chart, calculate the total in a worksheet…
- Excel Line Chart: Change Color Partway Through a LineTo change a line chart’s color partway through in Excel for Microsoft 365 on Windows, split the plotted…
- Excel Trendline: Show More Significant FiguresTo show more digits in an Excel trendline equation, select the equation on the chart, open Format Trendline…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.