Google Sheets histogram guide

How to Make a Histogram in Google Sheets

By the Free Histogram Maker editorial teamUpdated June 2026How we check our guides

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 1 — Insert a histogram chart

This is the most flexible route and gives you full control over the bins and styling.

Example histogram of a customer age distribution — Example output: customer ages grouped into bins.

Enter your data in one column
Type or paste your numbers down a single column, with an optional header in the first cell.
Select the column
Highlight the data, then open Insert → Chart.
Choose the Histogram chart
In the Chart editor, on the Setup tab, open Chart type and pick Histogram.
Set the bucket size
Open the Customize tab, expand Histogram, and set Bucket size for bin width plus the outlier percentile if needed.
Title and download
Add a chart and axis title under Customize, then use the chart’s three-dot menu to Download as PNG.

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.

Prefer not to fiddle with buckets?

Copy your column out of Sheets and paste it into the maker. It picks sensible bins automatically, shows the mean, median and standard deviation, and lets you download the chart or a CSV frequency table you can paste straight back into Google Sheets.

Open the free histogram maker

FAQ

Google Sheets histogram questions

What is bucket size in a Google Sheets histogram?

Bucket size is the width of each bin. A larger bucket size groups more values into each bar and produces fewer, wider bars; a smaller bucket size gives more, narrower bars. Set it under Customize → Histogram → Bucket size.

Is there a one-click histogram in Google Sheets?

Yes. Select a column of numbers and open Insert → Chart; Sheets often suggests a histogram automatically. You can also highlight a column and read its quick distribution in the Column stats panel.

Why does my Google Sheets histogram look wrong?

Usually the bucket size is left on auto. Set a fixed bucket size to control bin width, and check that your column contains numbers, not text. Removing stray header rows from the selection also helps.

Can I make the histogram show percentages?

Google Sheets shows counts by default. For a true relative frequency histogram, build a helper column of percentages, or paste your data into our frequency histogram maker and tick relative frequency.

Keep going