Frequency Histogram in Excel: Create and Interpret One

Charts & pivot tables · Updated November 21, 2026

To make a frequency histogram in Excel for Microsoft 365 on Windows, select your numeric data, then choose Insert > Insert Statistic Chart > Histogram. Excel groups the values into intervals, or bins, and shows how many observations fall in each one; you can adjust the bin settings to make the distribution easier to read.

What a frequency histogram shows

A frequency histogram summarizes the distribution of numerical data. The horizontal axis represents ranges of values, called bins, and the vertical axis shows the frequency: the number of observations in each range. For example, a histogram of delivery times might show how many deliveries took 0–9 minutes, 10–19 minutes, 20–29 minutes, and so on.

Because neighboring bins represent consecutive parts of a numerical scale, histogram bars usually touch. That distinguishes a histogram from a typical column chart, where each bar represents a separate category such as a department or product. A histogram can help reveal a concentration of values, a long tail, multiple clusters, or unusually distant observations. It does not, by itself, explain why the pattern exists or prove that the data came from a particular process.

In Excel, “frequency histogram” can refer either to the chart or to the frequency counts used to build it. The built-in Histogram chart is usually the quickest route. A frequency table made with the FREQUENCY function is useful when you need to see, reuse, or report the counts behind the chart.

Prepare the data before charting

Put the observations in one column or row, with one numeric observation per cell. A header such as “Delivery time (minutes)” is useful, but keep text notes, totals, and unrelated values out of the observation range. Blank cells are generally ignored, while text that looks like a number may not be treated as numeric data, so check imported or manually entered values if the chart seems incomplete.

  • Use the original observations, not a pre-counted frequency table, when creating Excel’s built-in Histogram chart.
  • Check for errors, stray values, and numbers stored as text. Also decide whether zeros are genuine observations or placeholders for missing data.
  • Keep the measurement unit clear. A bin width of 5 means something different for minutes, dollars, and millimeters.
  • If the data includes dates or times, confirm that Excel recognizes them as numeric date/time values. Decide whether the intervals should represent days, hours, or another meaningful unit.

Consider a small delivery-time sample with values from 12 to 42 minutes. A useful first chart might use intervals about ten minutes wide. The right choice depends on the purpose: a quick overview may not need the same level of detail as a quality review focused on delays around a particular threshold.

Create a histogram with the built-in chart

  1. Select the numeric observations, including the header only if you want Excel to use it as a series label.
  2. On the ribbon, choose Insert > Insert Statistic Chart > Histogram. The chart appears in the worksheet.
  3. Click the horizontal axis, right-click, and choose Format Axis to open the formatting pane.
  4. Under Axis Options, adjust the bin settings. Depending on the chart and Excel build, options include the number of bins, bin width, overflow bin, and underflow bin.
  5. Add a descriptive chart title and, where useful, axis titles. Make the units and interval meaning clear to someone who did not build the chart.

Excel chooses an initial bin arrangement automatically. Treat that as a starting point, not a rule: automatic bins may produce a useful overview, but they can also hide detail or make a pattern look more dramatic than it is. Changing the bin width or number of bins changes the visual summary without changing the underlying observations.

An overflow bin groups values above a specified boundary; an underflow bin groups values below one. These options can be useful when the extreme values matter as a group, but they also conceal the individual spread within that group. Use them only when that simplification fits the question you are asking.

Build a frequency table with FREQUENCY

A formula-based table gives you explicit counts and a defined set of bin limits. In this example, place ten observations in A2:A11: 12, 18, 21, 24, 24, 27, 31, 34, 38, and 42. Put the bin upper limits 19, 29, 39, and 49 in C2:C5. With those observations in A2:A11 and bin limits in C2:C5, enter this formula in D2:

=FREQUENCY(A2:A11,C2:C5)

In Microsoft 365, the formula spills into five cells, D2:D6. The first four results count observations less than or equal to 19, 29, 39, and 49 respectively, with each later bin excluding values already counted in the earlier bins. The fifth result counts values greater than the last limit, 49. For the example data, the results are 2, 4, 3, 1, and 0: two values are at most 19; four are from 20 through 29; three are from 30 through 39; one is from 40 through 49; and none is above 49.

Label the output so that readers can understand the intervals. For example, label the first row “≤19,” the second “20–29,” the third “30–39,” the fourth “40–49,” and the final row “>49.” The bin cells contain upper limits, not labels for the full ranges, so clear labels help prevent misreading. If you want to chart these counts, select the interval labels and frequency results and insert a regular column chart; a column chart of a frequency table is not the same operation as applying the built-in Histogram chart to raw observations.

Choose bins that answer the question

Bins that are too wide can merge meaningful differences; bins that are too narrow can produce a jagged chart with many empty or nearly empty bars. There is no single bin width that is best for every dataset. Consider the data’s scale, the number of observations, and the decision the chart is meant to support.

  • Use understandable intervals. Round widths to values that suit the context, such as 5 minutes or 10 units, rather than choosing awkward boundaries without a reason.
  • Keep the range in view. If nearly all observations fall into only a few bins, try narrower bins. If the chart is dominated by empty bins, try wider ones.
  • Consider a meaningful threshold. If a specification, target, or service limit matters, align a bin boundary with it when that helps answer the question.
  • Compare alternatives carefully. For an important report, inspect more than one sensible bin width. A visible peak or gap can shift when the boundaries shift.

When comparing two groups, use the same bin boundaries and axis scale for both. Independently chosen bins can make similar distributions look different or make real differences hard to see. Also consider sample size: a histogram based on a small number of observations is naturally less smooth and should not be read as a precise picture of a larger population.

Read and format the chart responsibly

Start by asking what each bar counts and what range it covers. A tall bar means more observations in that interval, not necessarily a higher average. A histogram can show where values cluster and whether the distribution appears roughly symmetric or skewed, but it does not display each observation separately. If individual values or exact counts matter, include a frequency table or another chart alongside it.

Use a title that names the measure and units, such as “Delivery times (minutes).” Labeling the vertical axis “Frequency” is helpful when the chart may be separated from its surrounding explanation. Avoid styling that implies precision the data does not have, and do not omit important portions of the scale just to emphasize a difference.

Look for patterns, then check them against the source data and context. An isolated bar may represent a genuine unusual case, a data-entry error, or a meaningful subgroup. A two-peaked distribution may reflect two different populations mixed together. The shape is a prompt for investigation, not a substitute for it.

Common problems and fixes

  • The Histogram command is missing or disabled: Confirm that you selected numerical observations rather than a pre-made frequency table. The built-in chart is under Insert > Insert Statistic Chart > Histogram in current desktop Excel.
  • Counts seem too low: Check whether values are stored as text, whether the selection omitted rows, and whether cells contain errors. Text labels in the data range can also affect how a selection is interpreted.
  • The chart has too many bars: Select the horizontal axis, open Format Axis, and increase the bin width or reduce the number of bins.
  • Extreme values appear to vanish into the last bar: Review the overflow and underflow settings. A grouped tail may be intentional, but inspect the original values if the extremes are important.
  • FREQUENCY returns an unexpected extra value: The function returns one more count than the number of bin limits. The extra result is for values above the final limit; it is not an accidental duplicate.
  • A formula does not fill neighboring cells: In Microsoft 365, FREQUENCY normally returns a spilled array. Make sure the cells below the formula are empty and are not blocked by merged cells or existing content.

Histogram chart, ToolPak, and Excel versions

The built-in Histogram chart is convenient when you want a chart directly from raw observations and want to adjust its bins interactively. The Analysis ToolPak is another option, particularly when you want a fixed output table and associated chart. On Windows, enable it through File > Options > Add-ins; beside Manage: Excel Add-ins, choose Go, select Analysis ToolPak, and choose OK. Then select Data > Data Analysis > Histogram, specify the input range and bin range, and choose an output location. The ToolPak can also create a chart and cumulative percentage output.

On a Mac, the ribbon and chart workflow may look different, but the Histogram chart is available in current Excel versions. To enable the ToolPak, use Tools > Excel Add-ins, select Analysis ToolPak, and choose OK; then look for Data Analysis on the Data tab. Excel for the web can display and edit many charts, but some chart-editing or add-in capabilities may differ from desktop Excel. If a particular bin control is unavailable in your build, use the FREQUENCY function with explicit limits or open the workbook in desktop Excel.

Excel’s built-in chart and FREQUENCY table serve related but distinct needs. The chart offers quick exploration; a table offers transparent counts and reusable values. The ToolPak provides a dialog-based route to a frequency table and optional chart. Choose based on whether you need to explore the distribution, document exact counts, or produce a repeatable report.

Frequently Asked Questions

How do I make a histogram in Excel?
Select the raw numeric data, then choose Insert > Insert Statistic Chart > Histogram. Adjust the bin width or number of bins by selecting the horizontal axis and opening Format Axis.

What is the difference between a histogram and a bar chart?
A histogram groups numerical values into adjacent intervals, so its bars normally touch. A bar chart compares separate categories, such as product names, and its bars are typically separated.

How do I calculate frequency in Excel?
Enter numeric bin limits in a range, then use FREQUENCY with the data range and bin range. In Microsoft 365, its results spill into the cells below the formula, including one final count for values above the last bin limit.

Why does FREQUENCY return one more result than my number of bins?
The additional result counts observations greater than the final bin limit. Include a label for that overflow group if you show all the returned results.

Can I make a histogram from an existing frequency table?
You can chart its interval labels and counts with a column chart. The built-in Histogram chart is designed for raw observations and will group those observations itself, so do not feed it already aggregated counts as if they were the original data.

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.