Beispiel-CSV
| Phone | Battery | Camera | Performance | Display | Value |
|---|---|---|---|---|---|
| iPhone 15 | 7 | 9 | 9 | 8 | 6 |
| Galaxy S24 | 8 | 8 | 9 | 9 | 7 |
| Pixel 8 | 7 | 9 | 8 | 8 | 8 |
How to Create a Radar Chart
A step by step walkthrough for turning a spreadsheet of scores into a published radar chart in PlotSet, from shaping the sheet to exporting or embedding the finished polygon.
Etwa 9 MinutenBy the end of this guide you will know how to create a radar chart from your own spreadsheet in PlotSet: items plotted as polygons across five or so shared measures, coloured on purpose, and either embedded on a page or exported as an image for a deck. Same click path a real chart takes, just with your items and your scores instead of a demo dataset.
If your scores are already on the same scale, plan on about nine minutes. Add another five if you are still converting raw numbers, dollars, percentages, ratings out of five, into one shared range, since that conversion is the step a radar chart cannot skip and most spreadsheets do not do for you.
Die Daten, die Sie brauchen
Wide format: one row per item, one column per measure. First column holds the item name, every column after it becomes one spoke, and all of those columns need to share the same scale before you upload.
Keep every measure column on the same scale, a score out of ten works well, before you upload. A stray column in dollars or raw units next to scores out of ten will still plot, it just will not mean anything.
The order of the columns becomes the order of the spokes going clockwise from the top. Decide that order in the spreadsheet, since it is easier to fix there than after the chart is styled.
Three items is a practical ceiling for one chart. A fourth overlapping polygon usually makes the chart harder to read, not more informative, so split into small multiples instead.
A blank cell renders as zero on that spoke rather than being skipped, which can make a strong item look weak on one axis. Fill it in or drop the row.
Die Schritte
Der genaue Klickpfad in PlotSet, von einer leeren Vorlage bis zum fertigen Diagramm.
- 01
Open the radar chart template
From the PlotSet dashboard, start a new project and choose the Radar Chart template. It loads with sample data already bound to the spokes, so you can see the wide column layout PlotSet expects 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: one item per row, one measure per column
Put the item name in the first column and one measure in each column after it, with a short header for each. If your source is a long-format export with an item, measure, value column each, pivot it into this wide shape first, PlotSet's radar template reads columns as spokes, not rows.
- 03
Normalize every measure to the same scale
Convert every column to the same range, a score out of ten, a percentage, a percentile, before you upload. This is the step that decides whether the finished polygon means anything, and it has to happen in the spreadsheet: PlotSet plots whatever numbers it is given.
- 04
Upload your file or connect a sheet
Use the data panel to import a CSV or .xlsx file, paste rows directly, or connect a Google Sheet if you want the chart to pick up later edits without a re-upload. PlotSet reads the first row as your spoke labels 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. - 05
Check the column binding covers every measure
Open the data binding panel and confirm the range extends to your last column. The template's default binding is set for its sample data, and a sheet with more measures than the sample will silently drop the extra columns if you do not widen it.
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. - 06
Fix the spoke order and set the axis minimum to zero
Confirm the spokes read in the order you intended, since that order came straight from your column order. Then check the radial axis starts at zero: a minimum set above zero shrinks every gap and flatters whichever item scored lowest.
- 07
Style: light fills, one colour per item, label a ring
Give each item its own colour and drop the fill opacity so overlapping polygons stay readable. Turn on a label for at least one grid ring so the reader has a value to anchor the shape against, not just an unmarked web of lines.
Der Tab "Preview" für ein Diagramm vom Typ "Radar Chart". 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, embed or export
Publish for a live, interactive chart with hover tooltips and a shareable link, grab the embed code to drop it into a page, or export a PNG, SVG or PDF if you need a static image for a report.
Starten Sie mit der Radar Chart-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 Radar Chart
Cap it at three polygons
Two items compare cleanly and three is workable if the colours are distinct. A fourth polygon starts occluding the others no matter how translucent the fill is. Past three, build one small radar per item instead, same axes, same order, side by side.
Order the spokes by story, not by spreadsheet habit
Group related measures next to each other, cost-type measures on one side and quality-type measures on the other, for instance. The order is doing real work: it decides which parts of the silhouette sit next to each other.
Keep fill low and outlines strong
Somewhere around 15 to 25 percent opacity on the fill lets overlapping shapes stay legible, while a solid outline keeps each polygon identifiable even where two fills stack on top of each other.
Label the axis, not just the spokes
Spoke names alone tell a reader what is being measured, not how far out is good. Add value labels or ring labels so somebody unfamiliar with your scale can still read the chart correctly.
Häufige Fehler bei Radar Chart
One spoke sits flat at the centre for every item
The column binding stopped short of your last column, so PlotSet never read that measure. Open the data binding panel and widen the range to cover every column in your sheet, then check the chart updates.
The polygons come out in a different order than you planned
Spoke order follows column order in the source sheet exactly, not the order you had in your head. Reorder the columns in your spreadsheet and re-upload rather than trying to fix it after the chart is styled.
One item's shape balloons out on a single axis
Almost always a column that never got normalized, dollars or raw counts sitting next to scores out of ten. Go back to the source sheet, convert that column to the same scale as the rest, and re-upload.
Mehr über Radar Chart erfahren
Nicht sicher, ob Radar Chart die richtige Wahl ist? Erfahren Sie, was es ist, wann Sie es verwenden sollten und wann nicht.
Radar Chart: häufige Fragen
Wide format, with one row per item and one column per measure. The first column holds the item's name, and every column after it becomes one spoke, so a five-measure comparison needs six columns total, all on the same scale.
Jetzt Radar Chart erstellen
Kostenlos starten mit über 300 Vorlagen. Keine Kreditkarte erforderlich.