Excel Spreadsheet Histogram: How to Create, Read, and Fix It

Charts & pivot tables · Updated November 21, 2026

To make a histogram in Excel for Microsoft 365 on Windows, select a column of numeric observations, then choose Insert > Insert Statistic Chart > Histogram. Excel groups the numbers into bins and plots how many values fall in each one, making the distribution easier to inspect than a raw list.

What an Excel histogram shows

A histogram summarizes the distribution of one numerical variable. The horizontal axis divides a continuous range of values into intervals called bins; the vertical axis shows the number of observations in each interval. A tall bar means many values fall within that interval, while an empty or short bar means few or none do. For example, a histogram of delivery times might reveal that most orders arrive in two to four days, with a smaller group taking much longer.

Histograms resemble column charts, but their meanings differ. A histogram groups numeric measurements into ranges, and the bars usually touch because the intervals are adjoining. A column chart compares separate categories such as departments or product names, so its bars are often separated. Sorting a list of measurements or making a column chart from each distinct value does not automatically produce a useful histogram: the choice of interval width is important.

Excel’s built-in histogram chart is a quick way to explore a distribution. It is a chart rather than a permanent frequency table: change the source data or bin settings and the chart updates. If you need an explicit table of counts for reporting or later calculations, the Analysis ToolPak or the FREQUENCY function may suit the task better.

Create a histogram with the chart command

  1. Put the observations in a single column or row, ideally with a descriptive heading such as Delivery days. Keep the values in one consistent unit and remove totals or summary rows from the selection.
  2. Select the numeric cells, including the heading if you want Excel to use it as the series name. Choose Insert > Insert Statistic Chart > Histogram.
  3. Excel inserts a chart with automatically chosen bins. Click the chart title to replace it with a description that identifies the measure and, where useful, the group or time period.
  4. To adjust the grouping, right-click the horizontal axis and choose Format Axis. In the Format Axis pane, open Axis Options and look for the Bins settings.

In Excel for Mac, look under Insert > Statistical Chart > Histogram; ribbon wording and the pane layout can vary somewhat by release. The chart and its axis controls have the same basic purpose. If you are using Excel for the web and do not see the same chart controls, open the workbook in the desktop app to use the full axis-formatting options.

Choose bins that answer the question

A bin is an interval, not a single observation. Excel lets you choose a bin width or a number of bins, and it also provides underflow and overflow bins for grouping values below or above a specified limit. In the Format Axis pane, set either the width or the number of bins according to the comparison you want to make. Avoid choosing a width just because it creates a visually attractive chart.

  • Bin width: Choose a width that has a meaningful interpretation, such as five minutes for waiting times or ten points for test scores. A width that is too small makes the chart jagged; one that is too large can conceal meaningful differences.
  • Number of bins: This is useful when you want a particular level of detail across the observed range. The resulting width depends on the spread of the data, so check whether the displayed intervals still make sense in the measurement’s units.
  • Underflow and overflow bins: These gather unusually low or high observations into boundary groups. They can make the main pattern clearer, but the boundary bars may contain values spread across a broad range.

Start with Excel’s automatic grouping, then compare a few reasonable alternatives. The best choice depends on the data and the question. For a monthly report, consistent bin widths across months help comparisons; letting Excel choose a different grouping for each month may make the charts look different even when the underlying distributions are similar. State the bin width or interval limits when sharing results so that another reader can understand the chart.

Work through a small example

Suppose ten measurements are 4, 8, 10, 12, 18, 21, 25, 29, 31, and 42. With bins five units wide, the frequencies would be 2 for values from 0 through 4, 2 from 5 through 9, 3 from 10 through 14, and so on. The exact interval labels depend on the bin limits you set. This example also shows why a bin width changes the story: with wider intervals, nearby values are combined and the chart has fewer bars.

For a frequency table, place the ten values in A2:A11 and the upper limits 9, 19, 29, and 39 in C2:C5. In Microsoft 365, enter this formula in D2:

=FREQUENCY(A2:A11,C2:C5)

The function returns five counts: 2, 3, 3, 1, and 1. The first four count values at or below each upper limit after the preceding limit; the final count is for values above 39. In this example, 4 and 8 fall at or below 9; 10, 12, and 18 are above 9 and at or below 19; and 21, 25, and 29 fall in the next group. The 31 is at or below 39, and 42 is in the final overflow count. In current Microsoft 365, the results spill into the cells below D2. Older Excel versions may require selecting the output range and confirming the formula as an array formula.

Use the Analysis ToolPak for a frequency table

The Analysis ToolPak Histogram command is useful when you want counts in worksheet cells as well as a chart. If Data Analysis is not visible 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, check Analysis ToolPak, and select OK.

Prepare a column of numeric data and, optionally, a separate column of bin upper limits. Choose Data > Data Analysis > Histogram. In the dialog, specify the Input Range and, if you prepared limits, the Bin Range. Select Labels if the selected ranges include headings, choose an Output Range or a new worksheet, and select Chart Output if you want Excel to create a chart. The bin range should contain numeric upper bounds in ascending order. Without a bin range, Excel uses its own default grouping.

ToolPak output is a frequency table based on the selected limits, with a final More category for values above the highest limit. This is useful when counts need to be copied into a report or used in another calculation. The output is not the same interactive chart as the built-in histogram: if the source values change, rerun the ToolPak analysis to refresh the results. Check the output limits and counts before sharing it, particularly when using a custom bin range.

Read the shape and check the data

Look at the overall shape before interpreting individual bars. A single central peak may indicate that observations cluster around one typical range. Two peaks can suggest distinct subgroups, though they might also result from the bin width. A long tail to the right or left indicates that some observations extend much farther in that direction than most. Gaps and isolated bars may reflect real rare cases, data-entry errors, or a mixture of populations.

A histogram does not show the identity or order of individual records, and it does not establish why a pattern exists. It can conceal differences within a bin, and different bin widths can change the appearance of the same data. Pair it with context such as the sample size, date range, and measurement units. When comparing groups, use the same bin boundaries and be aware that groups with different sample sizes can have very different bar heights. A percentage or density scale may be more suitable when comparing distributions of unequal sizes.

Fix common histogram problems

  • The histogram option is unavailable: Check that you selected numeric observations and are using a version of Excel with the statistical chart type. Select the data cells rather than an unrelated chart or a text-only range. In desktop Excel, use the Insert tab’s statistical chart menu.
  • The bars look overly crowded or too smooth: Adjust the bin width or number of bins in Format Axis. Record the setting when making comparisons; changing it can alter the apparent shape.
  • Values seem to be missing: Check for numbers stored as text, blank cells, error values, or accidental inclusion of a total. Convert text-formatted numbers to numeric values and inspect the source range. Verify the underflow and overflow limits if extreme values are grouped at the ends.
  • The dates make little sense: Excel stores dates as serial numbers, so a histogram can group them numerically. For calendar analysis, consider whether the chosen interval represents days, weeks, or months as intended, and make sure the labels communicate that unit.
  • The chart will not update as expected: Confirm that the new observations are inside the chart’s source range. A chart made from a fixed range may not automatically include rows appended below it; using an Excel table as the source can help the range expand as rows are added.

Histogram versus other Excel charts

Use a histogram for the distribution of one numerical variable, such as ages, transaction amounts, or measured temperatures. Use a bar or column chart for comparisons among named categories, such as sales by region. Use a line chart when the order of observations over time matters; a histogram discards that sequence. A box-and-whisker chart can provide a compact view of median, quartiles, and possible outliers, but it does not show the count in each interval as directly as a histogram.

These charts answer different questions, so one is not automatically a better replacement for another. For instance, a histogram of daily sales amounts describes how often amounts occur, while a line chart of daily totals shows how sales change over time. If the purpose is to compare two groups’ distributions, consistent histogram bins can help, but a box-and-whisker chart may be easier to read when there are many groups.

Frequently Asked Questions

Can Excel make a histogram from text categories?
A histogram is intended for numeric measurements. For named categories such as colors or departments, use a column or bar chart, or first create a frequency table that counts each category.

Why do the histogram bars touch?
The bars represent adjoining numeric intervals, so touching edges communicate that the bins form a continuous range. A chart of distinct categories typically uses separated bars instead.

Can I choose custom bin limits?
Yes. For the built-in histogram, adjust the bin width or number of bins and use underflow or overflow settings where appropriate. For exact upper limits and a worksheet frequency table, use the Analysis ToolPak or FREQUENCY with an ordered list of bin limits.

Why does a histogram look different after I change the bin width?
Each bar covers a different interval, so values are regrouped and peaks or gaps can appear or disappear. Compare charts using the same boundaries when the goal is to compare datasets.

Does a histogram show the average or median?
Not by itself. It shows counts across intervals, from which you can judge the distribution’s general shape, but it does not mark the mean or median automatically. Calculate or display those statistics separately if readers need them.

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.