Beispiel-CSV
| Source | Target | GWh |
|---|---|---|
| Norway | Sweden | 842 |
| Sweden | Norway | 613 |
| Sweden | Finland | 410 |
| Finland | Sweden | 295 |
| Sweden | Denmark | 378 |
| Denmark | Sweden | 201 |
| Denmark | Germany | 530 |
| Germany | Denmark | 344 |
| Norway | Denmark | 156 |
| Denmark | Norway | 98 |
How to Create a Chord Diagram
A step by step walkthrough for turning a source, target and value spreadsheet into a published chord diagram in PlotSet, from the three-column matrix to the ordering that keeps the ribbons readable.
Etwa 9 MinutenA matrix of flows between entities is the starting point, and how to create a chord diagram in PlotSet from it, not the sample data that ships with the template, is what this guide covers. You will end up with entities arranged around a circle, ribbons sized to the amounts moving between them, and either a live embed with hover highlighting or a PNG, SVG or PDF you can drop into a deck. The click path is the same one a real PlotSet project follows from upload to publish.
If your data is already three columns, source, target and value, this takes about eight or nine minutes. Add another five if you are pulling the matrix out of a wider report or a pivot table, since that reshaping is the part people usually get stuck on before they ever open PlotSet.
Die Daten, die Sie brauchen
Three columns, one row per directed pair: source entity, target entity, and the amount flowing from source to target. Include a separate row for the reverse direction when the flows are not equal.
This is long format, not a wide matrix. If your source data looks like a grid with countries down the side and across the top, you need to unpivot it into source, target, value rows before uploading. A spreadsheet's UNPIVOT or a quick PIVOT-to-long formula handles this faster than retyping by hand.
A pair with flow in both directions needs two rows, one each way. Uploading only "Norway,Sweden,842" with nothing for the return trip renders as a one-way ribbon, which is fine if that is genuinely the case, but wrong if you just forgot the other row.
Keep the value column as plain numbers, no thousand separators and no currency symbols. A cell like "1,234" or "$1,234" sometimes imports as text rather than a number, and a text value cannot size a ribbon.
Rows where source and target are the same entity (a self-loop) do not draw a ribbon in a chord layout. Drop them before uploading rather than leaving them in as dead rows.
Die Schritte
Der genaue Klickpfad in PlotSet, von einer leeren Vorlage bis zum fertigen Diagramm.
- 01
Open the chord diagram template
From the PlotSet dashboard, start a new project and choose the Chord Diagram template. It loads with sample data already bound, which is the fastest way to see the three-column shape, source, target, value, before you bring in your own file.
Jede Anleitung beginnt hier. Wählen Sie erst die Kategorie, dann die Vorlage. Das Raster ist für jeden Diagrammtyp dasselbe. - 02
Shape your sheet into source, target and value
One row per directed pair. If a report gave you a wide matrix instead, with entities down the side and across the top, unpivot it into these three columns first. This is usually the slowest part of the whole process and the one worth doing carefully.
- 03
Import the file or connect a sheet
Import a CSV or .xlsx file from the data panel, paste rows directly, or connect a Google Sheet if you want the diagram to pick up new numbers later without a re-upload. PlotSet reads your first row as headers automatically.
Die Datenansicht, hier in einem Balkendiagramm-Projekt. Laden Sie über "Upload CSV File" eine CSV-Datei hoch, holen Sie die Zahlen mit "Magic Import" aus einem Bild oder verbinden Sie ein Google Sheet. Der Bereich sieht bei jedem Diagrammtyp gleich aus. - 04
Map the source, target and value columns
Confirm which column feeds each end of the ribbon and which one sets its width. PlotSet usually guesses correctly when your headers are named clearly, but check it manually if your sheet carries extra columns it might have picked up by mistake.
Die Zuordnungen legen fest, welche Spalte zur Beschriftung wird, welche die Werte liefert und welche die Farbe steuert. "Auto Binding" errät sie anhand Ihrer Spaltenüberschriften. Prüfen Sie das Ergebnis, statt sich darauf zu verlassen. - 05
Order the entities around the circle
Drag entities in the editor so ones that trade heavily with each other sit next to each other, rather than leaving them in upload or alphabetical order. This single change does more to cut down crossing ribbons than any styling option.
- 06
Aggregate anything too small to matter
If a handful of entities carry almost no volume, group them into a single "Other" row in your source sheet before re-uploading. Thin ribbons from minor entities add visual noise without adding information, and removing them is usually what turns a knot into a readable diagram.
- 07
Style the ribbons and turn on hover highlighting
Ribbon colour is inherited from the source arc by default, which is the setting to keep so a reader can trace where a ribbon started. Turn on hover highlighting so pointing at one entity dims every ribbon except its own; this is what actually makes a dense chord diagram usable rather than decorative.
Der Tab "Preview" für ein Diagramm vom Typ "Chord Diagram". Alle Gestaltungsoptionen stecken im umrandeten Bereich: Aussehen, Kopfzeile, Fußzeile und die Optionen, die es speziell für diesen Diagrammtyp gibt, jeweils in einem eigenen Tab. - 08
Publish the diagram, embed it, or export it
Publish for a live, interactive diagram with the hover highlighting intact and a shareable link, grab the embed code for a page on your own site, or export a static PNG, SVG or PDF if you need an image for a report.
Starten Sie mit der Chord Diagram-Vorlage samt bereits geladenen Beispieldaten und ersetzen Sie diese durch Ihre eigenen.
Vorlage öffnenVeröffentlichen, einbetten oder exportieren
Der letzte Abschnitt ist bei jedem Diagrammtyp gleich: "Share" macht aus dem Diagramm einen öffentlichen Live-Link und einen Einbettungscode, "Export" schreibt es als statische Datei heraus.
"Share": öffentlicher Link und Einbettungscode
Aktivieren Sie den Einbettungscode und den öffentlichen Link, um das Diagramm zu veröffentlichen. Den Link können Sie bedenkenlos an alle weitergeben, und der Einbettungscode fügt sich als iframe in jede Seite ein. Die Tooltips beim Überfahren mit der Maus und die volle Interaktivität bleiben erhalten. Wenn Sie das Diagramm später bearbeiten, überträgt "Recreate" die Änderungen auf Link und Einbettung.
"Export": SVG, PNG oder JPG
"Export" schreibt eine statische Kopie in der Größe heraus, die Sie brauchen. SVG bleibt in jeder Skalierung scharf und lässt sich weiterhin in einem Design-Tool bearbeiten; PNG und JPG sind die sichere Wahl für Folien und Dokumente. Der Skalierungsfaktor sorgt dafür, dass das Bild auf einem Retina-Display gestochen scharf wirkt.
Styling-Tipps für Chord Diagram
Cluster before you sort
Ordering by total flow puts the busiest entities together automatically, but clustering by relationship, region, category, whatever groups things that actually trade with each other, usually cuts crossings further. Try both and keep whichever produces fewer ribbons crossing the centre.
Leave the gap between arcs alone unless it's cramped
The default spacing keeps each entity's total flow readable as an arc length. Shrinking the gap to fit more entities in usually backfires: past a point, the arcs blur into a single ring and the totals stop being legible at all.
Match your CSV's direction convention to how you read it
Decide once whether a row means "source sent to target" and stick to it across every row. Mixing conventions partway through a sheet, so one row means "exports" and the next means "imports", produces a diagram that is internally inconsistent even though every number in it is correct.
Name the aggregated bucket honestly
If you grouped a long tail of small entities into "Other", say so in the title or a caption. A reader who assumes "Other" is a real single entity will misread its arc as one busy participant rather than twelve quiet ones.
Häufige Fehler bei Chord Diagram
Every ribbon looks one-directional even though the real flows go both ways
This almost always means the sheet only had one row per pair. Check your source data for the return-direction row, Target back to Source, and add it if the underlying flow is genuinely asymmetric or reciprocal.
All the ribbons render the same width regardless of the numbers
The value column probably imported as text rather than a number, usually because a cell had a thousand separator, a currency symbol, or a trailing space. Strip formatting from the value column in your spreadsheet and re-upload.
The diagram is a solid knot of crossing ribbons
This is what happens past roughly fifteen entities, or with fewer entities left in upload order instead of clustered. Aggregate the smallest entities into an "Other" group and reorder the remaining ones so related entities sit adjacent on the circle.
Mehr über Chord Diagram erfahren
Nicht sicher, ob Chord Diagram die richtige Wahl ist? Erfahren Sie, was es ist, wann Sie es verwenden sollten und wann nicht.
Chord Diagram: häufige Fragen
Three columns in long format: source, target and value, with one row per directed pair. If your data currently sits in a wide matrix with entities down the side and across the top, unpivot it into these three columns before uploading.
Jetzt Chord Diagram erstellen
Kostenlos starten mit über 300 Vorlagen. Keine Kreditkarte erforderlich.