The fastest way to make an org chart in Excel

Excel has two built-in tools for org charts: SmartArt (the quickest method) and shapes with connectors (more customizable). SmartArt creates a basic hierarchy in under a minute — you type names and titles, and Excel arranges them automatically. If you need more control over layout, colors, or positioning, shapes give you that flexibility at the cost of more manual work.

Both methods start the same way: open Excel, go to the Insert tab, and choose either SmartArt or Shapes. The choice depends on whether you want speed or precision. Most people should start with SmartArt unless they have a specific layout in mind that SmartArt's templates don't support.

Key Takeaways

  • SmartArt is the fastest route — select a hierarchy layout, type names and titles, and Excel positions everything automatically.
  • Shapes and connectors give you full control over positioning and appearance but require you to draw and align each box manually.
  • SmartArt designs can be changed after you create them, so you can experiment with different layouts without starting over.
  • Both methods let you add colors, fonts, and borders to match your company branding or personal preference.

Creating an org chart with SmartArt (the quick method)

Open Excel and click the Insert tab at the top. In the ribbon, find the SmartArt button — it looks like a small diagram. Click it to open the SmartArt gallery.

In the gallery, look for the category called Hierarchy on the left side. Click it. You'll see several layout options. The first one, called Organization Chart, is the standard choice. Select it and click OK.

Excel inserts a basic four-box org chart into your spreadsheet. The top box is the CEO or leader. Below it are three subordinate positions. You'll see a text pane on the left side with placeholder text. Click on each line in that pane and type the actual name and title. For example, replace "[Text]" with "Sarah Johnson — Sales Director". As you type, the boxes update automatically.

To add more boxes, click in the text pane where you want the new position to go, then press Enter to create a new line. Indent the line (press Tab) to make it a subordinate, or outdent it (press Shift+Tab) to make it a peer. Excel repositions all the boxes as you work.

Customizing SmartArt colors and fonts

Once your chart is built, click on it to select it. The SmartArt Tools tabs appear at the top — you'll see Design and Format.

Click the Design tab. On the left, you'll see color schemes. Click any scheme to apply it instantly to the entire chart. On the right, you'll see layout options — these let you switch between different hierarchy shapes without losing your text.

To change fonts or individual box colors, click the Format tab. Click on a specific box in the chart, then use the formatting options to change its color, border, or text style. You can also right-click a box and choose Format Shape for more detailed control.

Building an org chart with shapes and connectors (the manual method)

If SmartArt's layouts don't fit your structure, use shapes instead. Click the Insert tab, then find Shapes in the ribbon. Look for the Rectangle shape and click it.

Your cursor becomes a crosshair. Click and drag to draw a rectangle for the top position (usually the CEO or department head). Type the name and title directly into the box. Repeat this process to create boxes for each person in your org chart, positioning them roughly where they should go.

Once all boxes are drawn, you need to connect them with lines. Click Insert again, then Shapes, and look for Connectors near the bottom of the menu. Choose the Straight Connector or Elbow Connector (elbow connectors look more professional). Click and drag from one box to another to draw a line showing the reporting relationship.

Align your boxes by selecting multiple boxes at once (hold Shift and click each one), then right-click and choose Align. This straightens them into neat rows. Adjust spacing by dragging boxes or connectors until the chart looks balanced.

Formatting shapes to match your style

Right-click any box and choose Format Shape. You can change the fill color, border color, border thickness, and transparency. Apply the same colors to boxes at the same level (all managers one color, all directors another) to make the hierarchy visually clear.

To format text inside a box, double-click the box to enter edit mode, select the text, then use the Home tab to change font, size, and color. Make sure text is large enough to read — 11 or 12 point is standard.

For connectors, right-click the line and choose Format Connector. You can change the line color, thickness, and style (solid, dashed, dotted). Thicker lines make the chart easier to follow.

Saving and sharing your org chart

Save your file normally by pressing Ctrl+S (or Cmd+S on Mac). If you want to share the chart as an image, right-click the entire chart and choose Copy. Open a new file or document, right-click, and choose Paste Special. Select Picture to paste it as an image that can't be edited but looks clean in presentations or emails.

If you're sharing the Excel file itself, make sure all names and titles are spelled correctly and current. Org charts go out of date quickly, so add a note at the bottom with the date you created it.

Common mistakes to avoid

Don't try to cram too many levels into one chart. If your organization has more than five or six levels, break it into separate charts by department. A chart that's too tall or wide becomes hard to read and print.

Don't use tiny fonts to fit everything. If you can't read it at normal zoom, neither can anyone else. Simplify the chart instead — remove middle managers or show only the top three levels.

If you're using shapes, don't forget to align boxes before you finish. Crooked rows look unprofessional and confuse readers about who reports to whom. Use the Align tools to snap everything into place.

Frequently Asked Questions

Can I add photos to boxes in an org chart?

With SmartArt, you can't add photos directly to the boxes. With shapes, you can insert a picture and position it next to or inside a box, but it requires manual work. For a professional photo org chart, consider using a dedicated tool like Lucidchart or Visio instead.

What if I need to add or remove positions after I create the chart?

With SmartArt, click the text pane on the left, add or delete lines, and the chart updates automatically. With shapes, you'll need to manually draw new boxes, delete old ones, and redraw connectors. SmartArt is much faster for changes.

How do I print an org chart so it fits on one page?

Click the chart, then go to File > Print. Under Settings, look for scaling options. Choose "Fit to one page" or adjust the zoom percentage. If the chart is too large, simplify it by removing lower levels or splitting it into multiple charts.

Can I export the org chart as a PDF?

Yes. Right-click the chart and copy it, then paste it into a PDF creator like Microsoft Word or Google Docs, and save as PDF. Or go to File > Export in Excel and choose PDF format, though this exports the entire sheet.

Which method is better for a large organization with many departments?

SmartArt works best for organizations with one clear hierarchy. For large, complex structures with multiple departments, create separate SmartArt charts for each department, or use shapes to build a custom layout that shows dotted lines for cross-functional reporting.