Excel Histogram: Create One from a Column of Data

Charts & pivot tables · Updated November 18, 2026

Yes. In Microsoft Excel for Microsoft 365 on Windows, select the numeric values in your column, then choose Insert > Insert Statistic Chart > Histogram. Excel creates a chart that groups the values into intervals, or bins, and shows how many observations fall in each interval.

What a histogram shows

A histogram is a chart for understanding the distribution of numeric data. The horizontal axis divides the values into ranges, and each bar shows how many values fall within one range. For example, a column of delivery times might be grouped into 0–9 minutes, 10–19 minutes, 20–29 minutes, and so on. Taller bars indicate ranges that contain more observations.

That makes a histogram useful for questions such as whether measurements cluster around a typical value, whether the data are spread out, or whether unusually high or low values appear. It is different from a column chart: a column chart compares named categories, while a histogram groups numerical values into intervals. If your column contains labels such as departments or product names, use a column or bar chart instead.

Excel’s built-in histogram chart is the quickest option for most one-column analyses. You do not need to calculate each bin’s count yourself; Excel determines the intervals and frequencies, and you can adjust the bin settings to make the distribution easier to interpret.

Prepare the column before charting

Put the measurements in one column, with one observation per row. A header such as Delivery time (minutes) is helpful because Excel can use it as the chart’s series name. Avoid selecting a total row or unrelated notes along with the measurements.

Check that the observations are numeric values rather than numbers stored as text. A value that looks like 25 but is stored as text may not be included as expected. Dates and times are stored numerically in Excel, but their display and interpretation depend on the number format and the question you are trying to answer. For a straightforward first chart, use a column of consistent numeric measurements.

  • Keep the measurements together in a single contiguous range where possible.
  • Use one unit throughout the column; do not mix, for example, seconds and minutes.
  • Remove accidental text, error values, and summary rows from the selected range.
  • Decide whether a blank cell represents missing data. Do not replace missing observations with zero unless zero is genuinely the measured value.

Suppose cells A1:A21 contain a heading in A1 and 20 delivery times in A2:A21. Select A1:A21, or select just A2:A21 if you prefer to add the chart title and series name yourself. Excel should create a single-series histogram. If it instead creates an unexpected chart or includes extra material, delete it and reselect only the intended data.

Create the histogram in Excel for Windows

  1. Select the numeric data, optionally including its header. Do not include a separate frequency table or unrelated columns.
  2. Open the Insert tab on the ribbon.
  3. Choose Insert Statistic Chart in the Charts group, then choose Histogram.
  4. Click the chart title and replace it with a title that says what was measured and, if useful, the unit.
  5. Review the horizontal axis and adjust its bins if the automatic grouping obscures the pattern.

The command is available in desktop Excel for Microsoft 365. The exact arrangement of chart controls can vary with ribbon layout and window size. On Excel for Mac, select the data and look on the Insert tab for Statistical Chart or Insert Statistic Chart, then select Histogram; wording and placement can differ by release. If you are using Excel for the web and do not see a histogram option, open the workbook in the desktop app for the controls described here.

After insertion, you can move or resize the chart like other Excel charts. Use the chart title and axis labels to make the result understandable to someone who has not seen the source data. The vertical axis represents frequency, meaning the count of observations in each bin.

Choose useful bins and intervals

Excel initially chooses bins automatically. Automatic grouping is a convenient starting point, but it is not always the most informative choice. Too few bins can hide meaningful variation by combining different values; too many can leave most bars nearly empty and make random fluctuations look important. There is no single ideal bin count for every dataset. The sample size, range, measurement precision, and purpose of the chart all matter.

To change the grouping, right-click the horizontal axis and choose Format Axis. In the Format Axis pane, find Axis Options and the Bins settings. Depending on the chart and Excel version, you can choose a number of bins or a bin width. A bin width sets the numerical span of each interval; a number of bins tells Excel how many intervals to use across the data range.

For example, if delivery times run from about 2 to 58 minutes, a width of 10 minutes gives a more readily described view than a large number of narrow bins: the reader can compare counts across roughly ten-minute ranges. The exact boundaries and resulting counts depend on the data and Excel’s grouping. Try a couple of sensible settings, then choose the one that shows the distribution without hiding important detail.

Excel also offers underflow and overflow bins. An underflow bin collects values at or below a boundary you specify, and an overflow bin collects values above a specified boundary. These options can be useful when a few extreme observations stretch the axis and make the main cluster hard to see. Use them deliberately: grouping extreme values together hides their differences, so note the boundary in the chart or accompanying text.

Make the chart easier to read

A useful histogram gives the reader enough context to interpret the bars. A title such as “Delivery times (minutes)” is more informative than “Histogram.” If the source data represent a particular group or period, include that context too. Make sure the horizontal axis communicates the measurement and unit, and the vertical axis is understood as a count.

  • Check the scale: Confirm that the bin boundaries make sense for the unit and range.
  • Use a sensible chart size: If labels overlap, widen the chart or reduce unnecessary label detail.
  • Keep formatting restrained: The bar pattern is the main information; excessive colors and effects can distract.
  • Explain unusual choices: If you group outliers or use a nonstandard width, identify the boundary or reason.

Histograms are often displayed with adjacent bars because their intervals represent neighboring stretches of a numerical scale, not unrelated categories. Avoid interpreting the left-to-right order as a ranking of named groups. If you need to compare separate groups, such as delivery times for two warehouses, consider whether separate histograms with the same bin boundaries will be clear, or whether a different chart better fits the comparison.

Use the Analysis ToolPak as an alternative

The Analysis ToolPak can calculate a frequency table and optionally create a histogram chart. This is useful when you want to specify the bin limits yourself or need the counts as worksheet output for further analysis. The built-in chart is usually simpler when the goal is simply to visualize one column.

If Data Analysis is not on the Data tab, enable the add-in in desktop Excel for Windows: choose File > Options > Add-ins. At the bottom, set Manage to Excel Add-ins, choose Go, select Analysis ToolPak, and choose OK. Then open Data > Data Analysis and choose Histogram.

In the Histogram dialog, set the input range to the numeric observations. You can also provide a bin range: a separate column of upper limits that defines the intervals. Select Labels if the input range includes a heading, choose an output location, and select the option to create a chart if you want one. The ToolPak produces a frequency table as well as the optional chart. Its output is a snapshot: if the source values change, run the analysis again to refresh the results. ToolPak availability and setup can differ on Mac, so use the built-in chart if the add-in is not available in your installation.

Common problems and what to check

The Histogram command is missing: Confirm that you are using desktop Excel and that the data are selected. Look under the Insert tab’s statistical chart controls. If you are in a browser or an older Excel release, the available chart options may differ; the Analysis ToolPak or a frequency table may be alternatives.

The chart has an unexpected number of bars: Excel may be using automatic bins. Right-click the horizontal axis, open Format Axis, and set a bin width or number of bins. Also check whether the selected range includes outliers or unintended cells, since a very large or small value can widen the displayed range.

Some observations seem absent: Inspect the source column for numbers stored as text, blanks, errors, or stray labels. Make sure the range includes all intended rows and excludes notes. Do not assume that a blank means zero; missing values and measured zeros have different meanings.

The bars do not match a manually counted table: Check the bin boundaries and whether your hand-counting rule treats values exactly on a boundary the same way as Excel. For reproducible reporting, document the chosen width or limits and verify a few bins against the underlying observations. If exact, fixed interval definitions are essential, the ToolPak with a specified bin range can be preferable.

When a histogram is not the right chart

Use a histogram when the values are quantitative and you want to see their distribution. For a small set of measurements where every individual value matters, a dot plot or a table may communicate more. For values tracked over time, a line chart is usually better because sequence matters. For category totals such as sales by region, use a bar or column chart rather than treating each region name as a numerical bin.

A histogram also does not show every data point or identify which row produced a particular value. It summarizes counts by interval. If you need to investigate a particular observation, keep the original data available and use filters or sorting alongside the chart. If you compare groups, apply consistent bin boundaries so differences in bar heights are not caused merely by different grouping choices.

Frequently Asked Questions

Can Excel make a histogram from one column?
Yes. Select the column’s numeric values, then choose Insert > Insert Statistic Chart > Histogram in Excel for Microsoft 365 on Windows. Include the heading if you want Excel to use it as the series name.

Why does Excel show one bar for each value?
You may have inserted a column chart instead of a histogram, or the bin width may be too narrow. Choose the Histogram statistical chart and adjust the bin width or number of bins in Format Axis.

Can I set the histogram intervals myself?
Yes. In the built-in histogram, use the Format Axis pane to set a bin width or number of bins, and optionally define underflow or overflow bins. For explicit interval limits and a frequency table, use the Analysis ToolPak’s Histogram tool.

Can I make a histogram from text categories?
Not meaningfully with the histogram chart. Histograms group numeric values into ranges. For categories such as names, regions, or product types, use a bar or column chart to compare category counts.

Does the histogram update when I change the data?
The built-in chart is linked to its source range, so changes to values within that range are reflected in the chart. The ToolPak output is generated as a frequency table and chart; rerun the analysis when the source data changes.

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.