CSV de ejemplo
| 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.
Unos 9 minutosBy 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.
Los datos que necesitas
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.
Los pasos
El camino exacto en PlotSet, desde una plantilla en blanco hasta el gráfico terminado.
- 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.
Todas las guías empiezan aquí. Elige la categoría y luego la plantilla. Es la misma cuadrícula sea cual sea el tipo de gráfico que busques. - 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 vista de datos, aquí en un proyecto de gráfico de barras. Sube un CSV, saca los números de una imagen con Magic Import o sincroniza una Google Sheet. El panel es el mismo en todos los tipos de gráfico. - 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.
Las asignaciones deciden qué columna se convierte en la etiqueta, cuál aporta los valores y cuál define el color. Auto Binding las deduce de tus encabezados, así que revísalas en lugar de darlas por buenas. - 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.
La pestaña Preview de un gráfico de tipo Radar Chart. Todos los controles de estilo están en el panel enmarcado: apariencia, encabezado, pie de página y las opciones propias de este tipo de gráfico, cada grupo en su propia pestaña. - 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.
Empieza con la plantilla de Radar Chart, que ya trae datos de ejemplo cargados, y sustitúyelos por los tuyos.
Abrir la plantillaPublícalo, incrústalo o expórtalo
El último tramo es igual en todos los tipos de gráfico: Share convierte el gráfico en un enlace público en vivo y un código de incrustación, y Export lo guarda como un archivo estático.
Share: enlace público y código de incrustación
Al activar el código de incrustación y el enlace público, el gráfico queda publicado. El enlace se lo puedes enviar a cualquiera sin problema, y el código de incrustación se coloca en cualquier página como un iframe que conserva los tooltips al pasar el cursor y toda la interactividad. Si editas el gráfico más adelante, haz clic en Recreate para llevar esos cambios a ambos.
Export: SVG, PNG o JPG
Export guarda una copia estática en el tamaño que necesites. El SVG se mantiene nítido a cualquier escala y se puede seguir editando en una herramienta de diseño; PNG y JPG son la opción segura para diapositivas y documentos. El multiplicador de escala es lo que te da una imagen nítida en una pantalla retina.
Consejos de estilo para 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.
Errores comunes al hacer 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.
Aprende más sobre el Radar Chart
¿No estás seguro de que el Radar Chart sea la opción correcta? Descubre qué es, cuándo usarlo y cuándo no.
Radar Chart: preguntas frecuentes
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.
Crea tu Radar Chart ahora
Gratis para empezar con más de 300 plantillas. No se necesita tarjeta de crédito.