Histogram Maker
Paste a column of numbers, or upload a spreadsheet, and see how they are distributed. Choose the number of bins and download the histogram as PNG or the bin counts as Excel.
- Runs in your browser
- Free
- No sign-up
Paste cells from Excel or Google Sheets, or type rows separated by tabs or commas.
Chart data as a table
| Bin | From (inclusive) | To | Count |
|---|---|---|---|
| 50–60 | 50 | 60 | 2 |
| 60–70 | 60 | 70 | 4 |
| 70–80 | 70 | 80 | 9 |
| 80–90 | 80 | 90 | 6 |
| 90–100 | 90 | 100 | 4 |
How to Make a Histogram Online
- Add your data. Paste cells copied from Excel or Google Sheets into the Data box, or upload an .xlsx, .xls or .csv file. The sample data shows the layout.
- Check the headers. The first row is used as column names when it has no numbers in it; untick "First row is headers" if that guess is wrong.
- Give the chart a title. It is drawn at the top of the image and used for the file names.
- Download. PNG for slides, documents and email (drawn at twice the on-screen size so it stays sharp), SVG for print and the web, or Excel for the numbers behind the chart.
When to Use a Histogram
A histogram shows the shape of one set of numbers: where most values fall, how spread out they are, whether the data is skewed, and whether there are outliers. Exam scores, delivery times, order sizes and response times are typical.
It is not a bar graph of categories. Each bar is a range of values (a bin), the bars touch because the ranges are continuous, and the height is how many values fall in that range.
How to Lay Out Your Data
One column of numbers, with or without a header. If you paste several columns, the first column that contains numbers is used. Text and blank cells are skipped and counted under the chart.
How to Make a Histogram in Excel
To build the same chart natively in Excel, download the Excel file above (or use your own sheet) and:
- Select the column of numbers.
- In Excel 2016 or later, go to Insert > Insert Statistic Chart > Histogram.
- To change the bins, right-click the horizontal axis, choose Format Axis and set Bin width or Number of bins.
In older versions, list the upper edge of each bin in a column and use =FREQUENCY(data, bins) to count them, then chart the counts as a column chart. Excel's automatic bins use Scott's rule, so its default bin count can differ from this tool's.
What This Histogram Maker Does Not Do
- Bins are equal width with rounded edges (for example 50-60, 60-70). Each bin includes its lower edge and excludes its upper edge, except the last bin, which includes both.
- The default number of bins follows Sturges' rule (about 1 + log2 of the count). Change it with the Bins box.
- One data series. To compare two distributions, make two histograms with the same bins.
Other Chart Makers
Every chart maker takes the same pasted or uploaded data, and you can switch type in the Chart type box without retyping anything. To chart a whole workbook column by column, with grouping by sum, count or average, use the Excel chart maker.
- Bar Graph Maker: Compare categories as bars; paste data, download PNG or Excel.
- Line Graph Maker: Plot a trend over time with one line per series.
- Pie Chart Maker: Show parts of a whole with percentages worked out.
- Scatter Plot Maker: Plot X against Y to see whether two numbers are related.
- Doughnut Chart Maker: A pie chart with the total shown in the center.
- Radar Chart Maker: Compare profiles across several attributes on a spider chart.
- Area Chart Maker: A line graph with the volume underneath shaded in.
Frequently Asked Questions
There is no single right answer. Too few bins hide the shape; too many make it noisy. A common starting point is Sturges' rule, 1 + log2(n), which gives 6 bins for 25 values and 11 for 1,000. This tool starts there and lets you change it; the edges are rounded to tidy numbers, so the final count can differ by one.
The higher one. A score of 70 with bins 60-70 and 70-80 is counted in 70-80. The only exception is the maximum value, which is counted in the last bin so it is never left out.
One row per bin with a label, its lower edge, its upper edge and the count, so you can chart it as a column chart in Excel or use the counts in other formulas.
It contains the chart's data, laid out the way Excel's Insert > Chart expects, not a chart object. Open it, select the cells and insert the chart type named in the steps above; it takes a few seconds and gives you a native chart you can restyle. For a finished picture, use Download PNG.
No. Pasted data and uploaded files are read and drawn in your browser, and the PNG, SVG and Excel files are made there too. Nothing is sent to a server.