CSV de ejemplo
| Node | Parent | Spend |
|---|---|---|
| Marketing | ||
| Paid Search | Marketing | 42000 |
| Paid Social | Marketing | 31000 |
| Organic Content | Marketing | 18000 |
| Google Ads | Paid Search | 27000 |
| Bing Ads | Paid Search | 15000 |
| Instagram Ads | Paid Social | 19000 |
| Facebook Ads | Paid Social | 12000 |
How to Create a Sunburst Chart
A step by step walkthrough for turning a spreadsheet of parent, child and value rows into a published sunburst chart in PlotSet, from shaping the sheet to exporting the finished rings.
Unos 9 minutosRings sized by value and coloured by branch, published as a live embed or exported as a static image: this guide is how to create a sunburst chart in PlotSet from your own spreadsheet. The columns below are the exact node, parent and value columns the PlotSet sunburst template expects, not a simplified stand-in for them.
Nine minutes gets you there when your rows are already three clean columns: node, parent, value. A source report that only lists department totals adds another five, since you'll need to add the missing middle level of the hierarchy yourself before anything renders correctly.
Los datos que necesitas
One row per node, three columns: the node's own name, the name of its parent (blank for the top level), and its value. Every parent name must match another row's node name exactly.
Leave the parent column blank only for the root node or nodes. Every other row needs a parent value that matches another row's node name exactly, including case.
Leave the value blank on any node whose number should be computed from its children. PlotSet sums descendants automatically, and typing your own figure there is how rings end up not matching their children.
Node names must be unique across the whole sheet, not just within one branch. If two branches each have a leaf called "Other," rename them ("Search Other," "Social Other") or PlotSet will merge them into one segment.
Keep the value column numeric with no currency symbols or thousands separators. A stray comma or dollar sign turns the whole column to text and every arc collapses to zero.
Los pasos
El camino exacto en PlotSet, desde una plantilla en blanco hasta el gráfico terminado.
- 01
Open the Sunburst Chart template
From the PlotSet dashboard, start a new project and choose the Sunburst Chart template. It loads with a small sample hierarchy already bound, so you can see exactly how a node, parent and value row turns into a ring before you touch 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 into node, parent and value
Give every row a node name, the name of the node it sits under, and a number. Top level nodes get a blank parent. If your source is a pivot table with only totals, add the missing middle rows yourself: PlotSet cannot infer a level you never wrote down.
- 03
Bring your spreadsheet into PlotSet
Use the data panel to import a CSV or .xlsx file, paste rows directly from a spreadsheet, or connect a Google Sheet if you want the rings to update later without a re-upload. PlotSet reads the first row as headers 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. - 04
Map the node, parent and value columns
Confirm which column PlotSet is reading as the node, which as the parent, and which as the value. This usually maps itself correctly when your headers say what they mean, but check it by hand if your sheet carries extra columns PlotSet had to guess between.
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. - 05
Check that children sum to their parent
Before you style anything, scan each branch and confirm its children add up to the number you expect for the parent, or that the parent's value cell is simply blank. A mismatch here is the single most common reason a sunburst chart looks broken once it renders.
- 06
Colour by branch and label what fits
Assign one hue per top level branch and let PlotSet shade its descendants lighter going outward, rather than colouring by depth or leaving the palette random. Turn labels on for rings with room to show them and off for the thin outer ring, where hover tooltips do the job instead.
La pestaña Preview de un gráfico de tipo Sunburst 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. - 07
Turn on drill-down for anything past two levels
If your hierarchy runs three or four levels deep, enable click-to-zoom so a reader can click a segment and make it the new centre. Past two levels a static sunburst is hard to read on its own; drill-down is what makes the extra depth usable.
- 08
Publish, embed or export the finished rings
Publish for a live, interactive chart with hover tooltips, drill-down 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 deck or a report.
Empieza con la plantilla de Sunburst 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 Sunburst Chart
Stop at three levels unless you truly need a fourth
Two or three levels is where a sunburst chart is easiest to read. A fourth level is workable with drill-down turned on; a fourth level on a static export is usually just noise.
Sort each branch's children by value
Within a single parent, order the children largest to smallest before uploading. It gives every ring the same reading direction and makes the size comparison between siblings obvious without labels.
Reserve one colour family per branch
Pick a base hue per top level node and let PlotSet's depth shading handle the rest. Mixing unrelated colours within one branch defeats the one thing colour does for this chart: letting the eye follow a branch outward.
Group small leaves into an explicit "Other"
If a branch has a dozen tiny children and three large ones, roll the tiny ones into a single "Other" node with its own row. It keeps the outer ring legible instead of scattering slivers nobody can click.
Errores comunes al hacer un Sunburst Chart
Rings show a gap or an overlapping seam
This means a parent's arcs do not add up to that parent's own value, whether it was typed by hand or the children are missing a row. Sum the children yourself against the parent's number, fix the mismatched row, and leave the parent's value cell blank going forward so PlotSet computes it.
The whole chart is one flat colour, or every segment is a different one
Both come from the colour mode being set to depth or to a default palette instead of branch. Open the colour settings and switch to colour by branch, which is what keeps a parent and its descendants visually connected as you read outward.
The outer ring is a wall of unreadable slivers
This is almost always too many leaf categories on one branch, sometimes combined with a level that did not need to exist. Roll the smallest leaves into an "Other" node in your source sheet, or turn on drill-down so the reader can zoom into one branch at a time instead of seeing all of them at once.
Aprende más sobre el Sunburst Chart
¿No estás seguro de que el Sunburst Chart sea la opción correcta? Descubre qué es, cuándo usarlo y cuándo no.
Sunburst Chart: preguntas frecuentes
Three columns: a node name, its parent's name, and a value. Top level nodes leave the parent blank, and every other row's parent must match another row's node name exactly. CSV and .xlsx both work, and a pasted range from any spreadsheet tool is fine too.
Crea tu Sunburst Chart ahora
Gratis para empezar con más de 300 plantillas. No se necesita tarjeta de crédito.