How to Make a Histogram in Google Sheets

Google Sheets has a real histogram chart type built in, so you can group your data into bins without any add-ons. Here is the standard chart method, the one-click distribution shortcut, and how to control bucket size for clean, readable bars.

Method 2 — the quick Column stats distribution

For a fast look without making a chart, select your column of numbers and open Data → Column stats. The panel shows a small distribution view alongside the count, average and other summaries — perfect for a quick sanity check before you build the full chart.

Controlling bucket size (bin width)

The single most important setting is Bucket size, found under Customize → Histogram. It sets how wide each bin is. If your chart looks too blocky, lower the bucket size; if it looks noisy and spiky, raise it. The Outlier percentile option groups extreme values so a few unusual points do not stretch the whole axis.

Common Google Sheets histogram mistakes

A handful of issues account for almost every “my histogram looks wrong” question:

• Numbers stored as text. If your values were imported or typed with stray spaces, Sheets may treat them as text and refuse to bin them. Select the column and use Format → Number to fix it.
• Header rows in the selection. Including a text header can throw off the chart. Either leave the header out of the selection or let the Chart editor use it as the series name only.
• Auto bucket size. Leaving bucket size on automatic is fine for a quick look but gives you no control. Set a fixed value once you know your data’s range.
• Multiple columns selected. A histogram expects one numeric column. Selecting several can produce a grouped chart you did not intend.

Histogram or column chart in Sheets?

If Sheets keeps drawing a column chart, remember the difference: a histogram bins continuous numbers and the bars touch, while a column chart compares labeled categories with gaps between the bars. When your x-axis is a set of numbers grouped into ranges, force the chart type to Histogram in the Setup tab rather than accepting the suggested column chart.

For very skewed data — where most values bunch up and a few are huge — a linear axis can hide the detail. Sheets does not offer a log-scaled histogram axis directly, so a common workaround is to add a helper column with =LN(value) and chart that instead, then label the axis as a log scale.

How to change the bucket (bin) size in Google Sheets

The single most-asked question about the Google Sheets histogram chart is how to control the bar width. Google Sheets calls a bin a bucket, and you have full control from the chart editor:

1. Click the finished chart, then click the three-dot menu in the top-right of the chart and choose Edit chart. The Chart editor pane opens on the right.
2. Switch to the Customize tab and expand Histogram.
3. Set the Bucket size to the width you want. For test scores out of 100, try 5 or 10. For percentages, 0.05 or 0.1. Google Sheets redraws the chart the moment you press Enter.
4. To force whole-number edges (0, 10, 20…) instead of Sheets' auto-picked breakpoints, keep the bucket size but leave Show item dividers ticked so you can read the exact edges from the chart.

Sheets doesn't expose a "number of buckets" option directly — you set the width and it computes the count. If you want an exact number of bars, work backwards: divide your data range by the bar count you want, and use that as the bucket size. Or paste the column into the tool at the top of this page, which shows the three standard bin-count rules (square-root, Sturges, Rice) side by side and lets you drag a slider.

Fixing common bucket problems

Too few, chunky bars: reduce the bucket size. Too many, spiky bars: increase it. Bars don't start at 0: Sheets picks its own left edge; there's no built-in override, but tweaking bucket size often re-anchors it. The chart looks empty: your data column probably contains text (headers, blanks, notes). Select only the numeric cells before inserting the chart.