*62*

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 Excel and how to modify theÂ **bin width** so that the histogram looks exactly how youâ€™d like.

**Step 1: Create the Data**

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

**Step 2: Create the Histogram**

Next, weâ€™ll highlight the two columns of data:

Then weâ€™ll click the **INSERT** tab along the top ribbon, then weâ€™ll click the **Histogram** icon within the **Charts** section.

This creates the following histogram by default:

**Step 3: Adjust the Bin Width**

To adjust the bin width, right click the horizontal axis 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 beÂ **29,000.** We can change this to any number weâ€™d like.

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

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

We could also decrease the bin width toÂ **10,000:**

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

Feel free to modify the bin width to any value youâ€™d like and keep in mind the following rules of thumb:

**Increasing the bin width**often decreases the number of total 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 can find more Excel tutorials on this page.*