Excel Histogram: Add Bins and Control Their Widths

Charts & pivot tables · Updated November 19, 2026

To add or change bins in an Excel histogram, select the chart’s horizontal axis, open Format Axis, and under Axis Options choose Bin width or Number of bins. You can also set an Overflow bin or Underflow bin to group values beyond a chosen limit. These settings are available for Excel’s built-in Histogram chart in Microsoft 365 for Windows.

What histogram bins do

A histogram groups numeric observations into adjoining ranges, then shows how many observations fall in each range. Each range is a bin. For example, a histogram of delivery times might group results into 0–10, 10–20, and 20–30 minute intervals. The height of each bar represents the number of observations in that interval, not an individual data point.

Choosing bins is part of interpreting the data, not just styling the chart. Narrow bins reveal finer variation but can make a chart look noisy; wider bins simplify the picture but may hide clusters or outliers. Excel initially chooses a bin arrangement automatically, so changing the bin settings can make the same data tell a clearer, more useful story.

A histogram is also different from a column chart. In a column chart, categories are usually separate labels, such as product names. In a histogram, the horizontal axis is divided into numeric ranges, and neighboring bars normally touch because the ranges are continuous.

Add a histogram in Excel for Windows

Start with a column of observations: for example, test scores, measured weights, response times, or order values. A header is useful, but keep the data cells numeric and avoid mixing notes or category labels into the observation range. Then create the chart:

  1. Select the numeric data, including its header if it has one.
  2. Choose Insert > Insert Statistic Chart > Histogram.
  3. Excel inserts a histogram using its automatic bin settings. Move or resize the chart as needed.
  4. To adjust the bins, right-click the horizontal axis labels and choose Format Axis.
  5. In the Format Axis pane, open Axis Options and find the Bins controls.

Make sure you select the axis labels rather than a bar. Selecting a bar opens formatting controls for the data series, which are not where the bin width and bin count are set. The pane can remain open while you select a different bin option, so you can compare arrangements without rebuilding the chart.

Set bin width or number of bins

Under Bins, Excel lets you work by width or by count. Choose Bin width when the interval size has a meaningful interpretation. For instance, a width of 10 groups exam scores into ten-point intervals. Choose Number of bins when you have a target number of bars and want Excel to divide the observed range accordingly. These are alternative ways to define the grouping; changing one can alter the other setting or the resulting intervals.

  • Bin width: Enter the numeric size of each interval. A width of 5 might suit measurements recorded to tenths, while a width of 100 might be sensible for a large currency-scale dataset.
  • Number of bins: Enter how many intervals to display. Excel calculates a suitable width from the data range and the requested count.
  • Automatic: Let Excel choose the arrangement. This is a convenient starting point, but it is not a universal rule for the best statistical presentation.

Suppose 200 recorded wait times range from about 2 to 58 minutes. A bin width of 10 produces intervals of roughly ten minutes across that range, making the chart easy to describe in everyday terms. Asking for six bins instead tells Excel how many groups to make; the resulting width depends on the spread of the observations. If the data range changes, the count-based intervals may change too.

Excel’s histogram uses bin boundaries to count values. In the usual displayed arrangement, a value on a cutoff is included in the bin that ends at that cutoff. For example, with a cutoff at 20, a value of exactly 20 is counted in the interval ending at 20. Check the axis labels when exact boundary treatment matters, especially if you are reporting a count as a formal result.

Use overflow and underflow bins

Overflow and underflow bins collect values at the extremes into a single group. In Format Axis > Axis Options > Bins, select Overflow bin and enter its threshold to group values above that limit. Select Underflow bin and enter a threshold to group values at or below that limit. For example, an overflow threshold of 100 can place every score above 100 into one final bar, while an underflow threshold can group unusually small measurements.

These controls are useful when a few extreme observations stretch the axis and leave most bars crowded together. They do not delete or exclude the extreme values: they gather them into an end bin. Make the threshold clear in the chart title, axis labels, or a note, because readers should know that the last bar represents a combined tail rather than a narrow interval like the others.

Do not use an overflow bin simply to make an inconvenient value disappear. If an extreme observation is an error, correct it at the source and document the correction. If it is a real observation, keeping it visible in a grouped end bin is often more transparent than silently omitting it.

Choose bins that answer the question

There is no single bin width that is best for every dataset. Start from the question the chart needs to answer and the precision that matters to the reader. A report comparing the number of calls handled per hour may benefit from whole-number intervals; a chart of manufacturing tolerances may need much narrower ranges. The bin width should suit both the scale of the data and the decisions someone will make from the chart.

  • Use a consistent width when readers need to compare the shape of distributions or compare charts built from similar measurements.
  • Avoid excessive detail when many bins contain zero or only one observation; this can make the overall pattern difficult to see.
  • Avoid overly broad bins when distinct clusters or a meaningful threshold could be hidden inside a single bar.
  • Keep the axis readable by using intervals that produce labels people can quickly understand.
  • Compare more than one reasonable setting before settling on a chart. A useful pattern should not depend entirely on an arbitrary choice of width.

For a concrete example, imagine a small set of quiz results clustered around 60–75, with a few scores near 30 and 95. Very wide bins might merge the central cluster and make the distribution look flat. Very narrow bins might create many empty spaces and overemphasize individual results. A moderate width can show the main cluster while still making the low and high scores visible. The chart is a summary, so inspect the underlying values as well when a particular observation matters.

Fix common histogram problems

If the chart option is unavailable or the result looks unexpected, check the source range and the selected chart type first. Excel’s built-in histogram is intended for numeric observations. Text labels in the data range, numbers stored as text, blank cells, or an accidentally included total can lead to confusing results. Clean the input range and make sure it contains the values you mean to analyze.

  • The chart has an unexpected bar: Check for a total, an outlier, or a value stored as text in the selected data.
  • There are too many or too few bars: Select the horizontal axis and adjust Bin width or Number of bins.
  • Most observations appear in one bar: Try a narrower width, but confirm that the resulting detail is meaningful.
  • The axis controls are missing: Confirm that the chart is a Histogram chart, then select its horizontal axis rather than a bar or the vertical axis.
  • The chart does not reflect changed data: Check that the chart’s source range includes the new rows. A chart based on a fixed range may not automatically include appended observations.

When the source values change, the chart may recalculate its bins, particularly if the axis uses automatic settings. That can be helpful for exploration, but it can complicate comparisons over time: a bar may represent a different interval in each chart. For a fair comparison between periods, use consistent bin boundaries and ranges, and verify that each chart uses them.

Histogram chart versus the Analysis ToolPak

The built-in Histogram chart is usually the simplest choice when you want a visual chart and adjustable axis bins. Another option is the Analysis ToolPak’s Histogram tool, which produces a frequency table based on a separate list of bin limits and can also create a chart. That approach is useful when you need explicit cutoffs or want the frequency results in worksheet cells for further analysis.

To use it on Windows, enable the add-in through File > Options > Add-ins. At the bottom, set Manage to Excel Add-ins, select Go, check Analysis ToolPak, and choose OK. Then open Data > Data Analysis > Histogram, specify the input range and the range containing your bin limits, choose an output location, and select the chart option if you want one.

ToolPak bin limits are not the same thing as typing a desired bar width into the chart axis. You provide the limits as worksheet values, and the output reports frequencies against those limits. This offers direct control but requires you to prepare and maintain the bin list. The built-in chart is more convenient for adjusting the visual grouping interactively.

In Excel for Mac, the Histogram chart is also available from the Insert tab’s statistical chart choices, though menu wording can vary by release. The Analysis ToolPak can be enabled through Tools > Excel Add-ins in versions that provide it. Excel for the web may show or permit basic chart edits, but if the bin controls are missing, open the workbook in the desktop app to use the full axis-formatting options.

Frequently Asked Questions

How do I add more bins to an Excel histogram?
Select the horizontal axis, choose Format Axis, and under Axis Options > Bins choose Number of bins. Enter a larger count. You can instead reduce the bin width to create more intervals.

Can I set exact bin ranges in an Excel histogram?
The built-in chart lets you set a width or number of bins, plus optional underflow and overflow thresholds. For a specific list of cutoffs, use the Analysis ToolPak Histogram tool and supply a worksheet range of bin limits.

Why can’t I see the bin settings?
They appear in the Format Axis pane when the chart is a Histogram and its horizontal axis is selected. A regular column chart does not expose the same histogram bin controls.

Can histogram bins have different widths?
The built-in Histogram chart is designed around a common bin width, with optional end bins for underflow and overflow. If you need uneven intervals, use a prepared frequency table and build a chart that represents those categories.

Does changing the bin width change the source data?
No. It changes how Excel groups the observations for the chart; it does not edit or remove the original values. The chart’s frequency pattern changes because values are counted in different ranges.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.