What an organization chart is and why you'd build one in Excel

An organization chart (or org chart) is a diagram that shows how people fit into a company or group — who reports to whom, what departments exist, and how the structure flows from top to bottom. It answers the question "who do I talk to about X?" by showing the chain of command visually.

You can build one in Excel using shapes and connectors, or by using SmartArt, which is Excel's built-in tool for diagrams. SmartArt is faster if you want something basic and clean. Shapes give you more control if you need to customize colors, fonts, or the exact layout. Most people start with SmartArt and switch to shapes only if they hit its limits.

Excel isn't the only tool for this — dedicated software like Lucidchart or Visio does it more smoothly — but if you already have Excel open and the chart is small, building it there saves a step.

Key Takeaways

  • SmartArt is the fastest route: go to Insert, SmartArt, pick an org chart layout, and type names and titles directly into the boxes.
  • If SmartArt doesn't give you the layout you need, use shapes (rectangles for boxes, connectors for lines) and arrange them manually.
  • For a chart with more than 15 or 20 people, consider whether a text list or a dedicated tool might be clearer than trying to fit everything on one page.
  • Save your chart as a separate sheet within the workbook so it doesn't clutter your data, and lock it so accidental clicks don't move things around.

Building an org chart with SmartArt

Open Excel and go to the Insert tab at the top. Click SmartArt (it's in the Illustrations group). A window opens showing different diagram types. On the left, click Hierarchy. You'll see several org chart layouts — the first one (a box at the top with boxes below it) is the standard choice. Click it and then OK.

Excel drops a basic org chart onto your sheet with placeholder text. Click the top box and type the CEO's or manager's name. Press Tab to move to the title field and type their job title. Click the boxes below and do the same for each person. If you need to add more people, right-click a box, click Add Shape, and choose whether the new person reports to the same manager or is a peer.

Once the structure is in place, you can change colors by clicking the chart, going to the Design tab, and picking a color scheme. You can also resize the whole chart by dragging its corner handle. When you're done, click outside the chart to deselect it.

Building an org chart with shapes if SmartArt doesn't fit your needs

If SmartArt's layouts don't match your structure — for example, if you need a matrix where people report to two managers, or a very wide chart — use shapes instead. Go to Insert, Shapes, and pick Rectangle. Draw a box on your sheet. Type a name and title inside it. Copy and paste the box to create more boxes for each person.

Arrange the boxes where you want them. Then go back to Insert, Shapes, and pick Connector (usually a line with arrows). Draw a line from one box to another to show the reporting relationship. Repeat until all connections are drawn. You can change line thickness and color by right-clicking the line and clicking Format Shape.

This method takes longer but gives you complete control. The downside is that if you move a box, the connectors don't always move with it — you may have to redraw them. For charts with more than 20 people, this becomes tedious.

Deciding whether to use one sheet or multiple sheets

If your organization is small (under 15 people), keep the chart on the same sheet as your data. If it's larger, create a new sheet just for the chart. Right-click the sheet tab at the bottom, click Insert Sheet, name it "Org Chart", and build there. This keeps your data clean and makes the chart easier to find.

If your organization is very large, consider whether a single chart is even readable. A chart with 50 people crammed onto one page becomes a wall of tiny boxes. In that case, you might create separate charts for each department, or use a text-based hierarchy list instead (just indent names under their manager).

Formatting and protecting your chart

Once the chart is built, you may want to lock it so a coworker doesn't accidentally move boxes around. Right-click the chart, click Format Shape, go to the Properties tab, and check "Don't move or size with cells". This anchors it in place.

If you want to make the chart look polished, use consistent fonts and colors. Pick one font for names and one for titles. Use the same box size for everyone at the same level (all managers the same size, all individual contributors the same size). This makes the hierarchy clearer at a glance.

If you plan to share the chart with others, save it as a PDF or take a screenshot and paste it into a presentation or document. That way, people see exactly what you intended, and they can't accidentally edit it.

When to use Excel versus other tools

Excel works well for org charts under 20 people that you'll update once or twice a year. If you need to update it monthly, or if your organization has complex dotted-line reporting (people who report to two managers), dedicated tools like Lucidchart, Visio, or even Google Drawings handle those cases more smoothly.

Excel also gets unwieldy if you want to add photos, email addresses, or department information to each box. Those tools let you embed that data more easily. But if you just need a straightforward visual of who reports to whom, and you already have Excel open, it's a reasonable choice.

Frequently Asked Questions

Can I import employee data from a list instead of typing each name?

Not directly in SmartArt — you have to type or paste names one at a time. If you have a spreadsheet with employee names and managers, you could copy and paste each name, but you'll still need to build the structure manually. For large organizations, this is one reason to use dedicated org chart software instead.

What if someone has two managers or a dotted-line report?

SmartArt doesn't handle this well. With shapes, you can draw two connector lines from one box to two managers above it, but it gets visually confusing. For complex reporting structures, a dedicated tool or a text-based hierarchy list is clearer.

How do I update the chart when someone leaves or gets promoted?

Click the box with that person's name and edit the text. If they're being replaced, just change the name. If they're leaving and nobody replaces them, delete the box (right-click, Delete). If the structure changes, you may need to redraw connectors or add new boxes.

Can I print the org chart so it fits on one page?

Go to File, Print, and under Settings, choose "Fit Sheet on One Page". Excel will shrink the chart to fit. For large charts, this makes text tiny and hard to read — in that case, print it at actual size across multiple pages, or export it as a PDF and zoom in on the digital version instead.

Is there a way to make the chart update automatically when I change employee data in another sheet?

Not with SmartArt or shapes — both require manual updates. If you need live updates, you'd need to use a dedicated org chart tool that connects to your employee database, or write a macro in Excel (which requires programming knowledge).