Easy Org Chart in Excel: Steps and Tips

Charts & pivot tables · Updated November 19, 2026

Yes. The easiest way to make an org chart in Excel for Microsoft 365 on Windows is to use SmartArt: choose Insert > SmartArt > Hierarchy > Organization Chart, then enter each person in the text pane. SmartArt arranges the reporting structure for you, so you do not have to draw every box and connector by hand.

Why SmartArt is the quickest option

Excel’s SmartArt organization chart is designed to show who reports to whom. You add people and set their levels in a text outline; Excel turns that outline into connected boxes. That is usually faster and easier to update than positioning a separate shape for every employee.

SmartArt is a visual layout, not a live chart generated from an employee database. It will not automatically interpret a worksheet column called Manager or refresh itself when you change a source table. You make structural edits in the SmartArt graphic or its text pane. For a small team or a presentation-ready overview, this is often all that is needed. For a large organization with frequently changing reporting lines, a dedicated diagram or HR tool may be more practical.

Create an org chart step by step

  1. Open a blank worksheet. You can keep the chart on a dedicated sheet so it is easier to print and share. Save the workbook before making substantial changes.
  2. Insert the chart. On the Windows ribbon, choose Insert > SmartArt. In the SmartArt gallery, select Hierarchy, choose Organization Chart, and select OK.
  3. Open the text pane. If it is not visible, select the small arrow on the left edge of the SmartArt graphic. The pane presents the reporting structure as an indented list.
  4. Enter the people and reporting levels. Replace the sample text with the top role, then add the next level and its direct reports. Use Tab to indent an entry as a subordinate and Shift+Tab to move an entry up a level. Press Enter to add another entry at the same level.
  5. Adjust the structure and appearance. Select the chart to show the contextual SmartArt Design and Format tabs. Use the SmartArt Design controls to add or promote shapes and choose a layout or color style.

For example, an outline might begin with Ava Chen, CEO. At the next level, list Marcus Lee, Operations, and Nina Patel, Finance. Indent the operations managers beneath Marcus and the finance team beneath Nina. The resulting chart shows both managers reporting to the CEO, rather than treating every name as a separate top-level role.

Build the reporting hierarchy correctly

Decide what each box represents before filling in the chart. Many org charts use one box per person, with a name and role together, such as Ava Chen — CEO. Others show only positions, which can be useful when documenting a proposed structure or a team with vacancies. Be consistent: mixing job titles in some boxes and names in others can make the diagram hard to interpret.

Think of the text pane as an outline. An entry at the leftmost level is above entries indented beneath it; entries at the same indentation are peers. Check the levels before spending time on colors, because changing indentation changes the reporting relationships. A common error is to press Enter and keep typing without noticing that the new entry inherited the wrong level.

SmartArt is most legible when the chart shows a useful slice of the organization rather than every employee in a large company. You can create separate charts for departments or locations and label them clearly. If the chart is meant to show reporting relationships, avoid placing people beside one another simply to make the layout look balanced; their visual position implies a relationship.

Add roles, assistants, and direct reports

To add a person, select a nearby shape and use the controls on SmartArt Design > Add Shape. The available commands include options for adding a shape before or after the selected one, above it, below it, or an assistant, depending on the selected layout and shape. Choose the relationship that matches the intended structure, then enter the person’s information. You can also add entries in the text pane and set their indentation there.

Use an assistant position only when the role genuinely needs to be distinguished from a standard direct report. For instance, an executive assistant may support the CEO without managing a department. The diagram’s layout can communicate that distinction, but clarify unusual or dotted-line relationships with a note or legend rather than relying on readers to infer them.

If you move a person to another manager, change the hierarchy in the text pane or use the SmartArt controls, then inspect the result. Do not try to create a new reporting line by dragging a box to a different spot: SmartArt’s underlying outline determines the structure, and a visually attractive position alone does not change who reports to whom.

Format the chart so it is easy to read

Select the graphic to use SmartArt Design for layout, colors, and styles, and Format for options affecting selected shapes. Start with a restrained style and use color to clarify groups or levels, not to decorate every box differently. If colors have a specific meaning, explain that meaning in a short legend.

Check the font size at the size people will actually view or print the chart. Long names and titles can make boxes wide and the full diagram unwieldy. Use short, recognizable role labels, and consider splitting a large chart into department-level views instead of shrinking text until it is difficult to read. Keep wording and punctuation consistent across boxes.

For a presentation, use a clear title and include an as-of date if the structure may change. This helps readers distinguish a current chart from an old copy. A date is especially useful when the file is circulated separately from the spreadsheet or printed for a meeting.

When to draw boxes and connectors manually

SmartArt is usually the best starting point, but shapes can be a better fit when you need unusual grouping, extra notes, or a layout that does not fit a standard hierarchy. On the ribbon, choose Insert > Shapes, add rectangles for people or roles, and add connector lines between them. Connector shapes are preferable to ordinary drawn lines because they can remain attached to shapes when you move the boxes.

Manual diagrams give you more freedom, but they take more care to maintain. Align and distribute boxes using the alignment controls on the contextual Shape Format tab, and check that connectors meet the intended shapes. If a manager changes, you may need to move several boxes and adjust multiple lines. Keep a copy before substantial redesigns, and do not assume a manual chart will stay organized automatically.

For teams that maintain employee data in a table, keep the authoritative names, titles, and manager assignments in that table even if you make the visual chart separately. That makes it easier to check the diagram against the source information. Excel does not automatically convert a manager-name column into a SmartArt org chart, so any link between the table and graphic needs a separate process.

Print, share, and keep the chart current

Before printing, use Page Layout > Orientation > Landscape if the chart is wider than it is tall. Set a print area with Page Layout > Print Area > Set Print Area if the worksheet contains other material, and inspect the result in print preview. The Scale to Fit controls can reduce a chart to one page wide, but fitting a large organization onto a single page may make names unreadable. Printing across multiple pages or dividing the chart by department can be clearer.

When sharing, include enough context for someone opening the file later: a chart title, an effective date, and a note explaining abbreviations or dotted-line reporting where needed. Review the workbook’s sharing permissions and avoid including personal details that are not needed for the chart. Names and job roles may be appropriate; private contact details or sensitive employment notes usually are not.

Because SmartArt is edited directly rather than automatically synchronized from a roster, establish who is responsible for updating it. After a reorganization, verify both the names and the reporting levels. If the workbook is a record used for decisions, retain an approved copy or version history according to your organization’s normal document practices.

Common problems and practical fixes

  • The chart is too crowded: Show one department or management layer at a time, or create separate charts for different groups. A smaller font is not always the best fix.
  • A person appears under the wrong manager: Check the entry’s indentation in the SmartArt text pane. Adjust its level and inspect the chart again.
  • Text is clipped or boxes are too wide: Shorten role wording, enlarge the graphic area, or use a simpler layout. Review long names and titles individually.
  • The chart looks different after printing: Check print preview, orientation, scaling, and page breaks. Ensure the entire SmartArt graphic is inside the print area.
  • You cannot find the SmartArt controls: Select the graphic first; its contextual tabs appear only when it is selected. Ribbon labels and available controls can vary by platform and Excel version. On Mac, look for the corresponding SmartArt commands after selecting the graphic; if a control is missing or the editing experience is limited in Excel for the web, open the workbook in desktop Excel.

Frequently Asked Questions

Can Excel make an org chart automatically from a list?
Not directly with the standard SmartArt organization chart. It expects you to enter or edit the hierarchy in the graphic’s text pane; a table with employee and manager columns is not automatically converted into reporting lines.

How do I add a person to an org chart in Excel?
Select a relevant shape and use SmartArt Design > Add Shape, or add the entry in the text pane at the correct indentation level. Choose above, below, or another available position based on the reporting relationship.

Can I put a job title under a person’s name?
Yes. You can include a name and title in the same shape, using concise text that fits the box. Keep the format consistent throughout the chart so readers can quickly tell which line is the name and which is the role.

Can I make an org chart in Excel for free?
If you already have access to Excel, SmartArt is included in the desktop application; there is no separate org-chart purchase required. Access to Excel itself depends on the license or service available to you.

Is SmartArt better than drawing the chart with shapes?
For a conventional reporting hierarchy, SmartArt is usually quicker because it manages the basic layout. Manual shapes offer more control over unconventional diagrams, but arranging and maintaining their boxes and connectors takes more work.

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.