Excel can show your company structure with shapes and lines, but it requires manual setup

Excel does not have a built-in organizational chart tool like Visio or PowerPoint do. You can create one by combining shapes, text boxes, and connector lines, or by using a SmartArt graphic if you are working in Excel 2007 or later on Windows. The manual approach takes longer but gives you full control over layout and formatting. The SmartArt approach is faster but offers fewer customization options and only works on Windows — Mac users will see a static image instead.

Neither method is ideal for large organizations with many levels. If you have more than 20 people to chart, a dedicated tool like Lucidchart, OrgChart, or even PowerPoint will save you hours. But if you need a straightforward chart for a small team and you already have Excel open, both methods work.

Key Takeaways

  • SmartArt graphics are the fastest way to build an organizational chart in Excel on Windows, but they do not work well on Mac and offer limited customization.
  • The manual method using shapes and connectors takes longer but works on all devices and lets you position boxes exactly where you want them.
  • You will need to enter names and titles yourself — Excel does not pull data from a spreadsheet automatically into a chart.
  • For organizations with more than 20 people, a dedicated charting tool will be faster and easier to update later.

Creating a chart with SmartArt (Windows only)

Open Excel and go to the Insert tab at the top. Click SmartArt in the Illustrations group. A window will open showing different diagram types. Look for the category called Hierarchy on the left side. Click on the first option, which shows boxes stacked vertically with lines connecting them. Click OK.

Excel will insert a basic organizational chart with placeholder boxes. Click on the top box and type the CEO or leader's name. Click on the boxes below and add names and titles. To add more boxes, right-click on an existing box and select Add Shape. You can choose to add a shape as a subordinate (reporting to that person), a coworker (at the same level), or an assistant. Use the Design tab that appears to change colors and layout. This method works fastest for teams under 15 people.

Creating a chart manually with shapes and lines

Go to the Insert tab and click Shapes. Choose a rectangle shape — the basic rectangle works fine. Draw a box on your spreadsheet by clicking and dragging. Type a name and title inside. Draw another box below or to the side for the next person. Repeat until you have all the boxes you need.

Now connect them with lines. Go back to Insert and Shapes, then choose a connector line (usually labeled "Connector" with an arrow or straight line). Click on the bottom of the top box and drag to the top of the box below it. Excel will snap the line to the box edges. Repeat for each reporting relationship. You can adjust box positions by clicking and dragging them — the lines will move with them.

To format the boxes, right-click one and select Format Shape. You can change the fill color, border color, and text formatting. To make all boxes match, format one, then copy it and paste it multiple times instead of creating new boxes from scratch. This method takes longer but works on Windows and Mac equally well.

Organizing boxes by level and department

Arrange boxes so that each reporting level is on its own horizontal line. Put the CEO at the top, all direct reports in a row below, and their subordinates in a row below that. This makes the structure clear at a glance. If you have multiple departments, you can use different colors for each one — for example, all finance boxes in blue, all operations boxes in green.

Leave space between boxes so lines do not overlap and the chart stays readable. If your organization is wide (many people reporting to one manager), consider arranging some boxes in two columns to keep the chart from becoming too stretched. You can also use indentation — move some boxes slightly to the right — to show they report to the same person without drawing overlapping lines.

Updating the chart when people change roles

If you use SmartArt, click on a box and edit the text directly. The chart structure stays the same. If you need to add or remove entire levels, right-click a box and use the Add Shape or Delete options. Changes happen when ready.

If you built the chart manually, click on a box to select it, then edit the text. To remove a person, click the box and press Delete. To add a new box, insert a new shape and draw connector lines to it. Manual charts take longer to edit because you have to adjust lines and positions by hand, but the changes are straightforward.

Save your file regularly. If you plan to update the chart often, consider using a dedicated tool instead — Excel is not designed for frequent organizational changes, and you will spend more time repositioning boxes than updating information.

Exporting and sharing your chart

To share the chart as an image, select it by clicking on its border (not inside a box). Right-click and choose Copy. Open an email, document, or presentation and paste it. The chart will appear as a static image that anyone can view, even if they do not have Excel.

To share the Excel file itself, save it and send the file. Anyone with Excel can open it and make changes. If you want to prevent others from editing it, you can protect the sheet by going to the Review tab and clicking Protect Sheet. This lets people view the chart but not change it.

When to use a different tool instead

Excel works for straightforward, stable organizational charts that do not change often. If your organization has more than 30 people, multiple levels, or frequent changes, a dedicated tool will save time. PowerPoint has better SmartArt options and is easier to rearrange. Lucidchart and OrgChart are cloud-based tools designed specifically for organizational charts and can pull data from spreadsheets automatically, so you do not have to type names twice.

Google Drawings, which is free and works in any browser, is another option if you want something simpler than Excel but do not want to pay for a dedicated tool. The choice depends on how often you update the chart and how many people it needs to show.

Frequently Asked Questions

Can I import names from a spreadsheet into an organizational chart automatically?

Excel does not have a feature to pull names from a list and build a chart automatically. You will need to type or copy names into the boxes manually. If you have a spreadsheet with employee names, titles, and manager names, you can copy and paste them one at a time, but there is no automatic linking.

Why does SmartArt not work on my Mac?

SmartArt exists in Excel for Mac, but it has fewer options and does not support all diagram types. Organizational chart SmartArt may appear as a static image instead of an editable diagram. If you are on Mac, the manual method with shapes and connectors is more reliable.

How do I make the chart fit on one printed page?

Click on the chart to select it, then go to Page Layout and adjust the scale under Print Options. You can also resize the chart by dragging its corners. If the chart is too large, reduce the font size in the boxes or remove less critical information like department names.

Can I add photos of people to the boxes?

Yes, but it is tedious in Excel. You can insert a small image inside a shape by right-clicking the shape and selecting Format Shape, then Fill, and choosing Picture or Texture Fill. For a chart with photos, a dedicated tool or PowerPoint will be faster.

What if I need to show dotted lines for dotted-line reporting?

Right-click a connector line and select Format Shape. Under Line, change the line style from solid to dashed or dotted. This is useful for showing advisory relationships or cross-functional reporting that is not a direct chain of command.