CSV de ejemplo
| TicketId | ResponseTimeMinutes |
|---|---|
| 1 | 4 |
| 2 | 7 |
| 3 | 5 |
| 4 | 12 |
| 5 | 9 |
| 6 | 6 |
| 7 | 21 |
| 8 | 8 |
| 9 | 5 |
| 10 | 14 |
| 11 | 3 |
| 12 | 10 |
How to Create a Histogram
A step by step walkthrough for turning a spreadsheet into a published histogram in PlotSet, from shaping your data to setting the bin width and exporting or embedding the finished chart.
Unos 8 minutosOne raw column of numbers is all it takes to learn how to create a histogram in PlotSet: upload it, and you end with a published, interactive chart you can embed or hand off as an image. You'll upload your own observations, not the sample data the template loads with, going through the same click path a real PlotSet chart takes from upload to publish.
Budget about eight minutes if your column is already clean: one header, one number per row, no blanks. Add a few more if you're pulling that column out of a wider export or a pivot table, since a histogram needs raw observations, not something you've already counted or bucketed by hand.
Los datos que necesitas
One numeric column of raw, unsummarized observations: one row per measurement, a single header row, no totals and no pre-counted buckets.
PlotSet only bins the numeric column, so an id or ticket number sitting next to it is fine. What it can't use is a column of pre-counted totals, one row per bracket instead of one row per ticket.
This has to be raw observations: one row per response, not a count of how many tickets fell into each time bracket. If your sheet already looks like that, you've built a bar chart, not a histogram.
Strip stray units and commas before uploading. A cell that reads '12 min' or '1,200' imports as text, and PlotSet will treat it as a category instead of a number.
Blank cells are excluded from the count rather than treated as zero. That's usually what you want, but a blank caused by a stray space or a typo is easy to miss, so scan the column before you upload.
Los pasos
El camino exacto en PlotSet, desde una plantilla en blanco hasta el gráfico terminado.
- 01
Pick the Histogram template
From the PlotSet dashboard, start a new project and choose the Histogram template. It loads with a sample column of numbers already in place, so you can see the shape PlotSet expects (one column, one row per observation) 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 down to one raw column
Pull out the single numeric column you want the distribution of: response times, order values, exam scores, whatever you're measuring. Delete any row that isn't an individual observation, including a subtotal row or a bracket you've already counted by hand.
- 03
Upload your file or connect a sheet
Use the data panel to import a CSV or .xlsx file, paste the column straight from a spreadsheet, or connect a Google Sheet if you want the chart to update later without a re-upload. PlotSet reads the first row as a header 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 numeric column
Confirm which column PlotSet is binning. This is usually automatic when the header is clear, but check it manually if your sheet still has an id or date column sitting next to the numbers, since one of those getting picked up by mistake will wreck the bins.
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
Set the bin width
This is the one setting that changes the story, so don't leave it on the automatic default without looking. Try two or three widths and watch the shape change: too wide flattens a second peak into one hump, too narrow turns ordinary noise into what looks like a feature. Land on a round number a reader can hold in their head, 5 minutes, 10 points, 1000 dollars, rather than whatever the automatic rule produces.
- 06
Label the axes and add a title
Turn on the frequency axis label so it's clear the bars are counts, not raw values, and state the bin width somewhere in the title or a caption, such as 'Response time, 5 minute bins.' That single line saves a reader from misreading the chart.
La pestaña Preview de un gráfico de tipo Histogram. 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
Publish the histogram, or export it as an image
Publish for a live, interactive chart with hover counts on each bin and a shareable link, grab the embed code for a page, or export a PNG, SVG or PDF if you need a static image for a deck.
Empieza con la plantilla de Histogram, 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 Histogram
Favor round bin widths over the automatic default
PlotSet will suggest a bin width based on your data, and it's a reasonable starting point, not a final answer. A width of 5, 10 or 25 is far easier for a reader to interpret than 7.3, even when the automatic number technically fits the data better.
Start the frequency axis at zero
Bar height is the encoding here just as it is on a bar chart, so a truncated frequency axis exaggerates every gap between bins. If two bins look close in height, add count labels rather than zooming the axis in.
Keep the bin count somewhere between ten and thirty
Fewer than ten bins and you lose the shape; more than thirty and every bar gets thin enough that the eye can't compare neighbours. If your data needs finer resolution than that to tell its story, a KDE curve, or a second chart split by group, usually serves better.
Reach for the KDE overlay when the bars look noisy
If the bar heights wobble no matter which width you try, add the smooth density curve instead of fighting the bins. It shows the underlying trend without depending on where an edge happens to fall, and it's one setting away from the plain histogram template.
Errores comunes al hacer un Histogram
The bars have gaps between them, like a bar chart
This almost always means PlotSet is reading your numeric column as text: a stray unit ('12 min'), a thousands comma ('1,200'), or a leading character from a spreadsheet export. Clean the column down to plain numbers and remap it, and the bars should close up into a continuous scale.
One bar sits far out on its own, off to the right
Check that row for a data entry mistake before treating it as a real outlier: an extra zero, a unit typo, or a value copied from the wrong column. If it turns out to be genuine, keep it and either widen the bin width or annotate the tail, rather than deleting it to tidy the chart.
The bar count doesn't match how many rows you uploaded
That usually means the sheet was already summarized, one row per bracket with a count column, rather than one row per observation. Go back to the raw data: a histogram needs to do its own counting, so feeding it pre-counted brackets produces a chart of your bins, not the data's actual distribution.
Aprende más sobre el Histogram
¿No estás seguro de que el Histogram sea la opción correcta? Descubre qué es, cuándo usarlo y cuándo no.
Histogram: preguntas frecuentes
One column of raw numbers, one row per observation, with a single header row. PlotSet does its own counting into bins, so don't pre-summarize the data into brackets first. An id or date column next to the numbers is fine; PlotSet just ignores it when it bins the numeric column.
Crea tu Histogram ahora
Gratis para empezar con más de 300 plantillas. No se necesita tarjeta de crédito.