Use this free box plot maker to compare medians, spread, and unusual values. Import CSV, Excel, or pasted cells, choose a value field and an optional group, then export a box-and-whisker plot as PNG or SVG.
CSV, TSV, XLS/XLSX or pasted cells. Your spreadsheet contents stay on this device.
Save or reopen data and style
Download a local file with your table, title, theme, source and notes. Reopening detects fields again; review chart-specific settings. No data is uploaded.
Start with your table or try the sample
Numeric values + optional group column
No account or server-side file processing.
Paste data from Google Sheets
In Google Sheets, select the cells with their column headers and copy them. Choose Paste data above, paste the table, and choose Use pasted data. Copy the cell range rather than a chart image or a spreadsheet sharing URL.
Copy a raw numeric value column and an optional group column, including their headers. After pasting, review Value field, Group by, and the quartile method. Each group needs at least two observations. A table of pre-calculated quartiles is not raw input.
This is a separate chart made from the copied values; later changes in Sheets do not update it. The table is processed locally in your browser.
Input requirements
Give the chart the right data
Use raw numeric observations with a header, not a pre-calculated five-number summary. Select one value column and optionally a separate group column. Each group needs at least two values; up to 12 groups share one measurement unit and one axis. Blank selected cells block generation.
Maximum import: 10 MB, 2,000 rows including the header, 100 columns, and 20,000 cells. This tool accepts zero or absolute numeric values between 10⁻⁹ and 10¹²; rescale extreme values first. Excel imports read the first worksheet.
Choose deliberately
When to use a box plot
This box plot generator summarizes distributions such as delivery times, test scores, or order values. Compare group medians and the middle 50% of observations on a shared scale. Group counts remain visible because equal-width boxes do not imply equal sample sizes.
When to choose another chart
A box plot hides the detailed shape of a distribution. Use a histogram to examine one variable's frequency pattern, a scatter plot for paired measurements, or bars for category totals. A flagged outlier is not automatically a mistake, and different quartile conventions can change the result.
From table to figure
Three steps to a useful chart
Import and review
Upload a spreadsheet, paste cells, or load fictional sample data. Review the automatically selected fields and correct them if necessary.
Read and refine
Inspect the values and any data warnings. Choose a publication style, canvas, title, and source note.
Export your result
Download editable SVG or PNG at 1×, 2×, or 3×. The original spreadsheet contents stay in your browser.
Before you create your chart
How are the quartiles calculated?
The default uses linear interpolation at positions (n − 1) × p in the sorted values, with p = 0.25, 0.5, and 0.75. This matches Excel QUARTILE.INC. You can instead take the medians of the lower and upper halves, excluding the overall median when n is odd.
What do the whiskers and outlier points mean?
IQR is Q3 minus Q1. Whiskers end at the smallest and largest observed values within Q1 − 1.5 × IQR and Q3 + 1.5 × IQR, inclusive. Values outside those fences are drawn as outlier points and retained in the data and statistics.
Can I compare multiple groups?
Yes. Supply one row per observation, with a numeric value and a separate group label. Select Group by to compare up to 12 groups. Each group needs two or more observations, and all values must measure the same quantity in the same unit.
Why does my result differ from another box plot?
Check the quartile method, grouping, units, and whisker convention. Some tools include the median in both halves or draw whiskers to the minimum and maximum. This tool documents its selected method and uses 1.5 × IQR fences.
Can I enter a five-number summary?
No. This version needs raw observations so it can calculate quartiles and identify outliers. A table of Min, Q1, Median, Q3, and Max would be treated as observations and produce a different result.
Does a box plot prove a difference is significant?
No. It is a descriptive chart, not a hypothesis test. Small samples and unusual observations need context; compare the source data and use an appropriate statistical test for an inferential claim.
Does Charttoolbox upload my data?
Spreadsheet contents are parsed, calculated, and rendered locally. Optional Google Analytics loads only after consent and does not receive filenames, spreadsheet contents, or generated chart data.
Explore related chart tools
Use a tool that matches the question you are asking.
The line inside each box is the median. The box runs from Q1 to Q3 and contains the middle 50% of the observations. Whiskers reach the most extreme observed values within the 1.5 × IQR fences, and circles mark values outside. The statistics table reports both the raw minimum/maximum and the whisker endpoints.
In the fictional warehouse sample, North has Q1 = 3, median = 4, and Q3 = 5 with inclusive quartiles. Its IQR is 2, so the upper fence is 8: the whisker ends at 5, while 12 appears as an outlier. South has a median of 5 and no outliers under that method. These summaries describe the sample; they do not establish a statistically significant difference.
Use the dot plot maker to retain individual numeric positions and count repeated values in vertical stacks. It accepts up to 200 raw observations. Choose a histogram when values are numerous or too densely spaced to distinguish.
Help us improve Charttoolbox
With your permission, we use Google Analytics to understand visits and feature usage. We never send file names,
spreadsheet contents, cell values, or chart data. Privacy details