A step by step walkthrough for turning a ranked spreadsheet into a published bump chart in PlotSet, from shaping the sheet to publishing the finished tracks.
Unos 8 minutosRank instead of raw value is the input here, and how to create a bump chart in PlotSet turns a spreadsheet with an item, a period and a rank column into a published, interactive chart you can embed or export. You will end up with a set of coloured tracks that cross exactly where the underlying ranking actually changed, with names attached at either end and no legend needed to read it.
If your data already has a rank column, this takes about eight minutes. Add another ten if you are starting from raw values and need to rank them within each period first: that step happens in your spreadsheet, before anything is uploaded, and it is the one most people skip by mistake.
Long format, one row per item per period: the item name, the period label, and that item's rank within the period. Three columns, one header row.
| Service | Month | Rank |
|---|---|---|
| Spotify | Jan | 1 |
| Apple Music | Jan | 2 |
| YouTube Music | Jan | 3 |
| Amazon Music | Jan | 4 |
| Spotify | Feb | 1 |
| Apple Music | Feb | 3 |
| YouTube Music | Feb | 2 |
| Amazon Music | Feb | 4 |
| Spotify | Mar | 2 |
| Apple Music | Mar | 3 |
| YouTube Music | Mar | 1 |
| Amazon Music | Mar | 4 |
| Spotify | Apr | 1 |
| Apple Music | Apr | 2 |
| YouTube Music | Apr | 3 |
| Amazon Music | Apr | 4 |
The rank column has to be an integer position (1, 2, 3...), not the raw measure. If you only have subscriber counts or scores, rank them within each period first: a RANK formula in your spreadsheet, sorted per period, does this in one column.
Every item needs a row for every period. A period an item is missing from (a product not yet launched, a team relegated out of the league) leaves a gap in that track rather than a smooth line, so decide up front whether to backfill, drop the period, or leave the gap visible.
Two items cannot share a rank within the same period. A tie uploaded as-is either gets silently broken by PlotSet or draws two tracks on top of each other, so resolve ties in the sheet (alphabetical, or a tiebreaker metric) before uploading.
Keep the period column consistent: all month names, all week numbers, all match dates, not a mix. PlotSet orders periods by reading this column, and a mixed format sorts oddly.
El camino exacto en PlotSet, desde una plantilla en blanco hasta el gráfico terminado.
From the PlotSet dashboard, start a new project and choose the Bump Chart template. It loads with a small ranked dataset already bound to it, so you can see the item, period and rank columns in place before you touch your own file.
Rework your source data into three columns in long format: one row per item per period, with that item's integer rank for the period in the third column. If you are starting from raw values, rank them within each period in your spreadsheet first.
Use the data panel to import a CSV or .xlsx file, paste rows straight from a spreadsheet, or connect a Google Sheet if new periods will keep arriving and you want the chart to pick them up without a re-upload.
Tell PlotSet which column is the item, which is the period, and which is the rank. Clear headers like Service, Month and Rank usually get mapped automatically; check this manually if your sheet carries extra columns PlotSet had to guess between.
Confirm the periods run left to right in the order you intend, not alphabetically. This matters most with month abbreviations or match weeks that do not sort correctly as plain text.
Turn on end labels so item names sit at the first and last period rather than in a separate legend. With names anchored at both edges, a reader can trace any single track through the crossings in the middle without losing their place.
Pick one or two items to keep in full colour and set the rest to a muted grey. Past about eight tracks a fully coloured chart turns into a tangle, and a highlighted track reads clearly against a grey field in a way it never does against seven other bright ones.
Publish for a live chart where hovering a track highlights it against the rest with a tooltip at each node, 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.
Empieza con la plantilla de Bump Chart, que ya trae datos de ejemplo cargados, y sustitúyelos por los tuyos.
Abrir la plantillaEl ú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.
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 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.
Rank alone hides magnitude: first and second can be neck and neck or worlds apart, and the chart looks the same either way. Add the underlying measure (subscribers, points, votes) to the tooltip so a hover fills in what the rank axis cannot show.
An axis that goes up as rank improves is a convention people have to learn, not one they arrive with. Spelling out 1st at the top removes the one moment a reader might mistake a rise for a fall.
Bump charts read the horizontal axis as evenly spaced steps. If your periods are irregular, quarters of different lengths, seasons with byes, gaps read as meaningful when they are just calendar noise. Fill in a placeholder period rather than skip it.
One highlight colour makes a clear point. Two makes a comparison. Past three, even with the rest greyed out, a reader loses track of which line is which by the second crossing.
This means two items share the same rank in at least one period, usually from an unresolved tie in the source data. Go back to the sheet and break the tie with a secondary sort key, then re-upload.
A missing row for that item in one period leaves a hole in the line rather than a smooth connection. Check your data table for the period in question and add the missing row, or accept the gap and say so in a caption.
This usually means raw values were uploaded into the rank column instead of ranks. Open the sheet, rank each period's values from 1 to N, and replace the value column with the rank before re-uploading.
¿No estás seguro de que el Bump Chart sea la opción correcta? Descubre qué es, cuándo usarlo y cuándo no.
A long-format sheet with one row per item per period: an item column, a period column, and an integer rank column for that item within the period. Three columns and one header row is enough. If you only have raw values, rank them within each period before uploading.
Gratis para empezar con más de 300 plantillas. No se necesita tarjeta de crédito.
