In this article:

How to Make Histogram Charts in Google Sheets

May 8, 2024

Unsure which chart type to use? Click here to find the right chart for your data and the ideas that you want to convey. 

A histogram chart, commonly known simply as a histogram, is often used to give a visual representation of data distribution. It groups the numeric data within  specific intervals, displaying how many individual values fall in each interval. Each of these intervals is shown in terms of ‘buckets’ or ‘bins.’ 


The histogram may look like a column chart because of the use of bins. However, these two charts are different in terms of their applications. The histogram shows continuous data and is used to understand the distribution of a data set. In contrast, column charts are used to compare categorical data.


In this tutorial, we will learn how to use Google Sheets to make a histogram for our data. 

How to format data for a histogram  

There are two ways to format the data when creating a histogram, either a column list or a row list. However, it is often better to use a column list with a header for  good data visualization. 

Consider this hypothetical example of the waiting time of 20 customers. Each data point represents the time that a customer waited for a customer service representative. 

Image: Sample data set to be visualized

Following the recommended format above, we simply put all the data into 1 column:

Image: The data set formatted for use by the histogram

How to add a histogram 

Step 1. Select the table of values. 

Image: The selected dataset. 

Step 2. Go to Insert, then click Chart.

Image: Insert menu selected. The chart option is highlighted.

Another option is to click the chart icon at the end of the main toolbar.

Image: Insert chart icon. It is located near the right end of the main toolbar.  

Step 3. Google sheets will automatically create a chart based on your data. If the chart is not yet a histogram, go to the Chart Editor, which pops out at the right side of your Google Sheet. Select Setup. Under chart type, click the drop-down menu, then scroll down and look for the histogram located under the subsection Other.

Image: Given our sample dataset, Google Sheets automatically create a histogram. If it does not automatically create a histogram, you must select the histogram on the Chart editor under Chart type. 

If you accidentally closed the Chart editor, you can still open it by selecting the chart on your sheet. Click on  the vertical ellipsis icon located at the upper right of your chart. Select Edit chart. 

Image: Edit chart option to open the chart editor. 

Step 4. You now have a histogram with a recommended title, some axis headings, and ranges. 

Image: Histogram of our data set.

If you hover your cursor to any bins on your histogram, you will see the interval and its corresponding count. 

Image: The count for an interval is displayed by hovering the cursor over one of the buckets. 

Note: The interval for the first bucket is 10.00 - 19.00 seconds and for the second bucket is 19.00-28.00 seconds. If your data consists of 19, the count for that value of 19 will be added to the first bin.  

How to customize the histogram


Most of the time, the histogram created by Google Sheets is enough. You can also customize some of the details of your histogram, such as intervals, titles and headings, and bucket color, for better presentation. 

Changing the size of the intervals

To change the size of the intervals, go to the Customize tab of the Chart Editor. Select the Histogram, then under bucket size, choose your desired interval. 

Image: Customize tab of the Chart editor. Bucket size selected under the histogram option

Image: Histogram of the data set when bucket size is set to 5.  

Changing the chart and axis titles and their formats

By default, there is no vertical axis title. The column heading you have in your data will be the horizontal axis title, and adding the phrase “Histogram of” before your column heading will be the chart title. 


You can add and change the chart and axis titles by going to the Customize tab of the Chart Editor. Under the Chart and axis titles tab, choose which title you would like to edit using the Title Type selector drop-down menu. You can also modify the corresponding font size, font style, format, and color of the titles.

Image: Customize tab of the Chart Editor. Under chart and axis titles, you can also edit the font, font size, format, and text color. 

Image: Histogram after adding the vertical axis title, formatting the font style and position of the titles. 

Changing the bucket color


If you wish to change the color of the buckets, go to the Series section of the Customize Tab under Chart Selector. You can also do this by double-clicking on one bucket on your chart. 


Image: Changing the bucket color via the fill color option of the series section under the Customize tab. 

Sample Sheet for Histogram

You can try creating your own histogram using this sample sheet

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->