How to Create an Org Chart in Excel: A Complete Guide

Org charts are one of those things that look polished when done well — and surprisingly achievable in Excel once you know where to look. Excel isn't a dedicated diagramming tool, but it has two legitimate paths to building a clean organizational chart, and understanding both helps you choose the right approach for your situation.

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

An organizational chart is a visual diagram that maps reporting relationships within a group — who reports to whom, how teams are structured, and where roles sit in a hierarchy. They're used in HR documentation, onboarding materials, project planning, and company presentations.

Excel is a common choice because most people already have it, it integrates easily with other Office files, and for smaller organizations, it's genuinely capable enough. The trade-off is that Excel isn't purpose-built for diagrams, so larger or more complex charts can become harder to manage compared to dedicated tools.

Method 1: Using SmartArt Graphics 🎨

The fastest way to create an org chart in Excel is through SmartArt, Excel's built-in diagram tool.

How to Insert a SmartArt Org Chart

1. Open your Excel workbook and select the sheet where you want the chart.
2. Go to the Insert tab in the ribbon.
3. Click Illustrations, then select SmartArt.
4. In the SmartArt gallery, choose the Hierarchy category on the left.
5. Select Organization Chart (the first option) and click OK.

A basic chart template appears with placeholder boxes. You can type directly into each shape or use the Text Pane (a panel that opens on the left) to enter names and titles in a bulleted outline format — indenting creates subordinate levels automatically.

Adding and Removing Boxes

• Add a subordinate: Click an existing box, then in the SmartArt Design tab, use Add Shape Below.
• Add a peer: Use Add Shape After or Add Shape Before.
• Add an assistant: Use Add Shape → Add Assistant for roles that sit alongside the hierarchy (like an executive assistant).
• Delete a box: Click it and press the Delete key.

Formatting the SmartArt Chart

The SmartArt Design and Format tabs appear when the chart is selected. From here you can:

• Apply a color scheme that matches your brand or document theme
• Switch to a different layout style within the Hierarchy category (such as Half, Both, or Left Hanging — useful for wide teams)
• Resize individual shapes or the entire chart by dragging corner handles

SmartArt is the right call when you need something quick, reasonably presentable, and don't have a huge number of nodes to manage.

Method 2: Building an Org Chart Manually with Shapes

For more control over design, layout, and positioning, you can build an org chart from scratch using Excel's Shapes tools.

Setting Up the Structure

1. Go to Insert → Illustrations → Shapes.
2. Choose a shape — rectangles or rounded rectangles work well for role boxes.
3. Draw your first box, then right-click it to Add Text (name, title, department).
4. Copy and paste the shape to create additional boxes, then position them to reflect your hierarchy.

Connecting Boxes with Lines

1. In the Shapes menu, select a connector line (the elbow or straight connectors work best for org charts).
2. Hover over a shape — small blue dots (connection points) appear on the edges.
3. Click a connection point and drag to another shape's connection point.
4. The line stays attached even when you move shapes around.

Tips for Clean Manual Charts

• Align shapes precisely using the Format tab → Align tools (Align Center, Distribute Vertically, etc.) — this prevents lopsided layouts.
• Group related shapes so entire departments move together.
• Use a consistent color scheme by role level (e.g., blue for leadership, gray for individual contributors) to make hierarchy instantly readable.

This method takes longer but gives you full control over every visual element — useful when you need a polished chart for a presentation or a complex, multi-department structure.

Key Variables That Affect Your Approach

Handling Larger or More Complex Organizations

Excel starts to show its limits as org charts grow. With 50+ roles, boxes become difficult to arrange without overlap, and SmartArt can feel rigid. At that scale, a few practical adjustments help:

• Split by department — create separate charts for each team on different sheets, with a top-level summary on a master sheet.
• Use a data-driven approach — some users maintain the org data in Excel cells (Name, Title, Reports To) and use that as a reference to build or update the chart manually, keeping the source of truth separate from the visual.
• Consider whether Excel is the right tool — dedicated tools handle large hierarchies more gracefully. But for organizations up to around 30–40 people, Excel's built-in options are workable with good organization. 📊

Updating and Maintaining Your Chart Over Time

Org charts go stale quickly. A few habits keep them accurate:

• Lock the chart to a specific sheet so it doesn't get accidentally moved during spreadsheet edits.
• Note the "as of" date somewhere on the chart — a simple text box works fine.
• Use consistent naming conventions for roles so the chart reads the same way throughout.

With SmartArt, updating means editing the text pane. With manual shapes, it means repositioning and reconnecting boxes — which is why the shape method requires more maintenance effort as people change roles or teams restructure.

What the Right Method Actually Depends On

The mechanics of creating an org chart in Excel are straightforward once you've worked through them once. Where it gets personal is matching the method to your actual situation — how many people are in the chart, how often it changes, how much design polish matters, and how comfortable you are with Excel's layout tools. A freelancer building a quick team map for a client proposal has very different needs than an HR team maintaining a 200-person company chart. The tool is capable in both directions; what it can't do is make that call for you.