Excel Histogram Bins: How to Set and Change Bin Width

Charts & pivot tables · Updated November 19, 2026

To set histogram bins in Excel for Microsoft 365 on Windows, select the histogram’s horizontal axis, right-click it, choose Format Axis, and use Axis Options to set Bin width or Number of bins. In the same pane, you can set an Underflow bin or Overflow bin to group values below or above a chosen limit.

What histogram bins do

A histogram groups numerical observations into ranges, called bins, and draws one bar for each range. The height of a bar represents how many observations fall into that interval. This makes it easier to see the distribution of a measurement—such as delivery times, test scores, or product weights—than by inspecting a long list of individual values.

Bin settings change the level of detail, not the underlying data. A small bin width creates more, narrower bars and can reveal local variation, but may make a chart look noisy. A large width produces fewer, broader bars and makes the overall shape easier to see, but can conceal clusters or unusual values. There is no universally correct width: it depends on the data, the question, and the audience.

Create a histogram chart

On Windows in Excel for Microsoft 365, arrange the measurements in one column, preferably with a descriptive heading and no mixed text entries in the data range. Then:

  1. Select the heading and numerical values, or select the values alone.
  2. Choose Insert > Insert Statistic Chart > Histogram.
  3. Click the horizontal axis, right-click, and choose Format Axis.
  4. In the Format Axis pane, expand Axis Options and choose the bin setting you want.

Excel initially chooses bins automatically. Review the result rather than assuming the automatic choice is appropriate. The chart is linked to its source data, so it normally updates when you change the values or adjust the axis settings. If you want the same bins in a report or in a comparison chart, record the settings and use them consistently.

Set bin width or number of bins

Bin width controls the size of each interval. For example, a width of 5 groups measurements into ranges five units wide. This is useful when the units have a natural meaning: five minutes for call duration, five dollars for transaction size, or five points for a score. Enter a positive number appropriate to the scale of your data. A width of 0.5 can make sense for measurements recorded in tenths; a width of 50 would not help if all values lie between 0 and 10.

Number of bins tells Excel how many intervals to use across the data range. Choose it when you want to control how many bars appear rather than specify a meaningful interval size. Excel derives the resulting widths from the data range and selected bin count, so the interval size may not be a convenient round number.

These are alternative ways to control the grouping. You generally choose one, not both: setting a bin width specifies the interval size, while setting the number of bins specifies the count of intervals. If the axis pane offers an automatic setting, returning to it lets Excel select the grouping again.

Choose a useful bin size

Start with the purpose of the chart. If readers need to interpret values in familiar increments, choose a width that matches those increments. If the goal is to inspect the overall shape, try a reasonable number of bars and compare the appearance with a slightly smaller or larger count. A histogram that changes dramatically after a small adjustment may be a sign that the dataset is small or that the pattern is not robust.

  • Consider the sample size. A few dozen observations rarely support dozens of meaningful bars; many observations can support more detail.
  • Use the measurement scale. Keep units visible in the axis title and choose intervals that make sense in those units.
  • Check important thresholds. If a decision turns on a value such as 30 minutes, make sure the binning does not obscure where observations fall relative to that threshold.
  • Compare a few settings. Look for patterns that persist across reasonable widths instead of selecting a setting solely because it produces a dramatic shape.

Two common starting points in statistics are Sturges’ rule, which estimates the bin count as roughly 1 + 3.322 times the base-10 logarithm of the number of observations, and the square-root rule, which uses roughly the square root of the sample size. These are guidelines, not Excel requirements or guarantees of an ideal chart. Excel’s automatic choice may differ, and domain knowledge can be more useful than either rule.

Use underflow and overflow bins

An Underflow bin collects values at or below a limit you specify into one group. An Overflow bin collects values above a specified limit into another group. These options are useful when the tails contain a few extreme measurements and you want the main range to remain readable. For example, a chart of response times might group all unusually long waits above a chosen cutoff together rather than devote several narrow bars to a handful of outliers.

These settings do not delete or correct extreme observations. They change how the histogram displays them. Choose cutoffs based on the question and label the chart so readers understand that the end bar combines a range of values. If exact outlier values matter, keep them visible in the data or show them in a separate table or chart.

Worked example: delivery times

Suppose column A contains 100 delivery times in minutes, from 3 to 58. A width of 10 is a sensible first trial if readers think in ten-minute increments. After creating the chart, select Format Axis and enter 10 for Bin width. Inspect the labels and bars: the purpose is to group deliveries by time range and see where most observations fall, not to imply that a boundary is a service target.

If the main question is how many deliveries took longer than 45 minutes, an overflow bin with a cutoff of 45 can make that tail easy to spot. But it also combines all values above the cutoff, so a bar containing 46-minute and 58-minute deliveries will not show their separate counts. If the exact count above 45 is needed, verify it independently from the source data or use a separate summary, rather than estimating it from a crowded chart.

For a fair comparison between two delivery teams, use the same bin width and limits on both distributions. If each chart uses a different automatic range, apparent differences may come from the settings rather than the delivery patterns. A combined chart can also help, provided the series and bar formatting remain legible.

Bin boundaries and custom intervals

In Excel’s histogram, ordinary bins are based on upper limits: a bin includes values up to its displayed limit, and the next bin covers values above the prior limit up to its own limit. The underflow and overflow controls likewise collect values on the lower or upper side of their specified cutoff. When observations sit exactly on a boundary, check the chart’s labels and grouping rather than assuming a boundary is handled like a category label.

The built-in chart is convenient when equal-width intervals are appropriate. It is less suitable when you need custom, uneven ranges such as 0–10, 10–25, and 25–100, or when each bar must correspond to specific business-defined bands. In that case, make a frequency table with the desired ranges and chart the resulting counts as a column chart. A standard histogram’s automatically generated axis bins are not a substitute for custom category definitions.

Common problems and fixes

  • The chart option is missing or disabled: Check that the selected source is numerical data. A histogram is for a distribution of numbers, not a list of names or dates stored as text. Select the measurements and try Insert > Insert Statistic Chart > Histogram again.
  • The bars look too crowded: Increase the bin width or reduce the number of bins. Then check whether meaningful clusters have disappeared.
  • The chart has one or two very tall bars: Review the range, units, and extreme values. A single unusually large value can stretch the scale and make most observations look compressed.
  • Counts seem wrong: Check for blanks, text-formatted numbers, accidental extra cells in the selected range, and values outside the range you expected. Also confirm whether an underflow or overflow bin is combining observations.
  • Axis settings are hard to find: Select the horizontal axis itself, not a bar or the chart area, and open Format Axis. In the pane, use Axis Options.

Dates can be treated as serial numbers in Excel, but a chart of raw dates may not produce the calendar grouping you want. For daily, weekly, or monthly reporting, create the desired date groups explicitly or use a PivotTable date grouping when that better fits the analysis.

Histogram versus other Excel charts

A histogram and a column chart can both show vertical bars, but they answer different questions. A histogram groups a continuous numerical variable into intervals, and the intervals follow a numerical order. A column chart compares named categories such as departments or product types. Use a column chart for pre-defined groups; use a histogram to explore how numerical observations are distributed.

A box-and-whisker chart is another option in Excel when the main goal is to compare medians, spread, and potential outliers across groups. It shows less detail about the shape of each distribution than a histogram. A histogram reveals the frequency pattern more directly, but can be sensitive to bin choices. For a careful analysis, the two chart types can complement each other.

Windows, Mac, and Excel for the web

The steps above use Excel for Microsoft 365 on Windows. Excel for Microsoft 365 on Mac also provides histogram charts; the available ribbon wording and the way the formatting pane opens can vary slightly by update. Look under Insert for the statistical chart options, then select the horizontal axis and open its formatting controls to set bins. A right-click or Control-click can open the axis context menu on Mac.

Excel for the web may present a different editing experience from the Windows desktop app, and not every chart-formatting control is exposed identically in every build. If you cannot find the bin width, bin count, or tail-bin settings in the browser, open the workbook in the desktop version of Excel and make the change there. The chart’s data and settings are part of the workbook.

Frequently Asked Questions

How do I change the bin width in an Excel histogram?

Select the horizontal axis, open Format Axis, expand Axis Options, and enter a positive value under Bin width. The value is measured in the same units as the data.

Should I set bin width or number of bins?

Use bin width when a meaningful interval size matters, such as ten minutes or five dollars. Use number of bins when you want to control the number of bars. Try a few reasonable settings and choose one that communicates the data without hiding useful structure.

Can I make histogram bins with different widths?

The built-in histogram chart is designed for regular bins, not arbitrary unequal intervals. For custom ranges, create a frequency table for those ranges and chart its counts, making the category labels clear.

Why does Excel ignore some values?

Check that the selected cells contain numeric values and that the chart’s source range includes them. Numbers stored as text, blank cells, or values outside the selected range can lead to unexpected results. Also inspect any underflow or overflow setting that may combine values into a tail bin.

Can I use a histogram for categories such as departments?

No. A histogram is intended for numerical measurements grouped into intervals. For named categories, use a column or bar chart so each category remains a distinct label.

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.