How to Make a Relationship Chart: By Hand, in Excel, or with an Online Tool

When you decide to make a relationship chart, the first question is what to use: pen and paper, Excel or PowerPoint, or a dedicated online tool. Each has strengths, and the wrong choice can mean two hours to make a chart and a nightmare to change it. This guide compares the three and gives a recommendation for each use.

Comparison

1. By hand: fastest for ideas, weakest for updates

Pen and paper are still hard to beat while you are thinking: jotting down a TV drama’s cast as it airs, or sketching character relationships while you plot. The weakness is updating. Charts grow as stories grow, and on paper adding one person often means redrawing the whole thing.

• Good for: first ideas, and one-off simple charts.
• Not good for: casts that keep growing, charts you update often, or clean images to share online.

2. Excel or PowerPoint: practical at work, but slow

If the chart goes into a company document, Office may be the realistic choice. The steps:

1. Insert rounded rectangles, one per person.
2. Type each name and color the shapes by group.
3. Connect people with connectors (elbow or straight).
4. Add a separate text box next to each line for the relationship label. Connectors cannot hold a label directly.
5. Align the shapes. Holding Alt while dragging lets you nudge shapes without snapping to the grid.

Step 4 is where it slows down: when you move a person, the labels stay behind. Even a chart with 10 people and 15 relationships can take close to an hour once labels are adjusted. Note that SmartArt is built for hierarchies, so it cannot show sideways relationships like rivalry or romance; shapes and connectors are more flexible.

3. Online tool: best if you will update or share

A dedicated tool starts with people cards and labeled lines as building blocks. Reconnecting lines, moving labels and aligning are handled for you, so you spend time on the chart itself. Relationship Chart Maker, for example:

• is free to start, with no sign-up, in your browser;
• keeps lines and labels attached when you move people;
• lets you change line color, dashed or dotted style, and arrow direction;
• works on a phone;
• exports a PNG image to share;
• saves your chart in your browser, and offers an AI generator that drafts a chart from pasted text.

Limits: it needs a browser, and it is not ideal when you must deliver a file in a company-specified format.

Which should you pick?

• Notes while watching a drama: by hand, then tidy up in a tool.
• A long-running story with a growing cast: an online tool.
• A slide in a company project document: Excel/PowerPoint, or an image exported from a tool and pasted in.
• Sharing a chart on social media: an online tool.
• Only a phone available: an online tool.

FAQ

How do I make a relationship chart in Excel?

Insert shapes as people, connect them with connectors, and add labels with text boxes. It works, but adjusting labels takes time as the chart grows.

Can I make a relationship chart on my phone?

Yes. Open an online tool in your phone’s browser; no app or sign-up is needed.