How to Add a Line in an Excel Org Chart

Charts & pivot tables · Updated November 20, 2026

To add a reporting line in an Excel org chart, select the employee’s box and use SmartArt Design > Add Shape to add a subordinate, colleague, or assistant; Excel draws the hierarchy line automatically. To connect two existing boxes in a custom way, convert the SmartArt to shapes and add a connector from Insert > Shapes. Make a copy before converting, because that change is not easily reversed.

What You’ll Need

  • An Excel workbook with an existing org chart, or a plan for the boxes you want to connect.
  • Excel for Microsoft 365 on Windows for the steps below. Excel for Mac has similar SmartArt and Shapes tools, although ribbon labels and placement can vary. Excel for the web has more limited options for editing and converting SmartArt; use the desktop app for the conversion method.
  • A saved copy of the workbook if you plan to convert SmartArt into separate shapes.

Step-by-Step

  1. Decide what kind of line you need. A normal org-chart line shows a reporting relationship in the hierarchy. Add or move a SmartArt position to create this kind of connection, and Excel will update the line for you. A custom line connects two boxes that are already present, shows a dotted-line relationship, or follows a route outside the standard hierarchy. That usually calls for a connector shape. Choosing the right approach first helps keep the chart easy to maintain.
  2. Save a working copy. If you might need a custom connection, use File > Save As to save a copy before proceeding. Converting SmartArt to shapes gives you more control over individual boxes and lines, but the result is no longer an editable SmartArt org chart. You can still move and format its shapes, but you cannot use SmartArt’s hierarchy commands on the converted graphic.
  3. Add a standard reporting line through SmartArt. Click the org chart, then click the box for the person whose position will be added. Open the SmartArt Design tab and choose Add Shape. Select the placement that matches the structure, such as Add Shape Below for a subordinate or Add Assistant for an assistant role. The exact choices can depend on the selected box and chart layout. Type the new person’s name in the added box. SmartArt creates the connecting line as part of the hierarchy.
  4. Check the position before adding more boxes. If the new box appears at the wrong level, undo the addition with Ctrl+Z on Windows, select the correct manager’s box, and add the position again. You can also use SmartArt Design > Promote or Demote to change a selected position’s level when those commands are available for the selected chart. Review the chart from top to bottom so the line represents the actual reporting relationship, not just a visual alignment.
  5. Convert SmartArt if you need to connect existing boxes freely. Select the SmartArt graphic, open SmartArt Design, and look for the Convert group. Choose Convert and then Convert to Shapes. In some ribbon layouts, the command may appear directly as Convert to Shapes. Confirm the conversion if Excel prompts you. The boxes and connectors become separate drawing objects, so the original SmartArt editing controls are no longer available. If you do not see this command, use desktop Excel rather than relying on the web version.
  6. Choose a connector shape. Click an empty area of the worksheet to deselect the converted graphic. Go to Insert > Shapes. In the Lines section, choose a connector such as Elbow Connector for a right-angled route or Straight Connector for a direct route. A connector is preferable to a plain line because its ends can attach to shapes and follow them when they move. The exact connector names can vary slightly between Excel versions.
  7. Attach the line to both boxes. Move the pointer over the edge of the first box until Excel displays connection points, then click and drag from a point toward the second box. Release when the pointer reaches a connection point on the second box. The connector should attach at both ends. If it is difficult to reach a point, zoom in or temporarily move nearby boxes apart. Avoid drawing the line so it only appears to touch a box; an unattached line will not follow that box when it is moved.
  8. Format the connector if it needs to stand out. Select the connector and open the contextual Shape Format tab. Use Shape Outline to set its color, weight, or dash pattern. A dashed or dotted outline can distinguish a secondary relationship from the solid reporting hierarchy. Keep the meaning clear: if your organization uses a particular line style, label or explain it rather than assuming every reader will interpret it the same way.
  9. Check the result at normal viewing size. Move one connected box slightly and confirm the connector remains attached at both ends; then undo the move if you do not want to change the layout. Check that the line does not cross names, other boxes, or unrelated connectors. Save the workbook after confirming that the connection communicates the intended relationship.

Common Mistakes

Drawing a plain line instead of a connector: A basic line can look correct at first, but it may stay where it was drawn when a box moves. Choose a connector from Insert > Shapes and attach both ends to connection points whenever the line should track the boxes.

Using a custom line for a normal hierarchy: Adding a drawn line between two SmartArt boxes can make the chart harder to update. For a direct manager-subordinate relationship, add the position through SmartArt Design > Add Shape instead. SmartArt then manages the hierarchy and its connecting lines together.

Converting before saving a copy: Conversion removes the SmartArt structure. If you later need to add a manager, change an assistant relationship, or reorganize the chart, editing separate shapes can take longer. Keep the original SmartArt in a duplicate sheet or workbook when future structural changes are likely.

Connecting to the wrong point: A connector can attach to a corner or side that makes the relationship look ambiguous. Use consistent attachment points and routes across similar relationships. If the connector crosses other chart elements, move the boxes or select another connector style rather than leaving a confusing route.

Relying on color alone: A colored line may be hard to distinguish when printed in grayscale or viewed by someone with limited color vision. Combine color with a dash style, a clear label, or a note explaining what the relationship means.

Tips

Keep the main hierarchy consistent: managers above their direct reports, assistants beside the relevant manager when the layout supports it, and similar levels aligned. A standard SmartArt layout is usually easier to read and maintain than a chart built from many manually placed lines.

For a custom connector, make enough space between boxes before drawing. An elbow connector is useful when a line needs to travel horizontally and vertically without cutting through a box. A straight connector works best when the boxes are close and aligned. If a connector takes an awkward path, try moving one box or reconnecting the ends at different points.

Use the same line weight and dash convention throughout the chart. For example, you might reserve a dashed connector for a nonstandard or secondary reporting relationship and use solid connectors for the formal hierarchy. Add a small key or explanatory note if the chart will be shared with people who do not already know the convention.

When working on Excel for Mac, look for the SmartArt Design and Shape Format tabs after selecting the relevant object. The tools are broadly similar, but ribbon arrangement and some command labels can differ from Windows. Excel for the web can handle many ordinary workbook edits, but if it does not offer the required SmartArt conversion or connector controls, open the file in the desktop app.

Troubleshooting

The line does not appear after adding a person: Confirm that you selected a box inside the SmartArt graphic, rather than a separate shape or the worksheet. Then use SmartArt Design > Add Shape and choose the correct relationship. If you used a custom layout or converted the chart earlier, Excel may no longer create hierarchy lines automatically.

I cannot see the SmartArt Design tab: Click the SmartArt graphic once. Contextual tabs appear only when the relevant object is selected. If the chart consists of separate boxes rather than one SmartArt object, select a box to see Shape Format, or use the connector method for the individual shapes.

The connector will not snap to a box: Make sure the objects are shapes, not still a single SmartArt graphic. If you need to connect individual SmartArt positions with a custom line, convert the graphic to shapes first. Then start or end the connector at a visible connection point on the box. Zooming in can make the points easier to target.

The line moves independently from a box: One or both ends may not be attached. Select the line and inspect its endpoints; if necessary, delete it and draw a connector again, dragging each end to a box connection point. A line that merely overlaps the box edge is not necessarily connected.

The connector is hidden behind a box or another object: Select it and use Shape Format > Bring Forward or Send Backward as appropriate, if those commands are available in the ribbon. You can also adjust the box spacing so the route is visible. Be careful not to place the connector across text.

I converted the chart and need SmartArt controls back: The converted shapes do not retain the full SmartArt hierarchy. Use Ctrl+Z immediately if the conversion is the latest action. Otherwise, reopen the saved original or rebuild the chart as SmartArt. This is why keeping a separate copy is useful.

Frequently Asked Questions

Can I add a line between two existing SmartArt boxes without converting?
SmartArt manages hierarchy connectors automatically, and it does not offer the same free-form connection control as separate shapes. For a custom connection between existing positions, convert a saved copy to shapes and add a connector.

How do I add a subordinate and get the line automatically?
Select the manager’s box, choose SmartArt Design > Add Shape > Add Shape Below, and enter the subordinate’s name. Excel places the box in the hierarchy and supplies the connector.

How do I make a reporting line dotted?
For a custom connection, select the connector, open Shape Format > Shape Outline, and choose a dash or dot style. If the line is part of editable SmartArt, formatting individual connectors may be limited; converting a copy to shapes gives you more control.

Will the line stay connected if I move a box?
It should if you used a connector and attached both endpoints to the boxes’ connection points. A plain line, or a connector whose end only sits beside a box, may not follow the shape.

Can I do this in Excel for the web?
You can edit many workbook objects in the browser, but SmartArt and connector options may be more limited than in desktop Excel. If you cannot find the needed conversion or attachment controls, open the workbook in Excel for Microsoft 365 on Windows or Excel for Mac.

Can I change the org chart after converting it to shapes?
Yes, you can move, resize, and format the individual shapes, and draw or adjust connectors. However, SmartArt commands for changing hierarchy levels are no longer available for that converted graphic. Keep the original SmartArt if you expect to restructure the organization later.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.