How to Create an Organizational Chart in Excel

Excel isn't the first tool most people think of for org charts — but it's often the most accessible one. No specialized software subscription, no steep learning curve, and no exporting headaches if your team already lives inside Microsoft Office. The process works differently depending on which approach you take, and the right method depends on factors like chart size, how often it needs updating, and how polished the final output needs to look.

What Is an Org Chart and Why Build One in Excel?

An organizational chart is a diagram that maps reporting relationships within a team, department, or entire company. Each box typically represents a person or role, and connecting lines show who reports to whom.

Excel handles org charts through two main paths: using SmartArt graphics (built-in, visual, beginner-friendly) or using shapes and connectors manually (more flexible, better for complex structures). There's also a third option — using data to auto-generate a hierarchy through add-ins or linked tools — which suits larger organizations but requires more setup.

Method 1: Using SmartArt (The Fastest Route)

SmartArt is Excel's built-in diagramming feature. It's the quickest way to get a clean, formatted org chart without touching individual shapes.

Steps to create a SmartArt org chart:

1. Open Excel and navigate to the worksheet where you want the chart.
2. Click the Insert tab in the ribbon.
3. Select SmartArt from the Illustrations group.
4. In the dialog box, choose Hierarchy from the left panel.
5. Select a layout — Organization Chart is the standard choice; Picture Organization Chart lets you add photos.
6. Click OK to insert the base template.
7. Click each shape and type the name, title, or role directly into it.
8. Use the Text Pane (the arrow on the left side of the SmartArt) to manage hierarchy levels — indented items become subordinates.

To add or remove boxes, right-click a shape and use Add Shape options: "Add Shape After," "Add Shape Below" (subordinate), or "Add Assistant" for staff roles that sit outside the direct chain.

To change the visual style, select the entire SmartArt and use the SmartArt Design tab to switch color schemes or apply 3D effects.

SmartArt Limitations to Know

SmartArt is fast but not infinitely flexible. Once charts grow beyond roughly 30–40 people, the automatic layout can become cramped and hard to read. You also have limited control over individual connector line styles and box positioning — Excel handles placement automatically.

Method 2: Building Manually with Shapes and Connectors 🔧

For teams that need precise control over layout, the manual approach using shapes and connectors gives you full flexibility.

Basic process:

1. Go to Insert → Shapes and choose a rectangle or rounded rectangle for your boxes.
2. Draw one box, add text (double-click the shape to type), and format it.
3. Copy and paste that shape to create consistent boxes for each role.
4. To connect boxes, go to Insert → Shapes and select a connector line (straight, elbow, or curved).
5. Hover over a box until you see the connection points (small dots appear), then click and drag to another box.

The advantage here is granular control — you can resize individual boxes, use color coding to represent departments, and arrange the chart across a large canvas. The downside is that connections don't update automatically if you move boxes. You'll need to reattach connectors manually after repositioning.

Tip: Use Align and Distribute tools (found under the Shape Format tab → Arrange group) to keep your layout clean without manually eyeballing spacing.

Method 3: Data-Driven Org Charts via Add-Ins or Visio Integration

If your organization has more than a few dozen people, or if the chart needs to update regularly from HR data, a data-driven approach becomes practical.

Excel integrates with Microsoft Visio (which has a dedicated Org Chart Wizard) and supports third-party add-ins available through Insert → Get Add-ins. Some add-ins let you format a simple two-column table (Name, Reports To) and generate a visual hierarchy automatically.

This method requires more upfront setup but dramatically reduces manual effort when roles change frequently.

Formatting Tips That Make a Difference 🎨

• Use consistent box sizes — mismatched shapes make charts look unfinished even when the content is correct.
• Color-code by department — a simple fill color on boxes makes large charts scannable at a glance.
• Limit font sizes — titles at 10–11pt and names at 9pt keeps boxes readable without becoming overwhelming.
• Group all elements — once done, select everything and group it (Ctrl+G or right-click → Group) so the chart moves as a single object.
• Turn off gridlines for a cleaner presentation: go to View → Show and uncheck Gridlines.

The Variables That Change Your Approach

How you should build your org chart in Excel depends on several factors that vary from one user to the next:

• Chart size — a 10-person team and a 200-person company need fundamentally different approaches.
• Update frequency — a chart you rebuild quarterly needs a different setup than one you maintain weekly.
• Audience — internal working documents can be rougher; charts destined for slide decks or executive presentations benefit from manual polish.
• Excel version — SmartArt options and available add-ins differ between Excel for Microsoft 365, Excel 2019, Excel 2016, and the web version. Some features are desktop-only.
• Technical comfort level — SmartArt is forgiving; the manual shapes method rewards familiarity with Excel's drawing tools.

The same Excel version running on two different workflows — one a static HR directory, one a fast-changing startup team — calls for completely different solutions. Getting the method right means understanding your own chart's lifecycle, not just how the tool works.