How to Create an Org Chart in Excel Without SmartArt

Creating an organizational chart in Excel is a great way to visualize your company’s structure, but the default SmartArt tool can often feel clunky and restrictive. If you need more control over the layout, design, and details, building your chart manually with shapes is the best way to go. This article will walk you through exactly how to create a clean, professional, and fully custom org chart in Excel without ever touching SmartArt.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Bother Making an Org Chart Manually?

You might be wondering why you’d skip SmartArt, which is designed for this exact task. While SmartArt is quick for simple hierarchies, it has some significant limitations that become frustrating as your chart grows:

• Limited Flexibility: SmartArt templates force you into rigid layouts. Trying to move a single box or adjust spacing can often result in the entire chart reformatting itself in unpredictable ways.
• Formatting Headaches: Customizing individual shapes - like coloring one department’s boxes blue and another’s green - is tedious. The automated styling often overrides your manual changes.
• Clumsy for Complex Structures: SmartArt struggles with non-traditional structures, like roles with dual reporting lines or large teams that branch out horizontally.

Building your chart manually with shapes and connectors gives you 100% control over every element on the page. It’s the difference between using a template and designing from a blank canvas.

Before You Start: Prepare Your Data

A great org chart starts with good data. Before you add a single shape to your spreadsheet, it’s helpful to create a simple table that defines the reporting structure. This gives you a clear source of truth to work from and helps avoid confusion later.

In a new worksheet, create two columns: Employee Name and Reports To. List every person in the organization and who their direct manager is. For the person at the very top (like the CEO), you can leave the "Reports To" field blank.

Your list might look something like this:

Having this list handy makes building the chart straightforward because you can just work your way down the hierarchy logically.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step-by-Step: Building an Org Chart with Shapes and Connectors

Once your data is prepped, it's time to build the visual chart. Follow these steps to create a clean and easy-to-read organizational structure.

Step 1: Insert Your First Shape

The top of every org chart is the head of the company or department. Let’s start there.

1. Go to the Insert tab in the ribbon.
2. Click on Shapes and choose a shape for your boxes. A simple rectangle or a rounded rectangle works best.
3. Your cursor will turn into a crosshair. Click and drag on the spreadsheet to draw your first shape. This box will represent the CEO or team lead (in our example, Sophia Rodriguez).

To add text, simply click on the shape and start typing the person's name and title. You can adjust the font, size, and alignment just like you would with regular text.

Step 2: Add Subordinate Shapes and Align Them

Next, you’ll add shapes for the employees who report directly to the top position. Instead of inserting new shapes one by one, here’s a faster method:

1. Select the shape you just created.
2. Press and hold the Ctrl key, then click and drag the shape to a new position. This creates an identical copy.
3. Repeat this for each direct report. In our example, you'd create two copies for Jamal Ahmed and Chloe Carter.
4. Update the text in the new shapes with the correct names and titles.

Now, arrange these new shapes horizontally below the top shape. To ensure they're perfectly aligned:

• Hold the Shift key and click on each of the direct report shapes to select them all.
• Go to the Shape Format tab (which appears when shapes are selected).
• Find the Align tool. Click it and select Align Top. This will line up all selected shapes along their top edges.
• With the shapes still selected, click Align again and choose Distribute Horizontally. This will create equal spacing between each shape.

This alignment step is what keeps your org chart looking sharp and professional.

Step 3: Connect the Shapes with Elbow Connectors

Lines show the reporting relationships. But don't just use regular lines - use connectors. Connectors are special lines that "stick" to shapes. If you move a shape, the connector moves with it, saving you from having to redraw lines constantly.

1. Go to Insert > Shapes.
2. In the Lines section, choose one of the Elbow Connectors (the one with the right-angle bend).
3. Hover your cursor over the top shape (the manager). You will see small gray dots appear on its border - these are the anchor points.
4. Click on the anchor point at the bottom center of the manager’s shape.
5. Now, move your cursor down to a direct report's shape and click on the anchor point at its top center.

The elbow connector will snap into place, creating a perfect right-angle line between the manager and the subordinate. Repeat this for all other direct reports. If you move any of the shapes, you'll see the connectors stretch and adapt automatically.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 4: Build Out the Next Level of the Hierarchy

Now, you just need to repeat the process. Using our data example:

• Duplicate Jamal's box to create shapes directly under him for David and Emily. Align and distribute them horizontally.
• Use elbow connectors to link David and Emily to Jamal.
• Duplicate Chloe's box to create shapes for Michael and Olivia, and connect them to her.

Continue this copy-align-connect process until every employee from your list is represented in the chart.

Step 5: Stylize and Customize Your Chart

This is where building a manual chart really pays off. You have complete freedom to format everything exactly how you want it.

• Color-Code Departments: Use the Shape Fill option in the Shape Format tab to assign different colors to different teams or management levels. For example, make all Marketing team boxes blue and all Sales team boxes green.
• Adjust Connector Styles: You can change the line color, weight (thickness), and style (e.g., a dashed line for an indirect reporting relationship) using the Shape Outline options.
• Use the Format Painter: Once you've styled one shape perfectly, click on it, go to the Home tab, and double-click the Format Painter icon. Now, you can click on any other shape to instantly apply the same styling (fill, font, borders).

Pro Tip: Link Shape Text Directly to Your Data Table

Want to make your org chart easy to update? Instead of manually typing names into each shape, you can link the shape's text to the cells in your data table. That way, if you update an employee's title in the table, it automatically updates in the visual chart. This is a game-changer.

1. Click on a shape in your org chart (e.g., the one for the CEO). Do not double-click inside to edit the text. Just select the shape itself.
2. Click in the Formula Bar above the spreadsheet grid.
3. Type an equals sign (=).
4. Now, navigate to the worksheet with your data table and click on the cell containing the CEO's name.
5. Press Enter.

The shape's text will now mirror the contents of that cell. If you change the name in the cell, the shape will update instantly. Repeat this for every shape, linking each one to its corresponding name in your data table. You can even join multiple cells to include both name and title.

Let's say the employee's name is in A2 and their title is in B2. You can link a shape's text to both using a formula like this in the formula bar:

=Sheet1!A2 & CHAR(10) & Sheet1!B2

The & CHAR(10) & part adds a line break between the name and title within the shape, keeping it neat.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Final Polish: Group Your Chart Together

After all your hard work, the last thing you want is for someone to accidentally move a single box out of alignment. To protect your chart, you should group all its components into a single object.

1. Navigate to the Home tab.
2. In the far-right corner, find the Find & Select menu.
3. Choose Select Objects. Your cursor will turn into a regular selector arrow.
4. Click and drag a large selection box around your entire org chart, making sure to include every shape and connector line.
5. Go to the Shape Format tab, find the Group tool, and click Group.

Your entire organizational chart is now a single, unified object. You can move it, resize it, and copy-paste it without anything getting misplaced.

Final Thoughts

Creating an organizational chart in Excel without SmartArt does take more initial effort, but the payoff is a completely custom, flexible, and professional diagram that truly fits your needs. By using shapes, connectors, and smart tricks like linking text to data cells, you can build a dynamic chart that’s easy to maintain and looks exactly the way you want.

While mastering your org chart solves one challenge, we know that business leaders and marketers are often pulling data from dozens of different places - Google Analytics, Salesforce, Facebook Ads, Shopify - just to understand performance. At Graphed, we streamline this process. Instead of spending hours in separate platforms and combining CSV files, we let you connect your data sources in one place and build live, auto-updating dashboards simply by describing what you want in plain English. No more manual report-building, just fast, clear answers.