Excel Histogram Help: Create and Troubleshoot Charts

Charts & pivot tables · Updated November 19, 2026

To make a histogram in Excel for Microsoft 365 on Windows, select one column of numeric data, then choose Insert > Insert Statistic Chart > Histogram. To change the intervals, right-click the horizontal axis, choose Format Axis, and adjust the bin settings. A histogram groups numbers into ranges, making it easier to see a distribution than a list of values alone.

What a histogram shows

A histogram counts how many numeric observations fall within each interval, or “bin.” The horizontal axis represents ranges of values, and the vertical axis represents frequency: the number of observations in each range. For example, a histogram of delivery times might show how many orders took 0–10 minutes, 10–20 minutes, and so on.

Histograms are useful for examining the shape and spread of numerical data. A high bar can indicate a common range; a long tail on one side may suggest skew; and separated groups of bars can hint that the data contains different populations or processes. A chart is a descriptive view, however, not proof of why a pattern exists. Check the underlying records and context before drawing conclusions.

A histogram is not the same as a column chart. A column chart compares named categories, such as sales by region, and often has gaps between bars. A histogram uses adjacent numerical ranges, so its bars normally touch. The touching bars communicate that the bins cover a continuous numeric scale.

Create a histogram with the built-in chart

Use a single column containing the observations you want to summarize. Put a clear header in the first row, keep each measurement in its own cell, and remove explanatory notes from the data range. Excel can generally skip blank cells, but text mixed into a numeric column can make the result confusing or cause values to be excluded.

  1. Select the numeric cells, including the header if you have one.
  2. On the ribbon, choose Insert > Insert Statistic Chart > Histogram. If the chart is not immediately visible in the gallery, look in the statistical chart options.
  3. Excel inserts a chart using automatic bin settings. Add or edit a chart title and axis titles if readers need context.
  4. Right-click the horizontal axis and choose Format Axis to set the number or width of bins and other boundaries.

For example, a column of 100 recorded commute times can become a histogram with ranges such as 0–10, 10–20, and 20–30 minutes. Excel chooses an initial grouping automatically, but that choice is only a starting point. A chart with too few bins can hide meaningful differences; one with too many can look noisy and make the overall pattern hard to see.

On Excel for Mac, the histogram chart is also available from the Insert tab’s statistical chart options, though ribbon layout and labels can vary by release. Excel for the web may present a different ribbon layout or fewer chart-formatting controls. If a specific bin option is missing in the browser, open the workbook in the desktop Excel app to use the full Format Axis pane.

Choose useful bins and boundaries

In the Format Axis pane, find the Bins settings. Depending on the chart and Excel build, you can specify a number of bins or a bin width. A fixed width is useful when the measurement has meaningful units—for example, grouping response times in five-second intervals. A chosen number of bins can be convenient when you want a certain level of detail, but the resulting interval widths may not match a familiar unit.

Excel also provides underflow and overflow bins. An underflow bin groups values at or below a selected threshold; an overflow bin groups values above a selected threshold. These can be useful when extreme values would otherwise stretch the axis and compress the rest of the chart. Use them only when the threshold makes sense for the question being asked, and label the chart so readers know that the end bar combines a broad range.

There is no universally best bin count. Consider the data size, measurement precision, and purpose of the display. A small dataset often needs fewer bins than a large one. If you are comparing two groups, use the same bin boundaries for both; separate automatic settings can make similar distributions look different. Try a couple of reasonable widths, then check whether the main pattern remains visible rather than selecting settings just because they produce a preferred conclusion.

Read the chart without overinterpreting it

Start by checking the axis labels and scale. The horizontal axis should make clear what is being measured and in what units, while the vertical axis should say whether bars show counts, percentages, or another quantity. The built-in histogram primarily displays frequencies. If you need percentages, calculate them separately or use a charting approach that explicitly supports the desired normalization.

Look at the overall shape: is it roughly balanced, skewed, concentrated around one range, or split into multiple clusters? Also note gaps and unusually distant values. A potential outlier is a reason to inspect the source record, not an automatic reason to delete it. It could be a data-entry error, a valid rare event, or a different kind of observation. Document any exclusions and keep the original data intact.

Bin choices affect how much detail appears. A broad bin can combine a low value and a high value into the same bar, while a narrow bin can leave many bars nearly empty. If the visual conclusion changes dramatically when you make a modest adjustment, describe that sensitivity rather than treating one version as definitive.

Worked example: commute times

Imagine a sample of commute times, in minutes, that ranges from 12 to 51. With a bin width of 10, the chart can display the broad pattern across successive ranges. If most observations are between 20 and 40 minutes, those bars will be taller than the bars at the extremes. The chart helps answer “where are the times concentrated?” It does not by itself tell you the average, the median, or whether a particular commute is unusually long.

Before interpreting that chart, verify that all entries use the same unit and that the column contains actual numeric values, not numbers stored as text. Check whether the sample includes zero or unusually high values and whether those values are plausible. If the data represents multiple routes, weekdays and weekends, or different measurement methods, consider making separate histograms or using consistent bins to compare groups. Mixing distinct groups can create a shape that represents neither group well.

When presenting the example, state the sample size and the time period represented. A histogram of 20 commutes is less stable than one based on thousands, even if their shapes look similar. A clear caption might say “Commute duration, minutes; 100 trips recorded in May; bins are 10 minutes wide.” That context helps readers judge what the chart can and cannot support.

Use the Analysis ToolPak for a frequency table

The built-in histogram chart is usually the quickest option. The Analysis ToolPak is a useful alternative when you want a frequency table, a histogram output, or more control over the specified bin cutoffs. To enable it in Excel for Microsoft 365 on Windows, choose File > Options > Add-ins. At the bottom, set Manage to Excel Add-ins, choose Go, check Analysis ToolPak, and select OK. Then use Data > Data Analysis > Histogram.

In the dialog, enter the input range containing the observations and, if you have one, the bin range containing upper limits. Choose an output location and select Chart Output if you want Excel to create a chart as well as the table. The listed cutoffs determine how the values are grouped, so make sure they cover the data you intend to include. Read the resulting labels carefully, especially the final row, before sharing the output.

The ToolPak’s table can be handy for checking exact counts or building a customized chart, but it is less automatically connected to changing data than a chart built directly from a selected source range. If observations change, rerun the analysis to refresh its output. The add-in setup and menu wording may differ on Mac; Excel for Mac has an Analysis ToolPak add-in option in its add-ins settings, and the Data Analysis command appears on the Data tab when available.

Fix common histogram problems

  • The chart option is unavailable: Confirm that you selected a numeric data range and are using a supported desktop Excel version. If the ribbon is simplified or the workbook is open in a browser, try the full desktop app.
  • Some values seem missing: Check for numbers stored as text, error values, stray labels, and unexpected blanks. Convert text-formatted numbers to numeric values and check the source column again.
  • The bars look too crowded or too broad: Right-click the horizontal axis, open Format Axis, and adjust Bin width or Number of bins. Use units that make sense for the measurement.
  • The chart includes a surprising end bar: Review underflow and overflow settings and compare the axis boundaries with the smallest and largest source values.
  • The chart does not update after adding records: Check whether the new cells are inside the chart’s source range. A formatted Excel Table can make data management easier, but verify that the chart source includes the rows you add.
  • The bars have gaps or look like categories: Check that the chart type is Histogram rather than a regular column chart. If available in the formatting pane, reduce the series gap width.

Also check for duplicate values and inconsistent precision. Duplicate measurements are not inherently wrong: each occurrence contributes to the frequency. Rounding values before charting, however, can move observations across bin boundaries. Keep the original precision unless rounding is part of the intended analysis.

Built-in chart, ToolPak, or manual method?

Choose the built-in Histogram chart when you want a fast visual summary and expect to adjust bins interactively. Choose the ToolPak when a tabular frequency output or specified cutoffs are central to the task. A manual frequency table can be appropriate when you need a custom layout, explicit labels, or a chart that follows a reporting template.

For a manual method, create lower and upper boundaries in adjacent columns and count observations in each interval with COUNTIFS. This approach requires care at shared boundaries: decide whether intervals include their lower or upper endpoint, and make the final interval include the maximum value. Otherwise, a value exactly on a boundary can be counted twice or not at all. Document the rule in the table headings or notes.

For most readers, the built-in chart is the best first try. It is quick to revise, and its axis settings expose the choices that shape the distribution. Whichever method you use, save the source observations and record the bin rule so that another person can reproduce the result.

Frequently Asked Questions

How do I change the bin size in an Excel histogram? Right-click the horizontal axis, choose Format Axis, and set Bin width to the interval you want. If you want a set number of bars instead, choose Number of bins. The resulting chart may change substantially, so review the labels and overall shape after editing.

Can I make a histogram from text categories? Not directly in the usual statistical sense. A histogram groups numeric measurements into ranges. For text categories such as product names, make a frequency table and use a column or bar chart instead.

Why does my Excel histogram show only one bar? The data may be constant or tightly clustered, the automatic bins may be too broad, or some entries may be stored as text. Check the source values, then try a narrower bin width in Format Axis.

Can I use a histogram to compare two groups? Yes, but use identical bin boundaries and scales for both groups. Separate charts are often easier to read; overlaying or stacking frequencies can mislead when group sizes differ. Consider percentages when the sample sizes are substantially different, and make the normalization clear.

Does Excel choose the best bins automatically? Excel selects default bins to produce a usable starting chart, but that is not a guarantee of the best analytical choice. Set bins according to the data’s units, sample size, and comparison goal, and check whether your interpretation is robust to reasonable alternatives.

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.