How to Make a Histogram in Excel With Custom Bins

Charts & pivot tables · Updated November 18, 2026

To make a histogram in Excel, select your numeric data, choose Insert > Insert Statistic Chart > Histogram, then right-click the horizontal axis and use Format Axis to set the bin width or number of bins. If you need specific, possibly uneven bin boundaries, use the Analysis ToolPak’s Histogram tool and provide a separate list of bin limits. Start with one column of clean numeric values; the steps below explain both methods and when to use each.

What You’ll Need

  • Microsoft Excel for Microsoft 365 on Windows. The built-in histogram chart is also available in many current Mac versions, though ribbon placement and pane layout can differ slightly.
  • A column of numeric observations, such as delivery times, test scores, or product measurements. Remove or correct text values and decide whether blanks should be excluded.
  • If you want exact custom limits, such as 0–10, 10–25, and 25–50, the Analysis ToolPak add-in. It is included with desktop Excel but may need to be enabled.

You do not need to calculate frequencies yourself for the built-in chart. Excel counts observations in each bin. For precise reporting, keep a copy of the original data and note how you chose the bin boundaries so someone else can interpret the chart.

Step-by-Step

  1. Prepare the observations. Put one value per row in a single column, with an optional heading in the first row, for example Measurement in A1 and measurements in A2:A101. A histogram needs quantitative values that can be grouped along a number scale. Remove explanatory notes from the middle of the list, check for numbers stored as text, and decide what to do with blanks. Do not include a totals row or unrelated columns in the selection. If the data includes an error such as #N/A, fix or exclude it before making the chart.
  2. Choose a sensible grouping before charting. The bin width is the size of each interval; the number of bins is how many intervals Excel uses. For example, if a set of delivery times runs from about 12 to 20 minutes, a width of 2 minutes might make the overall pattern easy to see. A very small width can produce many nearly empty bars, while a very large width can hide meaningful variation. There is no universally correct width: pick one that suits the measurement scale and the question you are trying to answer.
  3. Select the data and insert a histogram. Select the numeric cells, including the header only if you want Excel to use it as a series label. On the Windows ribbon, choose Insert > Insert Statistic Chart > Histogram. Excel creates a chart with adjacent bars and groups the observations into automatic bins. If you selected a header, Excel may use it for the chart’s series name. If the chart looks wrong, check that the selection contains only the one measurement column and that Excel recognized its entries as numbers.
  4. Open the bin controls. Right-click a number on the horizontal axis and choose Format Axis. In the Format Axis pane, open Axis Options and find the Bins controls. Depending on your Excel build and pane width, you may need to expand the section or scroll. The controls let you set a Bin width or a Number of bins. Choose one setting to control the grouping; changing the width changes how broad each interval is, while changing the count tells Excel how many intervals to create.
  5. Set the bin width or bin count. To make intervals with a meaningful unit, choose Bin width and enter a positive number. For times recorded in minutes, enter a width in minutes; for whole-number scores, choose a width that makes sense for the score range. To control the approximate detail instead, choose Number of bins and enter a positive whole number. Review the resulting chart after changing the setting. Excel may adjust the first or last interval to cover the data range, so check the axis labels rather than assuming the bars begin at a particular value.
  6. Set optional end bins when needed. In the same Axis Options area, you can enable an Underflow bin or Overflow bin and specify a boundary. These options group values below or above the chosen cutoff into an end category, which can make a long tail easier to read. Use them only when that grouping is useful for your analysis; they can conceal how far individual values lie beyond the cutoff. Explain the cutoff in the chart title, axis label, or a nearby note if readers need to know what the end bar represents.
  7. Make the chart readable. Select the chart, then use the Chart Design and Format tabs to adjust its appearance. Add a descriptive chart title, such as Delivery times in minutes, and label the horizontal axis with the measurement and unit. The vertical axis shows frequency, or the number of observations in each bin. Keep the bars adjacent: gaps between bars can make a histogram look like a category column chart. If you want to show the count on each bar, use the chart’s data-label options, but avoid labels if they overlap or make a dense chart difficult to read.
  8. Use exact custom boundaries with the Analysis ToolPak. A standard histogram chart uses equal-width bins; it is not the right tool for specifying a different width for each interval. For exact boundaries, create a separate column of upper limits in ascending order, such as 10, 25, and 50. Enable the add-in if necessary: choose File > Options > Add-ins, select Excel Add-ins in the Manage box, choose Go, check Analysis ToolPak, and select OK. Then choose Data > Data Analysis > Histogram. Set Input Range to the numeric observations and Bin Range to the cells containing your upper limits. Check Labels only if the selected ranges include headings. Choose an Output Range or New Worksheet Ply, and optionally select Chart Output, then select OK.
  9. Check the ToolPak output and explain its intervals. The ToolPak returns a frequency table for the limits you supplied, and can create a chart if you selected Chart Output. Its listed bin values act as upper limits: each frequency counts values above the preceding limit and up to the current limit, with the first category covering values up to the first limit. Values above the last limit are reported in an additional More category. Confirm that the output includes all observations and that the boundaries match your intended intervals. Add a clear title and labels to the chart, because the frequency output may not communicate the measurement units or purpose by itself.

On a Mac, the histogram chart is typically under Insert > Statistic Chart > Histogram; wording and placement can vary by Excel release. The Analysis ToolPak is managed through Tools > Excel Add-ins, then selected from Data > Data Analysis if available. Excel for the web may not expose the same ToolPak controls or full axis-formatting options. If you cannot find a setting there, open the workbook in desktop Excel for the relevant controls.

Common Mistakes

  • Choosing bins that obscure the pattern. Too many narrow bins make the chart noisy; too few make distinct clusters look like one broad mound. Compare a couple of reasonable widths and keep the version that best answers the question. Do not change the bin width just to make a result look more favorable.
  • Using text or mixed units as measurements. Entries such as 12 minutes, a dash, or a number stored as text may not be treated as numeric data. Keep the values numeric and put units in the column heading. Do not combine measurements in different units, such as centimetres and inches, without converting them first.
  • Expecting irregular intervals from the chart’s Bin width setting. That setting makes equal-width bins. If your analysis needs unequal limits, use the ToolPak with an ordered bin-range column, or another explicitly constructed frequency table. Do not assume that typing a list of boundaries into the chart’s width box will create custom intervals.
  • Leaving out values by accident. A selection that stops early, includes a totals row, or omits a second part of the data will change the frequencies. Check the source range and compare the sum of the frequency counts with the number of valid observations you intended to include.
  • Reading bars as categories rather than intervals. A bar represents a range of numeric values, not one individual value. The height is a count unless you deliberately use a different output or chart. Label axes so readers do not mistake frequency for a percentage or measurement.

Tips

  • Start with a question. To find a typical range, a broader bin may be sufficient. To spot outliers or multiple clusters, use more detail. The right grouping depends on whether you are exploring, comparing, or reporting the data.
  • Use consistent bins for comparisons. When comparing two groups, use the same boundaries and scale for both. Separate charts with different bin widths can suggest differences that come from the settings rather than the underlying data.
  • Keep the source data intact. Make a separate cleaned-data column or copy when you need to exclude invalid records. That preserves the original values and makes it easier to review what changed.
  • Make the unit visible. If the observations are seconds, dollars, or kilograms, say so in the axis title or chart title. A bin width of 5 has no useful meaning without the unit.
  • Document the limits. For a report, record the width or the custom upper limits and explain any overflow grouping. This helps readers reproduce the chart and understand the size of each interval.

Troubleshooting

The Histogram option is missing. Confirm that you are using a desktop version of Excel with the data selected, then look under Insert > Insert Statistic Chart. If you are in Excel for the web or using an older release, the chart option or its formatting controls may differ. Open the file in Microsoft 365 desktop Excel if needed.

The chart has one bar, or no useful bins. Check that the selected cells contain several numeric observations rather than a single summarized value. Look for numbers stored as text: select the cells and use Excel’s warning indicator or convert them to numbers. Then reopen Format Axis and set a useful width or bin count. A column containing the same repeated value will naturally have little spread.

Excel includes a heading as a data value. Edit the source selection so the header is excluded, or include it consistently and check that Excel recognizes it as a label. If you inserted the chart with the wrong range, select the chart and use Chart Design > Select Data to review the source, or delete the chart and recreate it with the correct selection.

The ToolPak command is not on the Data tab. Enable Analysis ToolPak using File > Options > Add-ins, choose Excel Add-ins in Manage, select Go, check the add-in, and select OK. If it is already enabled, close and reopen the dialog or Excel. On Mac, enable it through Tools > Excel Add-ins. In a managed work environment, an administrator may control which add-ins are available.

The frequency total does not match the data count. Check for blank cells, errors, text values, or a wrong Input Range. In the ToolPak, make sure Bin Range contains ascending numeric limits and that Labels is checked only when the range actually includes a heading. Values above the largest limit appear in the More category; include that category when checking the total. If a value is below the first limit, remember that the first bin covers values up to its limit.

Frequently Asked Questions

What is a bin in an Excel histogram?
A bin is an interval of numeric values. Excel counts how many observations fall into each interval and displays each count as a bar. For example, a bin width of 5 groups values into intervals that are five units wide, though the displayed endpoints depend on the chart’s scale.

Can I enter custom bin ranges in an Excel histogram chart?
You can set an equal bin width or a number of bins in the built-in histogram chart, but you cannot define a separate, uneven width for every bin there. Use Data > Data Analysis > Histogram and a column of upper limits for exact custom boundaries.

How do I change the number of bins?
Right-click the horizontal axis, choose Format Axis, expand Axis Options, and enter a value under Number of bins. If you need a particular interval size instead, use Bin width. The result may look different when the source data range changes.

How do I show percentages instead of counts?
The built-in histogram chart’s vertical axis represents frequency, or count. For a percentage distribution, calculate each bin’s count as a share of the total in a separate frequency table, then chart those percentages. Label the vertical axis as a percentage and ensure the chart uses consistent bin boundaries.

Does a histogram update when I change the source data?
A built-in chart generally reflects changes to its source range, but a newly added row may not be included if it falls outside that range. Convert the source list to an Excel table with Insert > Table, or review the chart’s source selection after adding observations. ToolPak output is a generated frequency table, so rerun the Histogram analysis when the underlying values change.

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.