The fastest way: use Excel's SmartArt feature

Excel has a built-in tool called SmartArt that creates organizational charts in minutes without manual drawing. You insert a SmartArt graphic, choose the hierarchy layout, and type names and titles directly into the boxes. Excel handles the spacing and alignment automatically.

To start, open a blank Excel workbook and click the Insert tab at the top. Select SmartArt from the ribbon. A dialog box opens showing different graphic types. Click Hierarchy on the left side, then choose Organization Chart (usually the first option). Click OK, and Excel inserts a basic four-box chart into your sheet.

The chart appears with a text pane on the left side. Click each box in the chart or type directly in the text pane to add names, titles, and departments. Press Enter to create new boxes at the same level, or use the indent buttons in the text pane to create subordinate positions. Excel adjusts the layout as you add information.

Key Takeaways

  • SmartArt is the quickest method: insert it from the Insert tab, choose Organization Chart, and type names into the boxes or text pane.
  • You can add, remove, and rearrange positions by editing the text pane on the left side of the SmartArt graphic.
  • For more control over appearance, use shapes and connectors to build a chart manually, though this takes longer.
  • Export your finished chart as an image or PDF to share it outside Excel, or keep it in the workbook for easy updates.

Adding and removing positions in your chart

Once your basic chart is in place, you can expand it to match your actual organization. The text pane on the left shows your structure as an outline. Click any name in the text pane and press Enter to add a position at the same level. Use the indent buttons (the arrows pointing left and right in the SmartArt Tools Design tab) to make a position report to someone above it.

To remove a position, click its name in the text pane and press Delete. The chart updates instantly. If you need to move someone to a different manager, click their name in the text pane, use the indent buttons to change their level, and drag them to the correct spot in the outline. SmartArt reorganizes the visual chart to match.

You can also right-click a box in the chart itself and select Add Assistant or Add Shape to insert positions without using the text pane. This method is slower if you have many people to add, but it works if you prefer clicking directly on the chart.

Changing colors, fonts, and layout

SmartArt charts come with preset color schemes and fonts. To change them, click the chart and go to the SmartArt Design tab. The Change Colors button shows color options. Click any option to apply it to the entire chart instantly. The Layouts section on the left shows different ways to arrange your hierarchy — you can switch between them at any time without losing your data.

To adjust fonts or text size, click the chart, then go to the Home tab and use the standard font controls. You can select individual boxes by clicking them, or select all boxes at once by pressing Ctrl+A while the chart is active. Changing text while all boxes are selected applies the change to every box.

If you want more detailed control — different colors for different departments, for example — right-click a specific box and select Format Shape. This opens a panel where you can change that box's fill color, outline, and text formatting independently. This method is slower but gives you complete control over appearance.

Building a chart manually with shapes and lines

If SmartArt does not give you the layout or appearance you need, you can build a chart from scratch using Excel's drawing tools. Go to the Insert tab and click Shapes. Select a rectangle shape and draw a box for the top position. Type a name and title into the box by double-clicking it.

Draw additional boxes below and to the sides for each position. Then use the Connector tool (also in Shapes) to draw lines connecting each box to its manager. Connectors automatically adjust if you move boxes around, which saves time compared to drawing straight lines. Align boxes neatly by selecting multiple boxes, right-clicking, and choosing Align to line them up horizontally or vertically.

This method takes longer than SmartArt but gives you complete freedom over box placement and appearance. You can color different departments differently, use different shapes for different levels, or create non-standard hierarchies that SmartArt cannot handle. The trade-off is that you must position and format everything yourself.

Organizing data before you build the chart

Before you start creating, gather the information you need: each person's name, title, department, and who they report to. Write this down or keep it in a separate Excel sheet. Having this information organized prevents mistakes and makes the building process much faster.

If your organization is large, start with the top level and work downward one level at a time. This keeps the chart readable and prevents you from adding people in the wrong places. If you are updating an existing chart, compare your new list to the old one to catch changes in reporting structure before you build.

Saving and sharing your chart

Your organizational chart lives in the Excel workbook just like any other content. Save the file normally using Ctrl+S or File > Save. If you need to share the chart with people who do not have Excel, right-click the chart and select Save as Picture. Choose PNG or JPEG format. This creates an image file you can email or post online.

You can also copy the chart and paste it into Word, PowerPoint, or other programs. Click the chart, press Ctrl+C to copy, open the other program, and press Ctrl+V to paste. The chart appears as an image in the new program, though you cannot edit it there — you must edit it in Excel and copy it again.

If you need to update the chart regularly, keep it in Excel and save a new version each time you make changes. You can add a date to the filename (like "Org Chart 2024-01") to track which version is current. Share the Excel file itself if others need to make edits, or share an image if you just want them to view it.

Frequently Asked Questions

Can I import employee data from another file into my chart?

SmartArt does not read data from other sheets or files automatically. You must type or copy-paste names and titles into the text pane manually. If you have a large employee list in another Excel sheet, copy the names and titles, then paste them into the SmartArt text pane. You will still need to arrange them in the correct reporting structure by hand.

What if my organization has multiple people reporting to the same manager?

SmartArt handles this naturally. In the text pane, list all subordinates under their manager at the same indent level. The chart automatically arranges them in a row or column below the manager. If the layout looks crowded, try a different SmartArt layout from the Design tab — some layouts work better for wide teams.

Can I print my organizational chart?

Yes. Click the chart to select it, then go to File > Print. Excel prints the chart at whatever size it currently is on the sheet. If the chart is too large for one page, adjust its size by dragging the corners, or go to Page Layout and change the print scaling to fit it on fewer pages. You can also export it as a PDF using File > Export.

How do I show dotted or dashed lines for indirect reporting relationships?

SmartArt does not support different line styles. If you need dotted lines for dotted-line reporting, build the chart manually using shapes and connectors. Right-click each connector line, select Format Shape, and change the line style to dashed or dotted in the Line panel. This takes more time but gives you the flexibility you need.

What is the maximum number of people I can show in one chart?

There is no hard limit, but charts with more than 50 or 60 people become difficult to read on a single screen or page. For large organizations, consider breaking the chart into departments — create one master chart showing department heads, then separate charts for each department. This keeps each chart readable and makes updates easier.