Excel Histogram Axis Labels: Set Bins and Fix Issues

Charts & pivot tables · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, histogram axis labels are controlled by the chart’s bin settings: select the horizontal axis, open Format Axis, then adjust the bin width or number of bins. To change the label appearance, use the axis number-format options; to use completely custom wording, build a frequency table and chart it as a column chart.

What Excel histogram axis labels show

A histogram groups numeric observations into intervals, called bins, and displays the number of observations in each interval. Its horizontal axis therefore represents ranges of values, rather than a separate category for every row in your source data. The vertical axis normally represents the frequency, or count, in each range.

For example, a histogram of delivery times might group observations into intervals such as 0–5 minutes, 5–10 minutes, and 10–15 minutes. The bar height shows how many deliveries fall into each interval. Excel generates the intervals and their labels from the chart’s bin settings, so labels can change when you change the bin width, bin count, or data.

This distinction matters when a chart looks like a column chart but does not behave like one. A column chart usually treats each horizontal-axis label as a discrete category. A histogram uses numerical intervals. If your source data contains names such as “North,” “South,” and “West,” a histogram is not the appropriate chart type; use a column or bar chart instead.

Change the histogram’s bins and labels

To adjust the intervals that appear along the horizontal axis in Excel for Microsoft 365 on Windows:

  1. Select the histogram chart, then click one of the horizontal-axis labels.
  2. Right-click the selected axis and choose Format Axis. The Format Axis pane opens.
  3. In Axis Options, find the bin controls. Choose a specific Bin width or set the Number of bins.
  4. If needed, set an Overflow bin or Underflow bin to group values beyond a chosen limit.
  5. Review the chart after each change. The axis labels and the number of bars should update to reflect the new intervals.

Bin width specifies the size of each interval. If a bin width of 10 is used for measurements from 0 to 50, the chart will generally group them into intervals of about 10 units each. Number of bins instead specifies how many groups Excel should use across the data range; the resulting interval width depends on that range. These controls are alternatives for shaping the distribution, not two independent ways to set the same exact boundaries.

An underflow or overflow bin is useful when extreme values would otherwise create awkward extra intervals. For example, an overflow bin can collect all values above a selected threshold into a final group. The chart’s labels may then show a threshold-style group rather than a regular interval. Consider whether that grouping is meaningful: combining every unusually high value can hide important differences among those observations.

Choose a useful bin width

There is no single best bin width for every dataset. Narrow bins reveal small changes in the distribution but can leave many bars empty or make the chart look noisy. Wide bins create a simpler summary but may conceal clusters, gaps, or outliers. A useful choice depends on the number of observations, the measurement scale, and what you want a reader to notice.

  • Start with the units. For whole-number ages, a width of one year may be too detailed for a large population summary; five- or ten-year groups may be easier to interpret.
  • Compare a few plausible widths. Try two or three settings and check whether the overall shape changes substantially.
  • Keep comparisons consistent. If you compare two groups, use the same bin boundaries for both. Different widths can make similar distributions look different.
  • Check the sample size. A small dataset cannot support a very detailed shape; several narrow bins may contain only one or two records.

For example, a chart of 500 exam scores from 0 to 100 could use a width of 10 for a broad overview. A width of 2 might be helpful when investigating score clusters, but it would also produce many more bars. The most defensible setting is the one that makes the pattern readable without implying more precision than the data supports.

Format the labels without changing the bins

Sometimes the intervals are right but the labels look untidy. If the axis shows too many decimal places, select the horizontal axis, open Format Axis, expand the Number section, and choose a suitable number format or decimal-place setting. A measurement recorded to one decimal place usually does not need labels showing several extra decimal places.

Number formatting changes how values are displayed, not the underlying observations or bin boundaries. It can make labels shorter and easier to scan, but it does not let you replace Excel’s generated interval labels with arbitrary text. For units such as minutes, kilograms, or dollars, consider adding the unit in an axis title or chart title rather than forcing long unit text into every bin label.

Axis titles are different from axis labels. To add a title such as “Time in minutes,” select the chart and use Chart Design > Add Chart Element > Axis Titles, then choose the horizontal or vertical title. A title explains what the axis measures; the tick labels identify the intervals or values along it.

Horizontal labels and vertical labels are different

Readers sometimes say “histogram axis labels” when they mean either axis. The horizontal axis labels identify the bins. The vertical axis labels show the frequency scale, often counts such as 0, 5, 10, and 15. If the bars are correct but the numbers beside them are missing or difficult to read, format the vertical axis instead of changing the bins.

To change the vertical scale, select its labels and open Format Axis. Depending on the chart and data, the pane provides settings for bounds, units, and number formatting. For example, setting an appropriate major unit can make a count axis easier to read. Avoid setting bounds that crop off bars or make a small difference appear much larger than it is.

Data labels are another separate feature. They display values on or near the bars, such as the count in each bin. They do not replace the horizontal-axis intervals. If you add them, check that the chart remains readable, especially when there are many bins.

Use custom labels with a frequency table

If you need precise wording such as “Under 10,” “10 to under 20,” and “20 to under 30,” the built-in histogram may not provide the exact label text you want. One practical alternative is to create a table of interval labels and counts, then make a regular column chart. This gives you direct control over the category names and boundaries.

For a concrete example, assume the ten measurements are in A2:A11 and are 4, 7, 9, 12, 14, 17, 19, 22, 24, and 27. Put lower boundaries 0, 10, and 20 in C1:C3, and upper boundaries 10, 20, and 30 in D1:D3. Put the interval labels you want in B1:B3. With the first interval defined as greater than 0 and less than or equal to 10, enter this formula in E1 and copy it down through E3:

=COUNTIFS($A$2:$A$11,">"&C1,$A$2:$A$11,"<="&D1)

The formula returns 3 for the first interval (4, 7, and 9), 4 for the second (12, 14, 17, and 19), and 3 for the third (22, 24, and 27). Select B1:B3 and E1:E3, then choose Insert > Insert Column or Bar Chart > 2-D Clustered Column. Set the series’ gap width to 0% in Format Data Series > Series Options if you want the bars to touch like a conventional histogram.

The example deliberately uses intervals that exclude the lower boundary and include the upper boundary. Make the labels communicate the same rule, such as “Over 0 to 10,” rather than an ambiguous “0–10.” If your data can include zero or negative values, adjust the first lower boundary and criteria so those values are counted. Check that every observation belongs to exactly one interval and that the total of the frequency counts equals the number of observations you intended to include.

Common label problems and what to check

  • The labels look like individual numbers rather than ranges. Confirm that the selected chart is a histogram, not a regular column chart. A column chart uses category labels from the source range.
  • There are too many bars or labels. Increase the bin width or reduce the number of bins in Format Axis. Also check whether a few extreme values are stretching the range.
  • Some labels appear crowded. Use fewer bins, a shorter number format, or a wider chart. Rotating or shrinking text may help, but it should not make the labels hard to read.
  • Values seem to be missing. Check that the source cells contain numbers, not numbers stored as text, and inspect blanks or unexpected entries. Review underflow and overflow settings to see whether extreme values have been grouped.
  • Labels change after editing the data. The histogram recalculates its bins from its data and settings. If exact boundaries must stay fixed for comparisons, explicitly set the bin width or use a frequency table with fixed boundaries.

Also verify the source range. A heading included as a data value, a stray value far outside the expected range, or a pasted text entry can make the chart misleading. Correcting the source is preferable to adjusting the axis to disguise a data-quality issue.

Histogram versus a column chart

Choose a histogram when the horizontal scale is numeric and the goal is to show how many observations fall within value ranges. Choose a column chart when each bar represents a named category, such as a department or product. Although both use vertical bars, their horizontal axes have different meanings.

The built-in histogram is convenient because Excel calculates frequencies and draws the interval chart for you. A frequency table plus a column chart takes more setup, but it is a better fit when the interval boundaries must be fixed, the labels need custom text, or you want to show calculated percentages instead of counts. Whichever method you use, state the units and make the interval boundaries clear.

Frequently Asked Questions

How do I change the x-axis labels in an Excel histogram?
Select the horizontal-axis labels, right-click, choose Format Axis, and adjust the bin width or number of bins under Axis Options. These settings change the intervals that Excel labels.

Can I type over a histogram axis label?
Not as you would edit a cell or an ordinary category-axis label. The built-in histogram generates its interval labels from the bins. For exact custom wording, create a frequency table and use its labels in a column chart.

How do I show fewer labels on a histogram?
Use fewer bins by increasing the bin width or reducing the number of bins. If the issue is crowded text rather than too many intervals, shorten the number format or make the chart wider.

Why does my histogram show unexpected bins?
Check the source values, including numbers stored as text and extreme values, then review the bin width, number of bins, and underflow or overflow settings. A single unusually large or small value can affect the displayed range.

Can I add units to histogram labels?
You can format numeric labels and add an axis title that states the unit, such as “Weight in kilograms.” For a different phrase on every interval, use custom labels in a frequency-table-based column chart.

Are the steps different on Mac or Excel for the web?
The same general approach applies: select the histogram axis and open its formatting pane. On Mac, use a secondary click if needed to access Format Axis; ribbon and pane wording can vary slightly by release. Excel for the web may offer fewer chart-formatting controls than the desktop app, so use Excel for Microsoft 365 on Windows or Mac if a particular bin option is unavailable.

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.