How to Make a Histogram in Google Sheets (and Fix the Buckets)

A histogram looks like a column chart, but it answers a different question. Instead of comparing named things, it shows how a pile of numbers is spread out. How long do most of your discovery calls last? How many items do customers usually put in one order? What ages are the people on your workshop waitlist?

Google Sheets builds the groups, which it calls buckets, for you. That's the bit that makes it so easy, and also the bit you'll most likely want to adjust, so I'll cover both.

What a Google Sheets histogram shows

According to Google's histogram help, you use one to show the distribution of a data set across different buckets or ranges, and the height of each bar is the count of values in that range. So a tall bar over one range of call lengths means lots of your calls landed in that window.

Chart	What it compares
Column chart	Named categories or groups, such as services or months
Histogram	How many raw values fall into each numeric range

Preparing your data for a histogram in Google Sheets

Unlike most charts, a histogram doesn't need a label column. Google's help asks for:

• First column: the raw numbers, one per row. Don't group them yourself.
• First row, optional: a category name, which shows as a label in the legend.
• Other columns, optional: more columns of numbers if you want to compare two sets.

The most common mistake is feeding it a summary, such as a table that already says how many calls ran under half an hour. A histogram wants every single call length listed, then it does the counting.

Making a histogram in Google Sheets on a computer

1. Select the column of numbers, including the heading if you have one.
2. Click Insert, then Chart.
3. In the chart editor, open Setup and click the Chart type dropdown.
4. Choose Histogram chart.
5. Close the editor and drag the chart into position.

Need the editor back? Double-click the chart. Google's chart help keeps the chart type under Setup and the styling under Customize.

Making a histogram in the Google Sheets app

Google gives the same chart steps for Android and for iPhone and iPad:

1. Open the spreadsheet in the Google Sheets app.
2. Select the cells with your numbers.
3. Tap Insert, then Chart.
4. Tap Type and choose the histogram.
5. Tap Done.

Bucket settings live in the Customize tab on a computer, so I'd create it on the phone if you must, then fine-tune on a laptop.

Changing bucket size and outliers in a Google Sheets histogram

Double-click the chart, click Customize, then open the section called Histogram. Google says this is where you can:

• Change the bucket size, which controls how wide each range is.
• Change the outlier percentile, which deals with unusually high or low values at the edges.
• Show item dividers, which draw a line between each value inside a bar.

Bucket size makes or breaks a histogram. Too wide and everything piles into two fat bars; too narrow and you get a comb of thin bars with no clear shape. Try a few sizes and pick the one where the shape of your data is easiest to see. Google's help doesn't give a default value, so it's a matter of trying.

Making your Google Sheets histogram easy to read

Customize section	What to change
Chart and axis titles	Say what was measured, such as Discovery call length in minutes
Series	Change bar colours, or tick Data labels to show each count
Horizontal axis	Set a minimum or maximum value to trim empty space
Vertical axis	Set a minimum or maximum, or use a log scale
Gridlines	Add or soften gridlines

Google's data labels help confirms histograms are one of the chart types that can show labels. On a busy chart I'd turn them on, because it saves readers squinting at the axis.

Comparing two sets of numbers in one Google Sheets histogram

Google's layout allows extra columns of numbers, which means you can put two groups side by side in the same chart. Say column A holds call lengths for new enquiries and column B holds call lengths for existing clients. Select both columns with their headings, insert the histogram, and each column becomes its own series with its own colour and a label in the legend.

It's a quick way to spot a difference you might otherwise miss, such as new enquiries running much longer than catch-ups. Keep the two groups in the same unit, though. Minutes against hours in one chart will only mislead you.

Histogram ideas for small businesses and creators

• Order size: how many items people usually buy at once.
• Video length: the spread of your uploads, so you can see which lengths you make most often.
• Response time: hours between an enquiry arriving and your first reply.
• Session length: how long coaching or client calls really run.

If you'd like a total or an average alongside the chart, my guide on the SUM function in Google Sheets is a quick refresher. And when you're working through a long list and want to mark which rows you've checked, adding tick boxes to Google Sheets keeps track without colour coding.

If your Google Sheets histogram looks wrong

• Only one or two bars: the bucket size is too big. Make it smaller under Customize, then Histogram.
• A flat comb of thin bars: the bucket size is too small.
• Chart shows labels instead of ranges: you've probably selected a text column. Select only the numbers.
• Bars count the wrong thing: you've charted a summary table. Use the raw values instead.

Frequently asked questions

How do I make a histogram in Google Sheets?

Select a column of raw numbers, click Insert, then Chart, and choose Histogram chart from the Chart type dropdown on the Setup tab.

What's the difference between a histogram and a column chart?

Google says a histogram shows the distribution of a data set across buckets, with each bar showing a count. A column chart compares named categories.

How do I change the bucket size?

Double-click the chart, click Customize, open Histogram and change the bucket size. You can change the outlier percentile there too.

Do I need to group my data first?

No. Give Sheets the raw values in one column and it builds the buckets for you.

Can I show counts on the bars?

Yes. Google says data labels work on histograms. Open Customize, then Series, and tick Data labels.