A histogram chart displays the count of items grouped into bins using columns.
Starting in Excel 2016, the histogram chart is a built-in option.
In this worksheet, I’ve got a list of 100 names and ages.
Let’s plot this data in a histogram chart.
To start out, select a cell in the data.
When you opt for chart, Excel will build a histogram chart automatically.
In some respects, the chart is similar to a regular column chart.
The vertical axis is a value axis, with a set of standard options.
However, there are limited options for formatting columns.
it’s possible for you to also select and format individual columns manually.
You’ll find most options for a histogram chart in the horizontal axis configs of the format task pane.
Under Bins, you’ll see the default setting is Automatic.
You’ll see greyed-out values for both bin width and bin count.
These will match what you see in the chart.
Here, bin size has been set to 12, and there are 6 bins total.
you’re free to manually adjust these tweaks.
it’s possible for you to also manually set overflow and underflow bins.
you could easily display the number of items in each bin with data labels.
Just turn these on using the Chart Elements menu.
While I’m here, I’ll also remove the gridlines to reduce clutter.
Histogram charts use a newer chart engine in Excel, and they still have some limitations.
For example, I can’t set the chart title with a formula.
All I get is an equal sign.
