6.2 C
London
Thursday, December 19, 2024
HomeSoftware TutorialsGoogle SheetsGoogle Sheets: How to Change Number of Bins in Histogram

Google Sheets: How to Change Number of Bins in Histogram

Related stories

Learn About Opening an Automobile Repair Shop in India

Starting a car repair shop is quite a good...

Unlocking the Power: Embracing the Benefits of Tax-Free Investing

  Unlocking the Power: Embracing the Benefits of Tax-Free Investing For...

Income Splitting in Canada for 2023

  Income Splitting in Canada for 2023 The federal government’s expanded...

Can I Deduct Home Office Expenses on my Tax Return 2023?

Can I Deduct Home Office Expenses on my Tax...

Canadian Tax – Personal Tax Deadline 2022

  Canadian Tax – Personal Tax Deadline 2022 Resources and Tools...

A histogram is a plot that can be used to quickly visualize the distribution of values in a dataset.

This tutorial provides a step-by-step example of how to create a histogram in Google Sheets and how to modify the number of bins so that the histogram looks exactly how you’d like.

Step 1: Create the Data

First, let’s create the following dataset:

Step 2: Create the Histogram

Next, highlight the cells in the range A2:A21, then click the Insert tab, then click Chart:

In the Chart editor panel that appears on the right side of the screen, click the dropdown arrow under Chart type and choose Histogram chart:

The following histogram will appear:

Step 3: Adjust the Number of Bins

To adjust the number of bins in the histogram, click the Customize tab within the Chart editor panel, then click the dropdown arrow next to Histogram.

Click the dropdown arrow under Bucket size to bring up a list of potential bucket sizes you can use:

If we click 2, then this will change the bucket size to 2 in the histogram:

The first bucket tells us how many values in the original dataset are greater than or equal to 2 but less than 4.

The second bucket tells us how many values in the original dataset are greater than or equal to 4 but less than 6.

And so on.

If we instead choose a bucket size of 10, the buckets will have a width of 10:

Feel free to modify the number of bins to whatever value you’d like and keep in mind the following rules of thumb:

  • Increasing the bucket size decreases the number of total bins in the histogram and leads to fatter and fewer bins.
  • Decreasing the bucket size increases the number of total bins in the histogram and leads to narrower and more bins.

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

How to Create a Bubble Chart in Google Sheets
How to Create a Pie Chart in Google Sheets
How to Create a Cumulative Sum Chart in Google Sheets

Subscribe

- Never miss a story with notifications

- Gain full access to our premium content

- Browse free from up to 5 devices at once

Latest stories