How to Make a Histogram in Google Sheets

Histograms show you the spread of data across your data table. I will show you how to make one in just a few quick steps.

Also, keep in mind that there is a difference between Histograms and Bar Graphs; histograms show you the distribution of statistics across your data.

Step #1: Set Parameters

How to Make a Histogram in Google Sheets Step 1

You will need a data table with at least two columns: one to set the x-axis, and one to set the y axis. 

The first column will typically be some sort of variable counter, whether it is a trial number or some time frame. in this case, the x-axis will a list of students. 

The second column will be some numerical value associated with the parallel Y-Axis Cell. In this case, it is some grade percentage between 0 and 100. 

Step #2: Insert Chart

How to Make a Histogram in Google Sheets Step 2

Next, highlight your entire data table and click Insert on the toolkit located in the header. Then, in the drop-down menu, select the Chart option. That will insert a line graph with the data from your table ported into chart form.

Step #3: Pick Histogram

How to Make a Histogram in Google Sheets Step 3

In the chart editor menu, you will see an option to select the Chart Type.  This will open a massive catalogue of different charts that you can create.

As you scroll down to the bottom of the catalogue, you will see the Histogram option. Select that, and it will transform your line graph into a Histogram. 

Step #4: Customize

How to Make a Histogram in Google Sheets Step 4

In the chart editor, you will also see the Customize menu. This will let you edit and correct your histogram until you get what you want out of it.


And there you have it, that is how you create a Histogram in Google Sheets.

Leave a Reply

Your email address will not be published. Required fields are marked

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Google Sheets Magic Tricks!

Interactive, Easy and Free Way to Learn 5 Awesomely Cool Google Sheets Tricks!