How To Change Bin Width In Excel 2016

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

This tutorial provides a footstep-by-step instance of how to create a histogram in Excel and how to modify thebin width so that the histogram looks exactly how yous'd like.

Step i: Create the Data

First, we'll create the following dataset that shows the annual income of 26 different people:

Footstep 2: Create the Histogram

Next, we'll highlight the two columns of data:

And then nosotros'll click the INSERT tab along the top ribbon, and then nosotros'll click the Histogram icon within the Charts section.

This creates the following histogram past default:

Step 3: Adjust the Bin Width

To conform the bin width, correct click the horizontal centrality on the histogram and then click Format Axis from the dropdown:

In the window that appears to the right, we can see that Excel chose the bin width to exist29,000. We can alter this to any number nosotros'd similar.

For example, we could increase the bin width to 50,000:

Change bin width in Excel

Discover how this increases the width of each bin and reduces the total number of bins.

We could too decrease the bin width toten,000:

Decrease bin width in Excel

This decreases the width of each bin and increases the total number of bins in the histogram.

Feel gratis to alter the bin width to any value you'd similar and keep in listen the following rules of thumb:

Increasing the bin width oft decreases the number of full bins in the histogram and leads to fatter and fewer bins.
Decreasing the bin width often increases the number of total bins in the histogram and leads to narrower and more bins.

You tin find more than Excel tutorials on this page.