Excel Histogram X-Axis Labels: Set Bins and Format

Charts & pivot tables · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, a histogram’s x-axis labels represent bins: ranges that group numeric values. Select the horizontal axis, right-click it, choose Format Axis, then use Axis Options to change the bin width or number of bins; use the Number section to adjust how the labels look.

What the histogram x-axis labels mean

A histogram is a chart for showing how often numeric values fall within ranges. Its horizontal axis displays those ranges, called bins, while its vertical axis displays the frequency—the number of observations in each bin. For example, a histogram of test scores might group results into ranges such as 0–9, 10–19, and 20–29. Each bar represents one range, and its height represents the number of scores in it.

This is different from a regular column chart, where the horizontal axis usually lists separate categories such as product names or months. In a histogram, Excel determines the ranges from the numeric data and the settings you choose. As a result, the labels are not simply text categories that you can edit one by one. To change what they communicate, adjust the bins, the number format, or—if you need fully controlled wording—build a separate summary table and chart it.

One detail can be confusing: depending on the chart and its settings, Excel may display bin limits in a compact form rather than spell out both ends of every interval. Read the axis alongside the bin width and the underlying data. If a label such as 10 appears, it may identify a boundary or limit in the bin sequence; it does not necessarily mean that the chart contains a category consisting only of the value 10.

Create a histogram and locate its labels

Start with one column of numeric observations, such as times, prices, ages, or scores. Include a clear heading if you want Excel to identify the series, and avoid mixing explanatory text into the values. Then create the chart in Excel for Microsoft 365 on Windows:

  1. Select the numeric data, including its heading if present.
  2. Choose Insert > Insert Statistic Chart > Histogram.
  3. Click the horizontal axis labels, then right-click and choose Format Axis.
  4. In the Format Axis pane, open Axis Options to find controls for the bins.

In current desktop Excel for Mac, the histogram is also available from the Insert tab’s statistical chart options, though ribbon wording and the layout of the formatting pane can vary between builds. Excel for the web may not expose every desktop chart-formatting control in the same place. If you cannot find the bin settings, open the workbook in the desktop app. The axis itself is the row of labels along the bottom of the chart; selecting a bar instead opens data-series settings rather than axis settings.

Change the bin width or number of bins

In Axis Options, Excel provides ways to control how the data is grouped. You can specify a bin width, which sets the size of each interval, or specify the number of bins, which divides the observed range into a chosen number of groups. These are alternative ways to control the grouping: a fixed width is useful when the intervals need to be meaningful, while a fixed bin count is convenient when you want a chosen level of detail.

  • Use Bin width when each interval should cover the same meaningful amount, such as 5 points or 10 minutes.
  • Use Number of bins when you want a particular number of bars and do not need a specific interval size.
  • Check the result after changing either setting. A very small width can create many sparse bars; a very large width can conceal variation.

For example, imagine a column of delivery times ranging from 4 to 58 minutes. A bin width of 10 groups the values into intervals about 10 minutes wide. Choosing 6 bins instead asks Excel to divide the data range into six groups; the resulting width is determined by the range and bin count. These settings change the grouping and therefore the bar heights, not just the appearance of the labels.

The best choice depends on what the chart should help a reader see. For a comparison over time or between groups, use consistent bin widths across charts. For a quick view of one dataset, try a few plausible settings and choose one that reveals its shape without producing a wall of narrow bars. Always keep the chosen bin rule clear when the chart supports a report or decision.

Use underflow and overflow bins

Axis Options can also provide an underflow bin and an overflow bin. An underflow bin collects values at or below a limit you set, and an overflow bin collects values above a limit. These options are useful when extreme values would otherwise stretch the scale and leave most bars crowded together. For instance, a chart of response times could group all values above a chosen threshold in one final bin to make the main range easier to inspect.

These controls affect which observations are grouped together, so they are not merely label-formatting choices. Check the resulting bars and make sure the endpoint bins are described accurately. If you report a chart to other people, mention that the first or last bar groups values beyond a threshold; readers should not mistake it for an ordinary interval of the same width as the others.

Format the appearance of axis labels

To improve readability without changing the bins, select the axis and use the Format Axis pane’s Number section to choose a suitable number format. Depending on the data, you may want fewer decimal places, a thousands separator, or a currency or date display. If Excel is following the source data’s formatting, the pane may offer a Linked to source option; clear it before applying a different axis format where that control is available.

Formatting the axis changes how its values are displayed, not the values used to create the bins. For example, reducing decimal places can make labels neater, but it does not convert a bin width of 2.5 into a width of 2. When labels are cramped, also consider making the chart wider, increasing its height, or reducing the axis-label font size. A chart with legible labels is more useful than one that forces every label into a narrow space.

If your values are dates, be careful about changing their number format. Excel stores dates as serial numbers, and a histogram groups the underlying numeric values. Formatting those values to look like dates does not change the underlying intervals or automatically create calendar-aware groups such as weeks or months. For calendar periods, you may need to prepare a summary table grouped by those periods and chart that table instead.

When you need custom text for every bin

The built-in histogram is convenient, but it is not designed for individually edited labels such as “Under 10,” “10 to 19,” and “20 or more.” For exact wording, create a table containing the labels and a count for each interval, then insert a regular column chart from that table. This also gives you more control over which boundary values belong to which group. Define the intervals so that they do not overlap and leave no unintended gaps.

For a simple example, suppose the observations are in A2:A9 and are 2, 4, 7, 9, 12, 13, 18, and 22. Put the lower bounds in F2:F4 as 0, 10, and 20, the upper bounds in G2:G4 as 10, 20, and 30, the display labels in D2:D4 as 0–<10, 10–<20, and 20–<30, and the counts in E2:E4. With those cell locations, enter this in E2 and fill it down through E4:

=COUNTIFS($A$2:$A$9,">="&F2,$A$2:$A$9,"<"&G2)

The first result is 4 because 2, 4, 7, and 9 are at least 0 and less than 10. The next two results are 3 and 1, so the table counts all eight observations. The labels use a lower-inclusive, upper-exclusive convention: 10 belongs in the second interval, not the first. This example’s upper bound of 30 is above the largest observation; if values can equal or exceed the final bound, extend the table or deliberately handle the last interval differently.

Select the adjacent label and count columns D:E, then choose Insert > Insert Column or Bar Chart and select a clustered column chart. To make it look more like a histogram, select a bar, open Format Data Series, and reduce Gap Width. Unlike the built-in histogram, this is an ordinary column chart: the table supplies its categories and counts. That trade-off is worthwhile when labels, interval rules, or counts must be explicit and repeatable.

Common label problems and how to fix them

  • The axis shows too many labels. Increase the bin width or reduce the number of bins, then check whether the chart still shows enough detail. A wider chart or smaller font can also help when the bin count is appropriate but the text is crowded.
  • The labels look like decimals or dates. Check the Number settings and the source values. Change the display format only if it represents the data honestly; date formatting does not turn raw numeric bins into calendar intervals.
  • The chart has unexpected gaps or few bars. Check for numbers stored as text, blank cells, stray entries, or values outside the range you expected. Confirm that the selected source column contains the observations rather than labels or a pre-counted summary.
  • The axis labels will not edit like category names. That is normal for the built-in histogram. Change the bin controls, or use a summary table and a regular column chart if each label needs custom text.
  • The bars do not match a hand count. Inspect the bin boundaries and the treatment of values at the edges. Make sure the hand count and the chart use the same intervals and endpoint rules; a value exactly on a boundary can change which bin receives it.

A related misconception is that changing an axis label’s number format changes the data or the bin calculation. It does not. Number formatting changes presentation; bin width, bin count, and endpoint settings change grouping. Keeping those two kinds of adjustments separate makes it easier to diagnose a chart that looks wrong.

Frequently Asked Questions

How do I change the x-axis labels on an Excel histogram? Right-click the horizontal axis and choose Format Axis. Use Axis Options to change the bin width, number of bins, or endpoint bins. For individually written labels, create a summary table and chart it as a regular column chart.

Can I type over one histogram label? Not in the same way you can edit a category label in a standard chart. Histogram labels come from the bin settings. If one particular interval needs custom wording, use a separate table and chart so the labels are categories you control.

How do I make Excel show fewer x-axis labels? Try a larger bin width or a smaller number of bins in Format Axis > Axis Options. If the grouping is already right, make the chart wider or reduce the label font size instead of changing the data intervals.

Can histogram bins have custom ranges? The built-in chart offers controls such as bin width and underflow or overflow limits, but it is not a general editor for an arbitrary list of interval labels. For uneven ranges or exact boundaries, calculate counts in a table and use a regular column chart.

Why are my histogram labels not showing the ranges I expected? The selected bin width or number of bins may differ from your intended grouping, or the axis may be displaying limits compactly. Open Axis Options, review the settings, and check which observations fall at each boundary. If precise range wording matters, make those intervals explicit in a custom summary table.

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.