How to Make a Histogram in Google Sheets Quickly

To see frequency distributions of things, you need a histogram chart in your sheet. Here’s how to make a histogram in Google Sheets quickly.

histogram chart in google sheets

There’s a time when you have to know the frequency of distributions of things to get a clearer idea of your data. Here’s how to make a histogram in Google Sheets easily.

A histogram is simply a graphic that shows you an equal something distributed into a lot larger range of things. For example, you want to know how equal wage the manager pays the employees across different ages or positions.

By looking at a histogram, you can know which position has low or the lowest wage, and which has a high or highest wage, from the total amount of wages the manager has to pay monthly to everyone.

It’s like the bar chart, but instead of seeing the highest bar, you are seeing the combination of bars to get more accurate information about distributions of stuff.

How to make a histogram in Google Sheets

Making a histogram in Google Sheets is easy. All you need is a column or more that represent variables of data you want to know the frequency distribution of.

For example, if you want to know the distribution of wages, simply prepare a column of positions and a column of wages. Select those two columns.

Then, click the Insert menu and select Chart.

how to make a histogram in google sheets

On the right side of your screen, simply select the Histogram chart as the Chart type. It is located in the Other section.

choosing different chart

Once you choose the chart type, you will immediately see the histogram. You can customize, move, or edit anything about the histogram you’ve made in your Google Sheets spreadsheet.

histogram chart in google sheets

How to edit your histogram chart in Google Sheets

The histogram you just made may not look good enough, or there are some things you want to add or remove. You can edit the histogram by clicking the vertical three dots at the right-top corner of it, then select Edit chart.

edit chart in google sheets

You can customize the data range you’ve selected, changing the x-axis, and the series. At the bottom, you can check whether you want to switch rows or columns, use the first row as the header, and more.

setting up a histogram chart

To remove a series, you can simply click the vertical dots button and select Remove.

remove a series from a histogram chart

Go to the Customize tab. You would see the chart customization options. In here, you can customize the background color, the font, and the border color.

customize a histogram chart

Click Histogram. You would see options to add item dividers, change the bucket size, and outlier percentile as you’d like.

show item dividers in a histogram

You can also change the chart and axis titles. The styles, like the title text, font, font size, title format, and font color can be changed. You get more control over the chart you’re making.

chart and axis titles in histogram

In the Series, you can change the series and change the color.

setting a series

In Legend, you can change the position of the legend, the font, font size, format, and color.

customizing histogram legend

The same options can be changed in the Horizontal axis. You can get to decide the minimum value and the maximum value of it easily here.

horizontal axis in histogram

You can do the same for the vertical axis, including to change the scale factor, adding log scale, change the number format.

vertical axis of histogram

At the very bottom, you can get to change the gridlines and the thickness. Here, you can customize the major spacing type, major count, minor spacing type, minor count, adding a major gridline, change the color, and more.

vertical axis in histogram

Besides the histogram chart, you can also customize or even remove the gridlines in your Google Sheets spreadsheet, either on-screen or on print.

Google Sheets allows you to add a histogram chart, making it easy to see the frequency distributions of things, which is beneficial for your business or organization’s performance or anything you’re working to gather data from.

Similar Posts

Leave a Reply

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