How to Make a Histogram in Google Sheets

How to Make a Histogram in Google Sheets

Data visualization helps you see an overview and better understand your data. A histogram sorts data into “buckets” of closely related values rather than by unique values. It helps you understand the dynamics, trends, and relationships among data sets and draw meaningful inferences, such as the outliers in the data, the span of the data, and more. Google Sheets features an easy-to-use, built-in histogram graphing tool. This guide shows you how to use it to make a histogram in Google Sheets.

Making a Histogram in Google Sheets

To make a histogram in Google Sheet, follow these steps:

  1. Highlight the data you want to include in the histogram.

    Select Data
    Select the range you want to convert into a histogram.

  2. From the Insert menu, select the Chart option.

    Choose the Chart option from the Insert menu.

  3. You will notice a chart appear on the worksheet. On the right-hand side, a Chart editor will appear.
    Histogram from the selected range

    Make sure the chart type is Histogram chart.

    Chart Type
    Chart Type should be Histogram chart.

Customizing a Histogram in Google Sheets

You can customize the histogram by left-clicking on the three-dotted vertical button on the top-right corner of the chart and selecting Edit Chart. On the right side, a Chart editor will appear.

Chart and Axis titles

The chart title tells us what the chart is, while axes titles are used to categorize the data. To add them, follow these steps:

  1. On the Chart editor, click on the Customize section.

    Customize Section
    Click on the Customize Section.

  2. Under the “Chart & axis titles” section, choose:
    Chart title: to add a chart title
    Chart subtitle: to add another line of text beneath the chart title
    Horizontal axis title: to add x-axis title
    Vertical axis title: to add y-axis title

    Chart and axis title
    Choose where you want to add title text.

  3. Under the “Title text” section, enter the title name.

    Tile Text
    Enter the title name in the Title text field.


By default, histograms on Google Sheets come with gridlines. To remove gridlines, go to the Chart editor. Under the “Customize” section, click on the Gridlines and ticks option. Uncheck the Major gridlines option.

Hide Gridlines
Under the Gridlines and tick section, uncheck the Major gridlines option.

Changing Bar Colors

To change the bar colors of the histogram, go to the Series section. Click on the Fill color dropdown and choose the color from the color palette.

Bar Colors
Under the Series section, choose the color from the Fill color dropdown.

Phoebe is an HR assistant in her day job, but is also a web blogger that loves writing guides and sharing her experiences. When she is not out with her friends, she enjoys traveling or binge-watching Netflix. She graduated with a BA in Communication and Media Studies from the University of Utah, and is a chief editor at TechObservatory.

Leave a Comment