Exemple de CSV
| 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.
Environ 8 minutesOne 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.
Les données dont vous avez besoin
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.
Les étapes
Le parcours exact dans PlotSet, d'un modèle vierge à un graphique terminé.
- 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.
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 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 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. - 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.
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. - 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.
L'onglet 'Preview' pour un graphique Histogram. 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. - 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.
Partez du modèle Histogram 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 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.
Erreurs courantes en créant 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.
En savoir plus sur le Histogram
Vous n'êtes pas sûr que le Histogram soit le bon choix ? Découvrez ce que c'est, quand l'utiliser et quand l'éviter.
Histogram : questions fréquentes
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.
Créez votre Histogram maintenant
Gratuit pour commencer avec plus de 300 modèles. Aucune carte bancaire requise.