Exemple de 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.
Environ 9 minutesBy 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.
Les données dont vous avez besoin
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.
Les étapes
Le parcours exact dans PlotSet, d'un modèle vierge à un graphique terminé.
- 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.
Chaque guide commence ici. Choisissez la catégorie, puis le modèle : c'est la même grille quel que soit le type de graphique visé. - 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.
La vue données, ici sur un projet de graphique en barres. Importez un CSV, extrayez les chiffres d'une image avec 'Magic Import' ou synchronisez une Google Sheet. Le panneau est identique pour tous les types de graphique. - 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.
Les associations déterminent quelle colonne devient l'étiquette, laquelle fournit les valeurs et laquelle pilote la couleur. 'Auto Binding' les devine à partir de vos en-têtes : vérifiez-les plutôt que de les tenir pour acquises. - 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.
L'onglet 'Preview' pour un graphique Radar Chart. Tous les réglages de style se trouvent dans le panneau entouré en rouge : apparence, en-tête, pied de page et les options propres à ce type de graphique, chacun dans un onglet distinct. - 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.
Partez du modèle Radar Chart avec des données d'exemple déjà chargées, puis remplacez-les par les vôtres.
Ouvrir le modèlePublier, intégrer ou exporter
La dernière ligne droite est la même pour tous les types de graphique : 'Share' transforme le graphique en lien public actif et en code d'intégration, 'Export' l'enregistre sous forme de fichier statique.
Share : lien public et code d'intégration
Activer le code d'intégration et le lien public revient à publier le graphique. Le lien peut être envoyé à qui vous voulez sans risque, et le code d'intégration s'insère dans n'importe quelle page sous la forme d'une iframe qui conserve les infobulles au survol et l'interactivité. Si vous modifiez le graphique par la suite, cliquez sur 'Recreate' pour répercuter ces changements sur le lien comme sur le code.
Export : SVG, PNG ou JPG
Le bouton 'Export' génère une copie statique à la taille dont vous avez besoin. Le SVG reste net à toutes les échelles et peut encore être modifié dans un outil de design ; PNG et JPG sont les choix sûrs pour les présentations et les documents. C'est le multiplicateur d'échelle qui vous donne une image nette sur un écran retina.
Conseils de style pour un 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.
Erreurs courantes en créant un 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.
En savoir plus sur le Radar Chart
Vous n'êtes pas sûr que le Radar Chart soit le bon choix ? Découvrez ce que c'est, quand l'utiliser et quand l'éviter.
Radar Chart : questions fréquentes
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.
Créez votre Radar Chart maintenant
Gratuit pour commencer avec plus de 300 modèles. Aucune carte bancaire requise.