Org Chart Format in Excel: Build and Choose a Layout

Charts & pivot tables · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, the quickest org chart format is SmartArt: choose Insert > SmartArt > Hierarchy, select Organization Chart, and enter each person in the text pane. For a small, mostly static team, this produces a clear reporting structure; for a large or frequently changing organization, a structured employee table or a dedicated diagram tool may be easier to maintain.

What an Excel org chart shows

An organizational chart, or org chart, represents relationships between roles or people. In a conventional chart, each box identifies a person or position, and connecting lines show who reports to whom. The top box usually represents the head of a department or organization, with managers and their direct reports arranged beneath it.

Excel does not have a separate chart type called an org chart in the same sense as a column or pie chart. Its built-in option is an Organization Chart layout in SmartArt, under the Hierarchy category. SmartArt is a diagram made from shapes and connectors, rather than a chart generated from a range of worksheet data. That distinction matters: changing a name in the underlying employee list will not automatically update a SmartArt diagram.

An org chart is useful for showing a chain of command, team structure, or points of contact. It is not necessarily a complete record of how work gets done. Project teams, dotted-line relationships, shared services, and temporary assignments can be difficult to show in a single, conventional hierarchy. Decide what the diagram is intended to communicate before adding detail.

Choose a format that fits the organization

The best format depends on the size of the group, how often it changes, and where readers will use the chart. A simple hierarchy is often more readable than a design with many colors, labels, or crossing lines.

  • Small team: Use a single Organization Chart SmartArt graphic. It is quick to create and easy to present or print.
  • Several departments: Use one chart per department, or create a high-level chart that names department heads and link it to more detailed team charts.
  • Large organization: Keep a table of employee and manager information as the source of truth. Consider a diagramming application if the chart must be generated, maintained, or navigated at scale.
  • Roles rather than named staff: Put job titles in the boxes if the purpose is to document positions instead of current employees. This can make the chart more useful when people change roles.
  • Confidential information: Include only details needed for the chart. Personal phone numbers, home addresses, and other sensitive information generally do not belong in a broadly shared org chart.

Choose whether to display names, titles, departments, or some combination before building the layout. A box containing a name, title, location, email address, and several notes may become too crowded, particularly when printed. Often a name and title are enough, with contact information kept in a separate directory.

Create an org chart with SmartArt

In desktop Excel for Microsoft 365 on Windows, use these steps to create a basic chart:

  1. Open the worksheet where the chart should appear. Choose Insert > SmartArt.
  2. In the SmartArt dialog, select Hierarchy, choose Organization Chart, and select OK.
  3. Select the text pane control at the left edge of the SmartArt graphic if the pane is not already open. Enter the top role or person first, then add subordinate entries on the lines below.
  4. Use Tab in the text pane to indent an entry and make it subordinate to the preceding level; use Shift+Tab to move an entry up a level. Check the resulting boxes carefully, since indentation determines reporting structure.
  5. Close the text pane when the structure is correct. Select a box to edit its text, or use the SmartArt Design tab to add or rearrange shapes.
  6. Resize and position the graphic on the worksheet, then review it at the size at which people will read or print it.

For example, an outline might list the chief operating officer first, then indent a finance director and operations director beneath that person. Indent the finance manager beneath the finance director, not beneath the operations director. In the graphic, the chief operating officer appears above both directors, while the finance manager appears under the finance director. A small indentation mistake in the text outline can therefore change the meaning of the chart.

When entering the outline, make each reporting level explicit rather than relying on blank lines or spaces. If the hierarchy is already written in a document, pasting text into the SmartArt text pane can save typing, but inspect every level afterward. Formatting in pasted text may not translate into the intended hierarchy.

Add positions and arrange the reporting lines

SmartArt provides controls for changing the hierarchy without rebuilding the diagram. Select the relevant shape, then use SmartArt Design > Add Shape. Depending on the relationship needed, the menu offers choices such as adding a shape after or before the selected shape, above or below it, or adding an assistant. An assistant is a distinct position type in some organization charts; it is not the same as an ordinary direct report.

The text pane is often the simplest way to make broad structural changes, while Add Shape is convenient for a local change. After adding a box, enter its text and verify that it is attached to the correct manager. Moving a box visually is not always the same as changing its reporting relationship: the underlying hierarchy controls how SmartArt arranges its shapes.

Keep the chart’s direction consistent. A typical organization chart flows from top to bottom, with peers on the same level. If several people report directly to one manager, place them as peer boxes rather than stacking them as if one reports to another. When there are too many direct reports for a readable row, consider dividing the chart by function or creating a second, more detailed chart.

Format boxes for clarity

Use formatting to make levels and groups easier to scan, not to decorate every box differently. Select the SmartArt graphic to display the SmartArt Design and Format tabs. SmartArt Design includes layout and color options; Format provides shape and text formatting controls. The available commands can vary with the selected object and Excel version.

  • Use a consistent font size and text style across equivalent roles.
  • Use restrained color differences to distinguish departments or levels, and provide a legend if color carries meaning.
  • Keep box text brief. If a title wraps into many lines, shorten it or increase the graphic’s width.
  • Use a high-contrast combination so the chart remains readable on screen and in print.
  • Do not rely on color alone to convey a distinction; labels and position should make the structure understandable too.

SmartArt styles can quickly change the appearance of the whole diagram, but a more elaborate effect is not automatically more legible. Check that connectors remain visible and that boxes do not overlap after changing the layout or resizing the graphic. If you need precise placement that SmartArt does not provide, separate shapes and connector lines offer more control, but they also require more manual upkeep.

Keep the chart accurate and maintainable

For a chart that will be updated regularly, maintain the reporting information in a worksheet table as well as, or instead of, relying on the diagram alone. Useful fields may include employee name, job title, department, and manager. A manager field can help identify the relationship explicitly, while the chart gives readers a visual overview. Limit access to the table if it contains information that should not be broadly shared.

SmartArt does not automatically synchronize its boxes with an employee table. If a manager changes, a person joins, or a position is removed, update the diagram and check the affected reporting lines. Consider adding an effective date or a brief note such as “structure as of November 2026” so readers know when the information was current. If the chart is copied into presentations or documents, update those copies too.

For a static chart, a short review checklist can prevent common errors:

  • Confirm the top role and every direct-report relationship with an authoritative source.
  • Check spelling, titles, department names, and any displayed contact details.
  • Look for people accidentally placed under the wrong manager or at the wrong level.
  • Remove vacant positions or mark them clearly if vacancies are part of the chart’s purpose.
  • Record who owns the chart and how often it should be reviewed.

Printing and sharing an Excel org chart

A chart that looks fine while zoomed in may be unreadable on a printed page. Before printing, select the relevant worksheet area and use Page Layout controls to review orientation, margins, and scaling. Landscape orientation may suit a wide hierarchy. Excel’s print preview helps reveal whether the graphic is being split across pages or reduced too far. Fit-to-page scaling can force a large chart onto one page, but it may shrink the text below a comfortable reading size; using multiple pages or exporting a larger layout may be better.

Consider placing the diagram on a dedicated worksheet with a clear title and a date or version note. Hide unrelated worksheet clutter from the print area, and check the final output rather than assuming the on-screen view matches the printed result. When sharing the workbook, remember that recipients may be able to access other sheets or workbook data; remove or protect material that should not be included before sending it.

Excel for the web and Mac may present commands differently from desktop Excel for Windows, and available editing features can vary. If the SmartArt controls needed to create or revise the diagram are missing in a particular environment, open the workbook in desktop Excel and confirm that the intended recipient can view the finished file.

SmartArt versus shapes, tables, and other tools

SmartArt is usually the most convenient choice for a straightforward hierarchy because it manages the basic relationship between boxes and connectors. Its limitation is that it is not a live view of an employee data table, and intricate layouts can become hard to control.

Individual shapes and connector lines give more freedom to position boxes, add notes, or depict unusual relationships. In Excel, create them from Insert > Shapes. This approach can suit a small diagram with special requirements, but each shape and line is a separate object that may need adjusting after a change. For larger charts, manual editing can become tedious and can lead to inconsistent spacing or broken-looking connections.

A worksheet table is better for sorting, filtering, and maintaining employee records, but a table alone does not show the hierarchy as immediately as a diagram. A dedicated diagramming tool may be more appropriate when the organization is large, the chart changes often, or readers need a polished, navigable diagram. The choice is not simply about appearance: weigh update effort, data privacy, output size, and whether the chart must reflect a source list automatically.

Frequently Asked Questions

Does Excel have an org chart template?
Excel includes an Organization Chart SmartArt layout under Insert > SmartArt > Hierarchy. It is a built-in diagram layout, although the exact templates and styling options shown may differ by version.

Can an Excel org chart update automatically from a table?
A standard SmartArt organization chart does not automatically refresh from a worksheet table. Treat the table and diagram as separate content, or use a tool or process designed to generate diagrams from structured data.

How do I add an assistant or another direct report?
Select the appropriate box and use SmartArt Design > Add Shape. Choose Add Assistant for an assistant position or an option such as Add Shape Below for a subordinate, then verify the new box’s placement and relationship.

Can I make an org chart in Excel without SmartArt?
Yes. Use Insert > Shapes to add boxes and connector lines. This gives you more placement control, but you must manage the connections and layout yourself when the chart changes.

Why is my org chart too small when I print it?
A wide or tall chart may be scaled down to fit the selected print area or page. Check print preview, use landscape orientation or more than one page, and avoid forcing a large diagram onto one sheet if doing so makes the text difficult to read.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.