Excel Histogram Overflow Bin: Set and Interpret It

Charts & pivot tables · Updated November 21, 2026

In an Excel histogram, the overflow bin groups values above a cutoff you choose into one final bar. To set it in Microsoft 365 for Windows, select the histogram’s horizontal axis, open Format Axis, and under Axis Options select Overflow bin and enter the cutoff.

What the overflow bin means

A histogram divides numeric observations into ranges, called bins, and shows how many observations fall in each range. The overflow bin is a special last range: instead of continuing to display separate ranges above a chosen threshold, Excel collects the values above that threshold in one bar. It is useful when the upper end of a data set stretches a chart or when the main question is simply how many observations exceed a meaningful limit.

For example, if a list contains delivery times in minutes and you set the overflow cutoff to 60, the final bar represents delivery times above 60 minutes. It does not change the underlying values or remove them from the worksheet; it changes how the histogram groups and displays them. The cutoff is a value in the same units as the data, not a bin number or a worksheet cell reference.

An overflow bin is not the same as an error category or an Excel worksheet feature called an overflow cell. It is an option in the formatting settings for a Histogram chart. The chart is still based on the original numeric observations, and Excel recalculates the grouped counts when the source data or bin settings change.

Create a histogram before setting the cutoff

If you do not already have a histogram, place the observations in one column with a clear heading, then select the data. In Excel for Microsoft 365 on Windows, choose Insert > Insert Statistic Chart > Histogram. Excel creates a chart with an automatic bin arrangement. You can change that arrangement afterward; you do not need to calculate the counts by hand first.

Check the selected range before inserting the chart. Include the numeric observations and, if present, their heading, but avoid selecting unrelated columns or summary totals. A total included as if it were an observation can create a misleadingly large bar. A histogram is intended for individual numeric data points, such as one test score per student or one measurement per product.

  • Use consistent units throughout the source column, such as minutes rather than a mixture of minutes and hours.
  • Keep explanatory notes and category labels in separate columns. Text is not a numeric observation for a standard histogram.
  • Remove or investigate error values before interpreting the chart, and confirm that blank cells are genuinely missing observations rather than values that should have been entered as zero.

In Excel for Mac, the Insert tab also provides a Histogram chart under the statistical chart options, though the exact appearance of the ribbon and formatting pane can vary by release. Excel for the web may offer different chart creation and formatting controls; if the overflow setting is unavailable in the web interface, open the workbook in the desktop app to change it.

Set the overflow bin in Excel

With a Histogram chart selected, use the horizontal value axis—the axis that displays bin labels—to open its formatting options. On Windows, right-click that axis and choose Format Axis. In the Format Axis pane, open Axis Options, find the Bins section, select Overflow bin, and type the cutoff value in the box that appears. The chart should update to show a final bar for values above the cutoff.

  1. Click the chart, then click the horizontal axis labels to select the axis rather than the bars or chart area.
  2. Right-click the selected axis and choose Format Axis. If the pane does not show axis options, check that the axis itself is selected.
  3. In Axis Options, expand Bins if necessary. Select Overflow bin and enter the threshold, such as 60 for a measurement recorded in minutes.
  4. Review the final bar and the other bin labels. Check that the displayed grouping makes sense for the question the chart is supposed to answer.

You can also select the axis and use the chart formatting controls to open the Format Axis pane; right-clicking is usually the most direct route. To turn the feature off, clear the Overflow bin checkbox. Excel then returns to its ordinary bin arrangement, which may be automatic or may use other bin settings you have selected.

Choose a useful cutoff

A good overflow threshold comes from the purpose of the chart, not just from a desire to make the bars look tidy. It might be a service target, a product limit, a clinically or operationally defined boundary, or a round value that makes the distribution easier to read. The cutoff should still leave enough detail below it to answer the question you care about.

Consider a list of 500 customer wait times ranging from 2 to 110 minutes. If the practical question is how many customers waited longer than an hour, setting the overflow cutoff to 60 gives the chart a clear tail bar. If the goal is to compare the shape of the distribution between 50 and 90 minutes, however, grouping everything above 60 would hide too much variation. A higher cutoff or narrower ordinary bins might be more suitable.

  • Use a threshold readers can interpret. Include the unit in the chart title or axis title when the unit is not obvious.
  • Check how many observations fall into the overflow bin. A very large final bar may mean the cutoff is too low for the question being asked.
  • Check whether the cutoff is meaningful across groups when comparing charts. Different thresholds can make two distributions appear more alike or different than they are.
  • Keep the threshold documented in a subtitle, note, or accompanying text if readers may otherwise assume the last bar has the same width as the others.

There is no universally best cutoff. A threshold chosen to flag unusually high values is different from one chosen to summarize a policy limit. Be explicit about which interpretation applies, particularly if readers might treat the final bar as a count of outliers. Values above a chosen threshold are not automatically statistical outliers; that depends on the analysis and the definition being used.

Worked example: delivery times

Suppose the source data has one delivery time, in minutes, in each row, and you create a histogram. You choose an overflow threshold of 60 because the service team wants to see how many deliveries took longer than an hour. The chart’s final bar collects the observations above the cutoff; the bars below it continue to show the distribution in their existing ranges.

If the final bar contains 18 observations, the chart indicates that 18 recorded deliveries were above the overflow threshold, assuming the source range contains only the intended delivery times and the chart has refreshed. It does not tell you how far above 60 those deliveries were. To answer that follow-up, inspect the source records, use a worksheet filter, or create a separate analysis of the high values.

Be careful with values exactly at the cutoff. Excel describes the overflow group as values above the threshold, while the bin ending at the threshold accounts for values in the ordinary bins up to that point. If the treatment of a boundary value matters to a report, include a few test values around the cutoff in a temporary chart or verify the counts against the source data. This is especially worthwhile when the data has many repeated values at precisely the threshold.

Overflow bin versus other bin settings

The overflow option is one of several ways to control a Histogram chart. Excel can also group the low end with an underflow bin, set a bin width, or specify the number of bins. These options solve different problems, and changing one may affect the appearance of the others.

  • Overflow bin: combines values above a specified upper threshold in the final bar.
  • Underflow bin: combines values below a specified lower threshold in the first bar. It can help when very small values are not the focus.
  • Bin width: sets the span of each ordinary bin, such as intervals of 10 minutes. This controls the chart’s level of detail.
  • Number of bins: asks Excel to divide the data into a chosen number of ranges. The resulting widths depend on the data range.

Bin width and number of bins are alternative ways to shape the ordinary ranges; they are not the same as an overflow cutoff. For example, setting a width of 10 does not mean that all values above 60 will be combined. Use the overflow setting when you specifically need a top-end catch-all, and use width or bin count when you want to change how the main body of the data is divided.

Common problems and how to check them

If you cannot find Overflow bin, first make sure the chart is a Histogram chart rather than a column chart that merely looks similar. Then select the horizontal axis, not the bars, legend, or vertical count axis. The relevant Bins controls appear in the Format Axis pane for a histogram. If the chart is selected but the pane shows options for a data series, click the horizontal labels and reopen Format Axis.

If the chart appears unchanged after entering a threshold, check that your cutoff is actually below some of the observations. When every value is below the threshold, the overflow bar may be empty or not visually apparent. If every value is above it, the final group may dominate. Also check that the source range includes the full data set and not just part of the column.

  • The bar is unexpectedly large: verify the cutoff, units, and source range. A value entered as 60 is not equivalent to 60 seconds if the data is in minutes.
  • The chart does not match a manual count: check the boundary values, blanks, text entries, errors, and whether the chart includes a heading or unrelated numbers.
  • Labels are hard to read: widen the chart, simplify the number format, or adjust the bin width. Do not change the cutoff just to conceal a labeling issue.
  • The chart seems stale: confirm that the source range includes new rows. Depending on how the range was created, added records may not automatically become part of the chart’s source.

For a high-stakes report, verify the final count independently. Filter the source data to values above the chosen threshold and compare the resulting number of records with the overflow bar. This simple check can reveal a wrong source range, a unit mismatch, or an assumption about the cutoff that needs clarification.

Reading and sharing the result

Explain what the final bar means wherever you share the chart. A label such as More than 60 minutes or Above 60 minutes is clearer than a bare number, particularly for readers who may not inspect the axis settings. Excel’s automatic bin labels may not fully communicate the overflow rule, so a descriptive chart title, axis title, or note can prevent confusion.

Remember that the overflow bar conceals the individual spread of values above the cutoff. Two data sets could have the same overflow count even if one has values just above the threshold and the other has extremely high values. If that difference matters, pair the histogram with a summary such as the maximum, a percentile, or a separate view of the upper tail. Do not infer the size or severity of high observations from the overflow bar’s height alone.

When comparing charts, keep the cutoff and the ordinary bin settings consistent. Otherwise, apparent differences may come from chart configuration rather than from the data. State the threshold, units, and observation period in a caption or nearby text so another person can reproduce the interpretation.

Frequently Asked Questions

What does Overflow bin mean in an Excel histogram?
It is the final histogram group for values above a cutoff that you specify. It combines those high values into one bar instead of showing further separate bins above the threshold.

How do I add an overflow bin in Excel?
Select the histogram’s horizontal axis, right-click and choose Format Axis, then open Axis Options > Bins. Select Overflow bin and enter the cutoff value.

Can I use both an overflow bin and an underflow bin?
Yes. They address opposite ends of the data: an underflow bin groups values below a lower cutoff, while an overflow bin groups values above an upper cutoff. Use them when both tails need to be summarized.

Does an overflow bin delete or alter the high values?
No. It changes only the chart’s grouping. The original observations remain in the worksheet and can still be inspected, filtered, or analyzed separately.

Why is my overflow bar empty?
Usually no observations exceed the threshold you entered, or the cutoff is higher than the largest value. Confirm the data range and units, then check whether any source values are actually above the cutoff.

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.