Beispiel-CSV
| Warehouse | DeliveryDays |
|---|---|
| Chicago | 2 |
| Chicago | 3 |
| Chicago | 2 |
| Chicago | 4 |
| Chicago | 3 |
| Chicago | 9 |
| Denver | 4 |
| Denver | 5 |
| Denver | 4 |
| Denver | 6 |
| Denver | 5 |
| Denver | 4 |
| Atlanta | 3 |
| Atlanta | 3 |
| Atlanta | 4 |
| Atlanta | 3 |
| Atlanta | 11 |
| Atlanta | 4 |
How to Create a Box Plot
A step by step walkthrough for turning a spreadsheet of raw observations into a published box plot in PlotSet, from shaping the rows to exporting or embedding the finished chart.
Etwa 8 MinutenRaw rows in, ranked boxes out: that is how to create a box plot in PlotSet, ending with a published, interactive chart with outliers labelled on purpose and a caption that states what the whiskers mean. Not a demo with placeholder numbers: your own groups and your own observations, run through the same click path a real PlotSet chart takes from upload to publish.
If your spreadsheet already has one row per observation, a group label and a number, this takes about eight minutes. Add ten more if your source is a report someone already summarized into averages or quartiles: you will need to go back for the underlying rows, because a box plot built from a summary is not a box plot, it is a shape drawn to look like one.
Die Daten, die Sie brauchen
One row per observation, not per group: a group label in the first column, a single number in the second. No pre-calculated quartiles, medians or five-number summaries. PlotSet computes those from the raw rows, so feeding it a summary skips the part that makes the chart honest.
Do not upload a table of quartiles or medians as if it were your data. PlotSet needs the individual observations to compute the five-number summary itself; handing it a summary of a summary produces a median that is wrong more often than it is right.
Keep group labels spelled and capitalized the same way across every row. "Chicago" and "chicago " with a trailing space read as two different groups and split into two boxes.
Give each group enough rows to mean something. A box built from three or four values implies a precision the data does not have; aim for at least ten observations per group where you can.
Extra columns beyond the group and value pair are ignored, so it is fine to keep a date or an ID column in the sheet for your own reference.
Die Schritte
Der genaue Klickpfad in PlotSet, von einer leeren Vorlage bis zum fertigen Diagramm.
- 01
Open the box plot template
From the PlotSet dashboard, start a new project and choose the Box Plot template (vertical by default, with a horizontal version available for long group names). It loads with sample data already in place, so you can see the raw, one-row-per-observation shape PlotSet expects before you touch your own file.
Jede Anleitung beginnt hier. Wählen Sie erst die Kategorie, dann die Vorlage. Das Raster ist für jeden Diagrammtyp dasselbe. - 02
Shape your sheet into raw rows
Put the group label in the first column and one numeric value in the second, one row per observation. If your source is a pivot table that already shows averages or quartiles per group, go back to the underlying data: that is the input this chart needs, not the summary someone else built from it.
- 03
Import your file or connect a sheet
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 chart to refresh when new observations come in. PlotSet reads the first row as headers automatically.
Die Datenansicht, hier in einem Balkendiagramm-Projekt. Laden Sie über "Upload CSV File" eine CSV-Datei hoch, holen Sie die Zahlen mit "Magic Import" aus einem Bild oder verbinden Sie ein Google Sheet. Der Bereich sieht bei jedem Diagrammtyp gleich aus. - 04
Map the group and value columns
Confirm which column feeds the group axis and which one holds the numeric value PlotSet will summarize into quartiles. This is usually correct on its own when your headers are clear, so check it manually only if your sheet carries extra columns that could confuse the guess.
Die Zuordnungen legen fest, welche Spalte zur Beschriftung wird, welche die Werte liefert und welche die Farbe steuert. "Auto Binding" errät sie anhand Ihrer Spaltenüberschriften. Prüfen Sie das Ergebnis, statt sich darauf zu verlassen. - 05
Sort the boxes by median
Switch the default sort away from alphabetical and order the groups by median instead, ascending or descending depending on the story. Once the boxes are ordered by median, the comparison you built the chart for is visible without the reader having to scan for it.
- 06
Decide what to do with the outliers
Leave the individual points beyond the whiskers turned on and label the ones worth naming. If a group is carrying more outliers than the rest, that is usually a finding, not noise to switch off before anyone notices it.
Der Tab "Preview" für ein Diagramm vom Typ "Box Plot". Alle Gestaltungsoptionen stecken im umrandeten Bereich: Aussehen, Kopfzeile, Fußzeile und die Optionen, die es speziell für diesen Diagrammtyp gibt, jeweils in einem eigenen Tab. - 07
Set the whisker rule and note it in a caption
PlotSet's default draws whiskers to 1.5 times the interquartile range, which covers most cases. If you switch it to min and max instead, say so in a caption: the two conventions look the same on the chart and mean different things.
- 08
Publish it, embed it, or export a file
Publish for a live, interactive chart whose tooltip shows the full five-number summary on hover, 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.
Starten Sie mit der Box Plot-Vorlage samt bereits geladenen Beispieldaten und ersetzen Sie diese durch Ihre eigenen.
Vorlage öffnenVeröffentlichen, einbetten oder exportieren
Der letzte Abschnitt ist bei jedem Diagrammtyp gleich: "Share" macht aus dem Diagramm einen öffentlichen Live-Link und einen Einbettungscode, "Export" schreibt es als statische Datei heraus.
"Share": öffentlicher Link und Einbettungscode
Aktivieren Sie den Einbettungscode und den öffentlichen Link, um das Diagramm zu veröffentlichen. Den Link können Sie bedenkenlos an alle weitergeben, und der Einbettungscode fügt sich als iframe in jede Seite ein. Die Tooltips beim Überfahren mit der Maus und die volle Interaktivität bleiben erhalten. Wenn Sie das Diagramm später bearbeiten, überträgt "Recreate" die Änderungen auf Link und Einbettung.
"Export": SVG, PNG oder JPG
"Export" schreibt eine statische Kopie in der Größe heraus, die Sie brauchen. SVG bleibt in jeder Skalierung scharf und lässt sich weiterhin in einem Design-Tool bearbeiten; PNG und JPG sind die sichere Wahl für Folien und Dokumente. Der Skalierungsfaktor sorgt dafür, dass das Bild auf einem Retina-Display gestochen scharf wirkt.
Styling-Tipps für Box Plot
State the whisker rule in the caption
A box drawn to 1.5 times the IQR and one drawn to the minimum and maximum look identical but tell different stories about how extreme the outliers are. One sentence in the caption settles it for the reader instead of leaving them to guess.
Do not force the value axis to start at zero
Unlike a bar chart, a box plot is not encoding a length from a baseline, it is showing where a distribution sits. Forcing the axis to zero on a chart of, say, delivery days in the single digits just compresses every box into a sliver near the top.
Cap it around fifteen boxes on one axis
A handful of distributions read easily side by side; past roughly fifteen, the boxes get thin and the comparison stops working. Filter to the groups the story actually needs and mention in the caption that it is a subset.
Label outliers instead of deleting them
An outlier is usually the most informative point on the chart, not an error. Name the specific one that matters (a date, a location, an ID) rather than hiding it to make the chart look tidier.
Häufige Fehler bei Box Plot
Every box looks like a thin line instead of a box
This is what happens when the sheet holds pre-calculated quartiles or averages instead of raw observations. PlotSet needs the individual values to compute a five-number summary; go back to the source data and upload the actual rows, one per observation.
One box has a whisker stretched far past the others
Check the raw values for that group for a data entry slip, a value in the wrong unit, or simply too few rows. A group with four or five observations produces a box that reacts wildly to a single unusual value.
The boxes sit in alphabetical order, not ranked by median
This means the sort setting is still on its default. Open the sort control in the chart settings and switch it from group name to the median of the value column.
Mehr über Box Plot erfahren
Nicht sicher, ob Box Plot die richtige Wahl ist? Erfahren Sie, was es ist, wann Sie es verwenden sollten und wann nicht.
Box Plot: häufige Fragen
Raw observations, not a summary: one row per data point, a group label in the first column and a single number in the second. PlotSet calculates the quartiles, median and outliers itself from those rows, so a table of pre-computed statistics will not work as the input.
Jetzt Box Plot erstellen
Kostenlos starten mit über 300 Vorlagen. Keine Kreditkarte erforderlich.