Excel Org Chart: How to Add a Relationship Line Correctly

Charts & pivot tables · Updated November 20, 2026

To add a relationship in an Excel org chart, first decide whether you mean a reporting link or an additional connection between existing people. For a reporting link in SmartArt, select the relevant box and use SmartArt Design > Add Shape. For a separate dotted-line or cross-functional link, use a connector between individual shapes; if your chart is SmartArt, convert it to shapes first so the connector can attach to the boxes.

What You’ll Need

  • Excel for Microsoft 365 on Windows, and a workbook containing your org chart or the names and reporting structure you want to show.
  • A clear idea of the relationship: a manager-to-report relationship belongs in the hierarchy; a second manager, project lead, mentor, or other non-reporting connection is usually best shown as a separate line.
  • A saved copy of the workbook if you plan to convert SmartArt into individual shapes. Conversion gives you more control but removes the usual SmartArt editing behavior.

The steps below use Excel for Windows. Excel for Mac has similar SmartArt and Shapes tools, though ribbon placement and names can vary slightly. Excel for the web may not offer every conversion or connector-formatting option; if a command is missing, open the workbook in the desktop app.

Step-by-Step

  1. Decide what kind of relationship you are adding. If one person reports to another and that change should affect the org chart hierarchy, add or move a shape in SmartArt. If a person reports to one manager but also works with another team, do not make the second person a subordinate just to draw a line. Use a separate connector for that additional relationship. This distinction keeps the chart truthful: the hierarchy communicates formal reporting, while a differently styled connector can explain a secondary connection.
  2. Open the chart and check whether it is SmartArt. Click a blank area of the chart, then click a box. If the ribbon shows the contextual SmartArt Design and Format tabs, you are working with SmartArt. If you can select and move each person box independently, the chart is probably already made from regular shapes. If you are starting from scratch, choose Insert > SmartArt > Hierarchy > Organization Chart, then enter names in the shapes or in the Text Pane. Save the workbook before making structural changes.
  3. Add a normal reporting relationship with SmartArt. Select the employee box that should have a new direct report. Choose SmartArt Design > Add Shape, then select Add Shape Below to add a subordinate. Enter the new person’s name in the box. To add a peer, select the appropriate box and choose Add Shape After or Add Shape Before, depending on where the new box should appear. To add an assistant role, select the manager and choose Add Shape > Add Assistant, if that option is available for the selected layout. SmartArt draws the hierarchy lines automatically; you do not need to draw a connector for an ordinary reporting link.
  4. Move an existing person into the correct reporting position. In SmartArt, select the person’s box and use SmartArt Design > Promote or Demote to change its level, where appropriate. For more direct control, open the Text Pane and adjust the text indentation: a more deeply indented name is a subordinate of the item above it. Check the result carefully because changing indentation changes the reporting structure, not just the visual position. If the person should remain at the same level, use the regular-shape connector method instead of promoting or demoting them.
  5. Prepare SmartArt for a separate relationship line. A SmartArt graphic behaves as a single graphic, so a connector may not snap to the individual employee boxes inside it. If the line must attach to a box and follow it when moved, select the SmartArt and choose SmartArt Design > Convert > Convert to Shapes. This breaks the graphic into separate editable shapes. The chart will no longer behave as SmartArt, so you will not be able to use the Text Pane or SmartArt hierarchy commands to manage it. If you need to keep an editable SmartArt original, duplicate the worksheet or save another copy before conversion.
  6. Draw the additional relationship with a connector. Select Insert > Shapes, then choose a connector from the Lines group, such as Elbow Connector for a right-angle path or Straight Connector for a direct link. Move the pointer over the first person shape until a connection point appears, then click and drag to a connection point on the second shape. Release when the endpoint snaps to the second shape. A snapped connector is attached to both boxes and adjusts when they are moved. If you only draw a freeform line or a regular line, it may sit near a box without being attached.
  7. Format the line so its meaning is clear. Select the connector and choose Shape Format > Shape Outline to set its color, weight, dash style, or arrowhead. For example, use a thin gray dashed line for a dotted-line reporting or collaboration relationship, while leaving the solid hierarchy lines unchanged. Use an arrow only if direction matters and the arrow’s meaning is clear to readers. Add a small legend near the chart if a dashed or colored line could be mistaken for another kind of reporting relationship. Click outside the chart to review the complete layout.

On a Mac, look for the equivalent SmartArt Design and Shape Format tabs after selecting the graphic or line. The command may be arranged differently, but the same distinction applies: SmartArt commands change the hierarchy, while a connector between separate shapes adds a visual link. In Excel for the web, use the desktop app if you cannot convert the graphic or attach a connector to individual boxes.

Common Mistakes

  • Adding a subordinate when you meant a dotted-line link. Add Shape Below changes the org chart’s reporting structure. It is not a way to draw a second connection to an existing person. Use a connector for a relationship that does not change who reports to whom.
  • Drawing a line that only appears to touch a box. A line with endpoints placed near a shape can drift when you move or resize the chart. Use a connector and wait for the endpoint to snap to a connection point. Zoom in if it is hard to tell whether the endpoint attached.
  • Converting SmartArt without keeping an original. After conversion, individual shapes are easier to connect but SmartArt hierarchy editing is no longer available. Keep an untouched copy if you may need to revise the chart’s reporting structure later.
  • Using the same line style for every relationship. Readers may interpret a second solid line as another reporting path. Make secondary relationships visually distinct and explain the style in a small legend.
  • Forgetting that layout changes can crowd the chart. Adding a box or line may cause overlaps, long connectors, or text wrapping. Review the entire chart at normal viewing size and leave enough space around each box.

Tips

  • Use SmartArt for a straightforward reporting tree that you expect to update often. It is usually faster and more reliable to let the graphic draw its own reporting connectors.
  • Use regular shapes and snapped connectors when the chart needs cross-team links, multiple relationship types, or precise line routing. Create the hierarchy first, then add secondary links so they do not obscure the main structure.
  • Choose elbow connectors when a diagonal line would cross names or other reporting lines. If the route is awkward, reposition the boxes before adjusting the connector; a clearer layout is often better than a complicated path.
  • Keep the visual language consistent. For example, use solid dark lines for formal reporting and dashed colored lines for secondary relationships, then apply the same style everywhere.
  • When converting SmartArt, inspect the result before continuing. Check that boxes, text, and existing hierarchy lines are still present, and move the converted shapes as a group if you need to preserve their arrangement.
  • After editing, click each person box and move it slightly as a test if you are unsure whether a connector is attached. Undo the move with Ctrl+Z on Windows or Command+Z on Mac, and confirm the line stayed connected.

Troubleshooting

  • The line will not attach to a SmartArt box: The SmartArt graphic may be selected as one object rather than as individual shapes. If you need an attached secondary link, save a copy and use SmartArt Design > Convert > Convert to Shapes, then draw the connector between the resulting boxes. Otherwise, keep the chart as SmartArt and use its built-in hierarchy connections.
  • The endpoint does not snap: Make sure you chose a connector from Insert > Shapes > Lines, not a plain line. Drag the endpoint directly onto a visible connection point on the shape and pause until it snaps. If it still does not attach, check that the target is an individual shape and not a grouped graphic.
  • The connector moves but the boxes do not, or the line stays behind: The line may be free-floating or attached at only one end. Select it, inspect both endpoints, and reconnect them to the target shapes. If the chart is grouped, ungrouping may be needed, but first save a copy because ungrouping changes how the chart is managed.
  • SmartArt commands are missing: Click the SmartArt itself, not a worksheet cell or an unrelated shape. The contextual tabs appear only when the graphic is selected. If the object has already been converted to shapes, the SmartArt Design tab will not return; use individual shape editing or reopen your saved original.
  • The chart becomes hard to read after adding the link: Move the boxes to create a clear route, select an elbow connector, and reduce line weight or use a dashed style. If a connector crosses important text, reposition the shapes rather than drawing over the labels. Add a legend when the line’s meaning is not self-evident.

Frequently Asked Questions

Can I add a second manager to a person in Excel SmartArt?
SmartArt org charts are designed to show a hierarchy, not multiple reporting parents for one box. Keep the primary reporting line in SmartArt and use a separate connector for the additional manager or relationship.

How do I add a dotted-line relationship?
Connect the two individual shapes with a snapped connector, select it, and choose Shape Format > Shape Outline > Dashes. If the boxes are in SmartArt, convert a copy to shapes first when the connector must attach to the individual boxes.

Will a connector stay attached if I move a person box?
Yes, if both connector endpoints snapped to connection points on the shapes. A regular line placed over the chart may not move with the boxes, so test the connection by moving a box and then undoing the move.

Can I change an existing reporting line to a dotted line without converting the chart?
SmartArt controls the appearance of its built-in hierarchy lines through the graphic’s design and style options; it does not treat each reporting line like a separate connector. For a separately styled relationship, use a connector between individual shapes, which generally means converting SmartArt first.

Can I do this in Excel for the web?
Some chart and shape editing is available in the web app, but options can differ from desktop Excel. If Convert to Shapes, connector snapping, or line formatting is unavailable, open the workbook in Excel for Microsoft 365 on Windows or Mac.

How can I keep the chart editable after adding a relationship?
Keep an original SmartArt version on a separate worksheet or in a separate workbook, and use a converted copy for custom connections. This preserves the easy-to-edit reporting tree while letting you format the more complex version as needed.

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.