How to Create Organization Chart in Excel - Practical Guide

Learn to create professional organization charts in Excel to visualize hierarchical structures and reporting relationships. You'll discover how to use SmartArt graphics and manual shapes to build clear, customizable org charts that communicate team structure effectively.

Why This Matters

Organization charts are essential for communicating company structure, clarifying roles, and onboarding new employees. They improve team understanding and professional presentations.

Prerequisites

•Basic Excel knowledge and familiarity with the ribbon interface
•Understanding of your organization's hierarchical structure

Step-by-Step Instructions

Open Insert menu and select SmartArt

Navigate to Insert > SmartArt Graphics on the ribbon. A dialog box will open displaying various diagram options.

Choose organization chart layout

In the SmartArt dialog, select Hierarchy category on the left, then click Organization Chart template and click OK.

Add organization data

A text pane appears on the left side; type position titles and names in the placeholder fields, starting with the top leader position and working downward.

Adjust structure and add reporting lines

Use the text pane to add or remove positions by clicking [Add Shape] dropdown; select Add Shape Below to create subordinates or Add Shape Assistant for supporting roles.

Format and customize appearance

With the chart selected, go to SmartArt Design tab to change colors (Change Colors) and styles (SmartArt Styles), or right-click individual shapes to format text and colors.

Alternative Methods

Use Shapes and connectors manually

Insert > Shapes to add rectangles for each position, then Insert > Connector to draw lines between them. This offers maximum customization but requires more time.

Import data from external source

Use Excel plugins or third-party tools like Lucidchart or Visio integration to auto-generate org charts from employee spreadsheets or HR databases.

Tips & Tricks

✓Keep position titles concise and include employee names for clarity; avoid overly long text that makes boxes difficult to read.
✓Use consistent formatting by applying the same SmartArt style and color scheme throughout the entire organization chart.
✓Save a backup copy before making large structural changes to preserve the original layout.
✓Test-print or preview your chart in different zoom levels to ensure all text and shapes are legible.

Pro Tips

★Right-click the SmartArt border and select 'Size & Properties' to set exact dimensions, ensuring consistent chart sizing across multiple presentations.
★Use the SmartArt Design tab to promote or demote positions using the layout buttons, instantly reorganizing reporting relationships without manual redrawing.
★Export your completed org chart as a high-resolution image (right-click > Save as Picture) for embedding in presentations, websites, or documents without losing quality.

Troubleshooting

Text pane is not appearing when SmartArt is selected.

Click the SmartArt once to select it, then go to SmartArt Design > Edit Data or right-click and select Edit Data to open the text pane.

Chart appears distorted or shapes are overlapping.

Select the SmartArt and manually resize it by dragging the corner handles, or use SmartArt Design > Change Layout to apply a different structure that better fits your data.

Cannot add more positions or structure seems limited.

Ensure you are clicking the correct [Add Shape] option in the text pane; use 'Add Shape Below' for subordinates and 'Add Shape Assistant' for peer-level support roles.

Frequently Asked Questions

Can I convert my existing employee spreadsheet into an organization chart?

Not directly in Excel, but you can manually copy employee data into the SmartArt text pane. Alternatively, use third-party plugins or tools like Lucidchart or Visio that can import CSV/Excel data and auto-generate org charts.

How do I make the organization chart printable on multiple pages?

Excel SmartArt prints on a single page by default. To print across multiple pages, increase the chart size, adjust page setup (File > Print), or export as a high-resolution image and print that instead.

Can I add photos or custom images to the org chart boxes?

SmartArt has limited image support. For maximum customization with photos, consider using manual shapes and connectors, or export your org chart to Visio or Lucidchart where you can embed employee photos.

How do I update an organization chart when employees change roles?

Simply select the SmartArt, open the text pane (SmartArt Design > Edit Data), and update the names and titles directly. Changes apply instantly to the visual diagram.