How To Make A Histogram In Google Sheets

Last Updated on August 7, 2021 by Jake Sheridan

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

How To Make A Histogram In Google Sheets

Histograms are useful when you want to show the distribution of a data set across ranges of that dataset. The height of each bar represents the frequency of data points in that range.

Google Sheets makes it quick and easy to generate histograms from spreadsheet data.

When your data updates, the histogram will automatically update to reflect the change.

Histograms require only a single data set for which you want to see the distribution.

Insert a Histogram in Google Sheets

To insert a Histogram in Google Sheets, follow these steps:

Step 1

Select the data range you want to plot

Step 2

Open the Insert menu, and select the Chart option

Step 3

A new chart will be inserted as a floating element above the cells, and the Chart Editor sidebar will appear with options to edit the chart.

To turn this chart into a histogram, click on the Chart Type dropdown menu and select the Histogram option from the bottom section in the menu

Step 4

Your chart will update to a histogram

Editing A Histogram

To edit a histogram chart you’ve already created, first open the Chart Editor for that graph by selecting the chart and clicking on the 3 dot menu icon in the corner of the chart.

From the menu that appears, select Edit Chart. The Chart Editor for that graph will open.

You can then make edits to the chart type, data range, or any of the other chart settings available in the Chart Editor and your chart will update to reflect the changes


Example Spreadsheet: Make a copy of the example spreadsheet

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