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:
Select the data range you want to plot
Open the Insert menu, and select the Chart option
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
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.