Histogram in Excel: How to Create and Customize One

Charts & pivot tables · Updated November 18, 2026

Yes. In Excel for Microsoft 365 on Windows, select your numeric data, then choose Insert > Insert Statistic Chart > Histogram. Excel groups the values into intervals called bins; you can then adjust those intervals and format the chart to make the distribution easier to understand.

What a histogram shows

A histogram summarizes how often values occur within ranges. Its horizontal axis shows numeric intervals, and its vertical axis shows the count of observations in each interval. 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. The bars touch because the intervals represent a continuous numeric scale.

This is different from a regular column chart. A column chart is usually used to compare separate categories, such as sales by product or votes by candidate. A histogram groups numeric measurements into ranges, making it useful for spotting a typical value, spread, skew, clusters, gaps, and unusually high or low observations. It does not show each individual data point, so keep the original data available when exact values matter.

Prepare the data before creating the chart

Put the observations for one variable in a single column, with an optional header such as Delivery time. Each row should contain one numeric value. A clean column helps Excel identify the data range correctly and makes the chart easier to update.

  • Remove explanatory text and subtotals from the middle of the values. A header at the top is fine.
  • Check that numbers are stored as numbers, not as text. Text that looks numeric may be ignored or handled unexpectedly.
  • Decide what to do with blanks, errors, and records that should not be included. For example, a blank cell may mean missing data rather than a measurement of zero.
  • Use one measurement type and unit. Combining minutes and seconds, or different kinds of measurements, produces a misleading distribution.

For a simple example, suppose A1 is the heading Delivery time (minutes) and A2:A11 contains ten delivery times. Select the heading and values, or select the values alone, before inserting the chart. If you select the heading too, Excel generally uses it as a label rather than treating it as an observation.

Create a histogram with the chart command

  1. Select the numeric values, including the header if there is one.
  2. On the ribbon, choose Insert > Insert Statistic Chart > Histogram.
  3. Excel inserts a histogram on the worksheet. Move or resize it as needed, then add a descriptive chart title.
  4. Right-click the horizontal axis and choose Format Axis to change how Excel groups the values.

The histogram chart is the quickest option for most readers because the chart and its bins remain connected to the source data. When the observations change, Excel can update the chart. If you are using Excel for Mac, the command is also on the Insert tab, though the ribbon wording or placement can vary by release; look for the Statistical Chart or Histogram option. Excel for the web has a different interface, and some desktop analysis features are not available there.

Choose useful bins and axis settings

A bin is an interval that collects values. The choice of bin width can change the story a chart appears to tell. Very wide bins can conceal patterns; very narrow bins can create a jagged chart that is hard to interpret. Excel chooses an initial grouping automatically, but that default is only a starting point, not a claim that one binning is universally correct.

Right-click the horizontal axis and open Format Axis. In Axis Options, look for controls such as Bin width, Number of bins, Overflow bin, and Underflow bin. You can set a width directly or ask for a chosen number of bins. Overflow and underflow bins gather values above or below a boundary into end groups, which can keep a few extreme values from stretching the display.

For example, if delivery times run from 4 to 47 minutes, a width of 10 minutes produces understandable groups around 0–10, 10–20, 20–30, and so forth, depending on the exact boundaries Excel displays. A width of 1 minute might be appropriate for a large dataset with precise measurements, but it could leave many empty or nearly empty bars when there are only ten deliveries. Check the axis labels after changing the setting so the intervals are clear and sensible for the units.

Use the Analysis ToolPak for a frequency table

Excel also offers a Histogram tool in the Analysis ToolPak. This is useful when you need a frequency table, want to specify the bin boundaries yourself, or want the output table as well as a chart. On Windows, enable the add-in through File > Options > Add-ins. At the bottom, choose Excel Add-ins in the Manage box, click Go, select Analysis ToolPak, and click OK. Then choose Data > Data Analysis > Histogram.

In the Histogram dialog, set the input range to the observations and, if desired, set the bin range to cells containing upper limits. Choose an output location and select Chart Output if you want Excel to create a chart. The optional Labels setting should be selected only when the selected input range includes a heading. The ToolPak produces a frequency table; it is a separate output rather than the same automatically linked chart experience as the Insert command. If you change the source data later, you may need to run the tool again.

On Excel for Mac, the Analysis ToolPak can be enabled from Tools > Excel Add-ins in supported desktop releases, then used from the Data tab. The exact dialog and available options can depend on the Excel version. The Analysis ToolPak is a desktop feature, so do not expect its Data Analysis command to be available in Excel for the web.

Build a frequency table with FREQUENCY

If you want a table you can inspect or use in another chart, the FREQUENCY function counts values at or below supplied bin limits and returns an additional count for values above the largest limit. In Microsoft 365, it can spill its results into the cells below the formula. This gives you more control over the table, although you must make a chart separately if you want a visual.

Suppose A2:A11 contains these ten delivery times: 12, 18, 21, 24, 27, 31, 34, 38, 42, and 47. Put the bin upper limits 19, 29, 39, and 49 in C2:C5. With those observations in A2:A11 and limits in C2:C5, enter this formula in D2:

=FREQUENCY(A2:A11,C2:C5)

The formula returns five counts in D2:D6: 2 values at or below 19, 3 values above 19 and at or below 29, 3 above 29 and at or below 39, 2 above 39 and at or below 49, and 0 above 49. The total is 10, matching the ten observations. Label the intervals clearly in a neighboring column; the function returns counts, not the text labels for your bins.

Make the chart readable and interpret it carefully

Give the chart a title that identifies both the measurement and, where useful, the group or time period. Add axis titles when units might otherwise be unclear. For example, Delivery time in minutes is more informative than Results. Keep the horizontal labels legible, and avoid decorative effects that make bar heights difficult to compare.

Read the shape rather than treating the tallest bar as the whole result. A single peak may suggest one common range; two peaks can indicate subgroups or different processes; a long tail on one side suggests skew. Gaps may indicate values that rarely occur, while isolated bars at an extreme can prompt a check of the underlying records. These are clues, not explanations: a histogram alone cannot tell you why a pattern exists or whether an extreme value is an error.

Be especially cautious when comparing two histograms with different bin widths or different vertical scales. The pictures can look unlike each other simply because the grouping choices differ. For a fair comparison, use the same measurement units, bin boundaries, and scale, and consider showing sample sizes. A histogram shows counts by default; if the datasets are different sizes, the larger dataset may have taller bars even when the proportions are similar.

Common problems and practical fixes

  • The chart command is unavailable. Confirm that the selected data are numeric and that you are using a version of Excel with the histogram chart type. If the ribbon is collapsed, expand it or use the Insert tab to find the statistical chart group.
  • Some values seem to be missing. Check for numbers stored as text, cells containing errors, and values outside an underflow or overflow boundary. Also check whether the source range includes all intended rows.
  • The bins look unreasonable. Open Format Axis and set a bin width or number of bins suited to the units and amount of data. Review the displayed boundaries rather than assuming Excel chose the most useful grouping.
  • The ToolPak chart does not change with the data. The ToolPak creates an output table and chart that may need to be regenerated after the input changes. Use the regular Insert histogram chart when a chart tied to the source range is more convenient.
  • The result is being mistaken for a bar chart. Use a histogram for the distribution of numeric measurements. Use a column or bar chart when the categories are distinct labels rather than numeric intervals.

Frequently Asked Questions

Can Excel make a histogram automatically?
Yes. Select numeric data and choose Insert > Insert Statistic Chart > Histogram. Excel creates an initial set of bins automatically, and you can adjust the bin width or number of bins in Format Axis.

How do I change the number of bins in an Excel histogram?
Right-click the horizontal axis, choose Format Axis, and use the Bin settings under Axis Options. You can set the number of bins or specify a bin width. The available controls can vary slightly between Excel releases.

Can I make a histogram from text categories?
Not in the usual statistical sense. A histogram groups numeric values into intervals. For separate labels such as departments or product names, summarize their counts and use a bar or column chart instead.

Why does Excel show different bins than I expected?
Excel selects an initial grouping automatically, and the chosen boundaries may not match familiar round numbers. Set a bin width or create explicit limits with the Analysis ToolPak or FREQUENCY, then check how boundary values are counted.

Can I create a histogram without the Analysis ToolPak?
Yes. The built-in Histogram chart under Insert is separate from the ToolPak and is sufficient for many uses. The ToolPak is an optional route when you also want a frequency table or need to provide specific bin limits.

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.