How to Create a Histogram Chart in Google Sheets

In this tutorial, you will learn how to create a histogram chart in Google Sheets.

How to Create a Histogram Chart in Google Sheets

Instead of grouping data by distinct values, a histogram groups data into “buckets” of closely similar values. There is a simple, built-in histogram graphing tool available in Google Sheets.

A histogram groups test results into relative ranges as opposed to listing how frequently each score was achieved.

Once you are ready, we can get started by using real-life scenarios to help you understand how to create a histogram chart in Google Sheets.

Creating a Histogram Chart

Before we begin we will need a group of data to be used to create the histogram chart.

Step 1 – Group your data

Make sure your group of data is displayed in a clean and tidy manner. This will help us to create the histogram chart easily.


Step 2 – Select data

Select the entire data cell, choose Insert, and select Chart.


Step 3 – Setup histogram

By default, Google Sheet will use the selected group of data to generate a scatter chart.

You can easily change it to a Histogram chart by choosing it at the Chart type under the Chart Editor.


Step 4 – Customize chart

Now, you can customize the histogram chart to your preference. We will change the chart title to ‘Participant Age Bucket’ for a better representation of the histogram chart.

Also, to emphasize the chart title, we will change the text color to black, bold it, and also align it to the center.


Step 5 – Those who don’t know historygrams are destined to repeat it :/

Once you are done editing and customizing the histogram chart, it will look something like this.



That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. The most crucial lesson is to enjoy yourself while doing it.

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to create a histogram chart in google sheets. Want more? Check out all the Google Sheets Tutorials.