Histogram topic

How to Make a Histogram from Excel Data

If your data is in Excel, copy a numeric column and paste it into the online histogram maker. You can also save the worksheet as CSV and upload it.

Use this route when a spreadsheet chart is too limited and you need clearer bin control, labels, themes, or exact export dimensions.

Try the worked example Read the homepage guide

Worked example

From a spreadsheet column to a histogram

This example uses 36 built-in lab measurements in mg/L. Copy a column of values from Excel into the tool, or save your sheet as CSV and choose the numeric column. XLSX files are not supported.

Example spreadsheet column

Concentration (mg/L)
8.2
8.4
8.4
8.7
8.9
9.1
9.2
9.3
9.4
9.4
9.6
9.7
9.9
10
10.1
10.1
10.2
10.4
10.5
10.7
10.8
10.9
11.1
11.2
11.4
11.5
11.7
11.9
12
12.3
12.7
13.1
13.6
14.2
14.8
15.5

36 values · minimum 8.20 · maximum 15.50

Open this example in the tool

Computed from the sample above with the same binning function used in the tool. Open the example to change bins, labels, and export settings.

Frequency table for lab measurements
Interval	Count	Relative frequency
[8.20, 9.42)	10	27.8%
[9.42, 10.63)	9	25.0%
[10.63, 11.85)	8	22.2%
[11.85, 13.07)	4	11.1%
[13.07, 14.28)	3	8.33%
[14.28, 15.50]	2	5.56%

Each interval includes its left edge and excludes its right edge; the final interval includes both edges. Percentages may be rounded.

For example, 10 of the 36 values fall in [8.20, 9.42). The relative frequency is 10 ÷ 36 ≈ 0.278 (27.8%). The chart starts with counts; choose Relative frequency in the tool to compare proportions.

Paste a column or upload CSV

The parser accepts columns, comma-separated rows, tabs, semicolons, spaces, and line breaks. If the file contains multiple numeric columns, choose the column to plot.

Move from spreadsheet to report

After creating the histogram, export SVG, PDF, PNG, CSV, or JSON so the chart, frequency table, and settings can move into a paper, slide deck, or report.

FAQ

Can I paste directly from Excel?

Yes. Select a column or range of numeric cells in Excel, copy them, and paste directly into the data box. The parser handles tabs, commas, spaces, semicolons, and line breaks, so standard Excel copy-paste output works without reformatting.

Can I upload an Excel file?

The tool does not read .xlsx files directly. Export the worksheet as CSV from Excel first, then upload the CSV file. If the file has multiple numeric columns, the tool will let you choose which column to plot.

What if my CSV has several columns?

When the uploaded file contains multiple numeric columns, a column selector appears so you can choose which column to plot. Only one column is plotted at a time, but you can switch columns without re-uploading the file.

Build a histogram from your data

Paste numbers, upload a CSV or TXT file, choose bins, edit labels and styles, then export SVG, PDF, PNG, CSV, or JSON.

Open the tool