How to Make an Org Chart in Excel

How to Make an Org Chart in Excel

An organizational chart gives your team a clear picture of who reports to whom and how your business is structured. Even in a small company, an org chart eliminates confusion about reporting lines, helps new hires understand the team, and is useful when communicating with investors, partners, or clients. Learning how to create an org chart in Excel is a practical skill because most small business owners already have access to the software.

This guide walks through building an org chart using Excel's built-in SmartArt feature, customizing the layout, and keeping it accurate over time.

Why Create an Org Chart?

You might think org charts are for big corporations with hundreds of employees. But small businesses benefit from them too:

• Clarity for new hires. When someone joins a 10-person team, an org chart helps them quickly understand who does what and who they should go to for different needs.
• Planning for growth. Visualizing your current structure makes it easier to see where you need to add roles as the business grows.
• External communication. Banks, investors, and potential clients sometimes ask for an organizational overview. Having one ready saves you from scrambling.
• Identifying gaps and overlaps. Seeing the structure visually can reveal that one person has too many direct reports or that a critical function has no clear owner.

Before You Start

Gather this information for every person on your team:

• Full name
• Job title
• Who they report to (their direct manager)
• Department or team (if applicable)

For a small business, you may also want to note part-time status, contract roles, or shared responsibilities. Having this list ready before you open Excel makes the process much faster.

Step 1: Open Excel and Insert SmartArt

SmartArt is Excel's built-in diagramming tool, and it includes organizational chart layouts specifically designed for this purpose.

1. Open a new or existing Excel workbook
2. Click on the Insert tab in the ribbon
3. Click SmartArt (in the Illustrations group)
4. In the dialog box that appears, select Hierarchy from the left-hand panel
5. Choose Organization Chart (the first option in most versions of Excel)
6. Click OK

A basic org chart template will appear on your spreadsheet with placeholder boxes.

Step 2: Add Names and Titles

Click on the placeholder text in each box to enter employee information. A standard approach is to include both the person's name and their title:

Sarah Chen
Owner / CEO

The SmartArt text pane (a small panel that appears to the left of the chart) lets you type entries in an outline format. Each line in the text pane corresponds to a box in the chart. Indented lines create subordinates.

Example text pane structure:

Sarah Chen, Owner
  Mike Johnson, Operations Manager
    Lisa Park, Shift Lead
    Tom Rivera, Shift Lead
  Amy Walsh, Office Manager
    David Kim, Bookkeeper

In this structure, Mike and Amy report to Sarah. Lisa and Tom report to Mike. David reports to Amy.

Step 3: Add and Remove Boxes

Your initial template may not have enough boxes for your team, or it may have too many.

To Add a Box

• Click on an existing box that is at the same level or is the manager of the new person
• In the SmartArt Design tab (which appears when the SmartArt is selected), click Add Shape
• Choose the appropriate option:
  • Add Shape After or Add Shape Before: Adds a peer at the same level
  • Add Shape Below: Adds a direct report
  • Add Shape Above: Adds a manager above the selected person

To Remove a Box

• Click on the box you want to remove
• Press the Delete key on your keyboard

You can also add and remove entries directly in the text pane. Adding a new line creates a new box. Deleting a line removes a box.

To Reorganize Reporting Lines

Use the text pane to change who reports to whom. Promoting (unindenting) or demoting (indenting) a line in the text pane changes that person's position in the hierarchy.

• Tab key: Indents the entry, making it a subordinate of the entry above it
• Shift + Tab: Unindents the entry, promoting it one level up

Step 4: Format the Chart

The default SmartArt styling is functional but plain. Here is how to make it look professional:

Change Colors

• Select the SmartArt graphic
• Go to the SmartArt Design tab
• Click Change Colors to pick a color scheme that matches your brand or preference

Apply a Style

• In the same SmartArt Design tab, browse the SmartArt Styles gallery
• Hover over styles to preview them
• Choose one that gives the chart a clean, professional look. The "Subtle Effect" or "Moderate Effect" options work well for business documents

Adjust Individual Boxes

Right-click on any individual box to:

• Change its fill color (useful for highlighting departments or distinguishing roles)
• Modify the font size and style
• Resize the box by dragging its handles

Department Color Coding

A helpful visual technique is to assign a background color to each department. For example:

• Operations team: Light blue
• Administrative team: Light green
• Sales team: Light orange

This makes it instantly clear which department each person belongs to without reading every title.

Step 5: Choose the Right Layout

SmartArt offers several hierarchy layouts. The default "Organization Chart" layout works for most small businesses, but consider alternatives:

Standard Layout

Each manager has direct reports displayed below them in a horizontal row. This is the most common and easiest to read for teams up to about 20 people.

Both Hanging Layout

Direct reports are displayed in two columns beneath their manager instead of a single row. This is useful when one manager has many direct reports because it uses vertical space more efficiently.

Left Hanging / Right Hanging

All direct reports are listed in a single column to the left or right of the connector line. This works well for narrow page layouts.

To change the layout of a specific branch:

1. Click on the manager's box
2. Go to the SmartArt Design tab
3. Click Layout and select your preferred option

Step 6: Position the Chart on Your Spreadsheet

By default, the SmartArt graphic floats over your spreadsheet cells. You can:

• Resize it by dragging the corner handles to make it larger or smaller
• Move it by clicking and dragging the border
• Dedicate a worksheet to the org chart by creating a new tab named "Org Chart" and placing the graphic there. This keeps it separate from your data

For printing, go to Page Layout and switch to Landscape orientation. Use Print Preview to verify the chart fits on one page. Adjust the size if needed.

Tips for Keeping Your Org Chart Updated

An org chart is only useful if it reflects reality. Here are practices to keep it current:

Update When Changes Happen

Whenever someone is hired, promoted, transferred, or leaves, update the chart immediately. If you wait, updates pile up and the chart becomes unreliable.

Assign an Owner

Designate one person as the owner of the org chart. This person is responsible for making updates and ensuring accuracy. In a small business, this is often the owner or office manager.

Review Quarterly

Even with an assigned owner, schedule a quarterly review to verify the chart matches your actual team structure. Compare it against your payroll or employee list to catch any discrepancies.

Version Control

Save each version of the org chart with a date in the filename (for example, "OrgChart_2026-02.xlsx"). This gives you a historical record of how your organization has evolved and lets you revert if an update introduces an error.

Share It Accessibly

Post the current org chart where employees can find it, whether that is a shared drive, an internal wiki, or printed in the break room. If people cannot access it, they will not use it, and they will not tell you when it is wrong.

Limitations of Org Charts in Excel

Excel's SmartArt is a good starting point, but it has limitations:

• Manual updates required. Every change to your team means manually editing the chart.
• No connection to employee data. The chart does not pull information from your employee records, so names, titles, and reporting lines can drift out of sync.
• Formatting challenges. Large charts become hard to format and keep readable. Moving one box often shifts the layout of everything else.
• No collaboration. Multiple people cannot easily edit the same SmartArt chart simultaneously.
• Static output. The chart is a snapshot. It does not update automatically when your team changes.

When to Move Beyond Excel

If you find yourself spending more time reformatting the chart than it takes to read it, or if you forget to update it after every personnel change, it may be time for a different approach.

Boring HR's Team Tracker can auto-generate an organizational chart from your employee data. When you add a new hire, update a title, or change a reporting line in the system, the org chart reflects it automatically. No SmartArt wrestling, no version control headaches, and no risk of the chart getting stale. For small businesses that want an org chart that stays accurate without manual effort, it is a practical alternative to maintaining one in Excel.