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.
On the right side of your screen, simply select the Histogram chart as the Chart type. It is located in the Other section.
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.
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.
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.
To remove a series, you can simply click the vertical dots button and select Remove.
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.
Click Histogram. You would see options to add item dividers, change the bucket size, and outlier percentile as you’d like.
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.
In the Series, you can change the series and change the color.
In Legend, you can change the position of the legend, the font, font size, format, and color.
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.
You can do the same for the vertical axis, including to change the scale factor, adding log scale, change the number format.
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.
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.