How to Create an Org Chart in Excel (And Why You'll Outgrow It)
Excel is the Swiss Army knife of business software. Need a budget? Excel. Project timeline? Excel. Org chart? Well... Excel can do it, but it's not great at it. Here's how to make an org chart in Excel, and an honest assessment of when you should switch to something purpose-built.
Method 1: Using SmartArt (Recommended for Excel)
SmartArt is the built-in diagramming tool in Microsoft Office. It's the easiest way to create an org chart in Excel.
Step 1: Insert SmartArt
Go to Insert → SmartArt (or Insert → Illustrations → SmartArt depending on your Excel version). In the dialog, select Hierarchy from the left panel, then choose "Organization Chart".
Step 2: Enter Names and Titles
Click each box in the SmartArt graphic and type the person's name and title. You can also use the Text Pane (toggle with the small arrow on the left side of the SmartArt) to type entries as a bulleted list — each indent level becomes a reporting relationship.
Step 3: Add More People
To add a new person: select an existing box, then go to SmartArt Design → Add Shape. Choose:
- Add Shape Below — adds a direct report
- Add Shape After — adds a peer (same level, same manager)
- Add Shape Above — adds a manager above the selected person
- Add Assistant — adds an assistant role (connected differently)
Step 4: Format and Style
Use SmartArt Design → Change Colors to apply a color scheme, and SmartArt Design → SmartArt Styles for visual effects. You can also right-click individual boxes to change fonts, colors, and sizes.
Step 5: Save or Export
Save your workbook. To share as an image, right-click the SmartArt graphic → Save as Picture to export as PNG or JPEG.
Method 2: Using Shapes (Manual Approach)
If SmartArt feels too rigid, you can build an org chart manually with shapes:
- Go to Insert → Shapes and choose rectangles for people boxes
- Draw a box for each person and type their name/title
- Use Lines or Connectors from the Shapes menu to draw reporting lines
- Use Align tools (Format → Align) to keep things tidy
This gives you more control but takes significantly more time. For anything beyond 15 people, this approach becomes tedious.
Method 3: From a Data Table (Advanced)
Some people try to build org charts from employee data in Excel cells using formulas, conditional formatting, or VBA macros. While technically possible, this is complex, fragile, and hard to maintain. If your data is already in a spreadsheet, it's much easier to import it into a dedicated org chart tool than to build a chart renderer in Excel.
When Excel Org Charts Work Fine
- Very small teams (under 15 people). SmartArt handles small charts reasonably well.
- One-time use. If you need an org chart for a single presentation and won't update it, Excel is fine.
- You already have Excel open. If the team data is in a spreadsheet and you just need a quick visual, SmartArt is the path of least resistance.
- Budget is zero. If your company won't pay for any tools and you have Office, this works.
When Excel Org Charts Break Down
Here's where Excel falls apart — and these aren't edge cases, they're things that happen to virtually every company:
- More than 20-30 people. SmartArt becomes unwieldy. Boxes get tiny, text becomes unreadable, and the layout algorithm produces ugly results. Manual shapes at this scale is a nightmare.
- Frequent updates. Every time someone joins, leaves, or changes roles, you have to manually rearrange the SmartArt. There's no way to just edit a data field and have the chart update.
- Dotted-line relationships. SmartArt doesn't support dotted lines. If someone has a secondary reporting relationship (extremely common), you can't represent it without hacking in manual shapes.
- Sharing and collaboration. You can share the Excel file, but there's no live link. Recipients get a snapshot that's outdated as soon as the next change happens.
- Photos. Adding headshots to SmartArt boxes is technically possible but painful — the sizing and cropping tools are crude.
- Departments and filtering. You can't filter the chart to show just one department, or collapse sections to focus on specific areas.
- Multiple export formats. Need a PDF for the board, a PNG for the wiki, and a PowerPoint slide for the all-hands? That's three separate export processes in Excel.
The honest truth: Excel org charts work for about 6 months at a growing company. Then someone gets frustrated enough to find a better solution.
The Better Approach: Spreadsheet Data → Dedicated Tool
Here's what we recommend: keep your people data in a spreadsheet (Excel, Google Sheets, or your HRIS) and use a dedicated tool to visualize it.
With OrgCanvas, you can:
- Import your existing spreadsheet — columns are auto-detected
- Get a beautiful, auto-laid-out org chart in seconds
- Drag and drop to make changes
- Share a live link that always shows the current chart
- Export to PDF, PNG, or PowerPoint anytime
Your spreadsheet remains the source of truth for data. OrgCanvas handles the visualization. Best of both worlds.
Already have your team in a spreadsheet?
Import it into OrgCanvas and get a beautiful org chart in under 60 seconds. Free for up to 25 people.
Import Your Spreadsheet Free