Excel Histogram Tool: Create, Read, and Customize Charts

Charts & pivot tables · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, select a column of numeric data and choose Insert > Insert Statistic Chart > Histogram to create a histogram chart. To produce a frequency table as well, use the Analysis ToolPak: enable the add-in, then choose Data > Data Analysis > Histogram.

What Excel’s histogram tool does

A histogram groups numerical observations into ranges, called bins, and shows how many values fall into each range. Its columns usually touch because the ranges represent continuous values. The resulting shape makes it easier to see where values cluster, how widely they vary, and whether the distribution has a long tail or more than one peak.

Excel has two related options that people often mean by “the histogram tool.” The built-in Histogram chart is a chart type you can insert and format. The Analysis ToolPak’s Histogram command is a statistical analysis that creates a frequency table and can also create a chart. Both summarize numeric data, but they offer different workflows: the chart is convenient for visual exploration, while the ToolPak is useful when you want a table of counts based on specified bin limits.

A histogram is not the same as a bar chart. A bar chart commonly compares separate categories, such as departments or product names, and the order may be arbitrary. A histogram divides a number scale into ranges, so the bins have a meaningful order. If your source values are names or categories rather than measurements, a bar or column chart is generally the more suitable choice.

Create a histogram chart in Excel

For the built-in chart, put the observations in one column, with an optional heading in the first cell. For example, a heading in A1 and 40 delivery times in A2:A41 is a suitable layout. Each row should represent one observation, and the cells should contain numbers Excel recognizes as numbers.

  1. Select the numeric values, including the heading if you have one.
  2. On the ribbon, choose Insert > Insert Statistic Chart > Histogram.
  3. Excel inserts a chart with automatically selected bins. Add a descriptive chart title and check whether the default grouping communicates the pattern clearly.
  4. To change the grouping, right-click the horizontal axis and select Format Axis. In Axis Options, adjust the bin settings.

The principal bin settings are Bin width and Number of bins. You can also set an Underflow bin or an Overflow bin to group values below or above a limit. The exact controls appear in the Format Axis pane when the horizontal axis of a histogram chart is selected. If you have selected a different chart element, the pane may show formatting options that do not include bin settings.

On Excel for Mac, the chart feature is also available through the Insert tab, although ribbon labels and layout can vary by release. Excel for the web may not expose every chart-formatting control found in the desktop application. If you cannot find a particular bin option, open the workbook in Excel for Microsoft 365 on Windows or Mac and select the chart’s horizontal axis.

Choose useful bins

Bin width determines how much of the measurement scale each column covers. Smaller bins show more detail but can make a chart jagged, especially with a small sample. Larger bins smooth the display but can conceal meaningful variation. Excel’s automatic choice is a starting point, not a rule that guarantees the best view for every dataset.

Suppose delivery times range from 8 to 58 minutes. A width of 10 minutes gives a readable grouping such as 0–10, 10–20, and so on, depending on the chart’s boundaries. A width of 2 minutes would expose finer differences but could leave many bins with only a few deliveries. Try a couple of reasonable widths and ask whether the conclusion changes. Keep the chosen width when comparing groups so that differences are not caused merely by different binning.

  • Use fewer, wider bins when you need a simple overview or have relatively few observations.
  • Use more, narrower bins when the dataset is large and detail is relevant, but check for columns that are mostly empty.
  • Use an overflow or underflow bin when values beyond a practical threshold should be shown together, such as all delivery times above 60 minutes.
  • Use consistent boundaries when comparing separate periods, locations, or groups.

The chart’s bins are intervals, not labels for individual observations. If a value falls exactly on a boundary, Excel assigns it according to the chart’s binning rules. For a report where the handling of boundary values must be explicit, the ToolPak’s stated upper-bound bins can be easier to audit.

Use the Analysis ToolPak for a frequency table

The Analysis ToolPak is an Excel add-in. On Windows, turn it on by choosing File > Options > Add-ins. At the bottom, set Manage to Excel Add-ins and select Go. Check Analysis ToolPak and choose OK. Then select Data > Data Analysis > Histogram. If the add-in is already enabled, you can go directly to the Data tab.

In the Histogram dialog, specify the Input Range containing the measurements. You can optionally supply a Bin Range: a column of numeric upper limits in ascending order. For instance, limits of 10, 20, 30, 40, and 50 create groups whose upper limits are those values, with a final group for observations above the largest limit. The ToolPak reports the frequencies for these bins; its output also identifies values beyond the listed limits as a “More” category.

Select Labels if the input or bin range includes headings. Choose an Output Range or a new worksheet, and select Chart Output if you also want a chart. Then choose OK. Keep the input and output ranges separate so the results do not overwrite source data. On Mac, add-in management is generally under Tools > Excel Add-ins; the exact dialog layout can differ. Once enabled, look for Data Analysis on the Data tab.

Use the ToolPak when the numerical frequency table is part of the deliverable or when you need to specify bin cutoffs before producing results. Use the built-in chart when you want to explore the distribution quickly and adjust bins interactively. The ToolPak’s output is a snapshot: if the source data changes, run the analysis again to refresh the output.

Read the shape and check the data

Each histogram column represents a count of observations in a range. The tallest column marks the most populated range, not necessarily the exact most common individual value. A roughly symmetric, single-peaked shape differs from a distribution with a long tail, a gap, or two clusters. These patterns can guide further investigation, but a histogram alone does not explain why the data has that shape or establish that one group caused another.

Before interpreting the picture, check how many observations were included and whether the values are comparable. A histogram of test scores, for example, may be misleading if some records use a different scoring scale. Dates and times are stored numerically in Excel, so they can be histogrammed, but the axis may need a clear number format or more practical units. A chart of date serial numbers is not automatically an easy-to-read calendar timeline.

Inspect the source for blanks, error values, numbers stored as text, and unexpected entries. A value such as “—” or “unknown” is not a numeric observation. Decide whether to exclude it, correct it, or report it separately; do not silently treat missing information as zero. If the data includes legitimate zeros or negative values, retain them unless the subject matter gives a sound reason to remove them.

Common problems and fixes

  • The Histogram command is missing. The ToolPak may not be enabled. On Windows, enable Analysis ToolPak through File > Options > Add-ins; on Mac, check Tools > Excel Add-ins.
  • The chart has unexpected bins. Right-click the horizontal axis, choose Format Axis, and set a deliberate bin width or number of bins. Check that the chart is actually a Histogram chart.
  • Some observations appear absent. Check for text-formatted numbers, blanks, errors, or values outside the defined ToolPak limits. Confirm that the input range includes all intended rows.
  • The axis labels look confusing. Use a clear chart title and axis labels, adjust the bin width, and consider whether values are in the right units. Avoid relying on a default title for a report.
  • The ToolPak output did not update. The output is not a live chart of the source range. Run the Histogram analysis again after changing the data, or use a built-in chart when interactive updates are more important.

For a fair comparison between two datasets, use the same bin boundaries and make the sample sizes clear. A group with twice as many observations may have taller columns simply because it contains more records. Comparing percentages rather than raw counts can help when group sizes differ, but Excel’s standard histogram chart is count-based; consider calculating and charting proportions separately if that is the question you need to answer.

Histogram chart versus other Excel options

The built-in Histogram chart is the simplest option for a quick visual summary. The ToolPak is preferable when you need explicit frequency counts and chosen bin limits. A PivotTable can summarize values when you need to filter or break results into categories, but grouping numeric values in a PivotTable is a different workflow and does not make every PivotChart a histogram.

A column chart of precomputed counts can be useful when you need full control over labels, percentages, or a custom reporting layout. In that case, create the bin definitions and counts carefully, then chart them as categories. This takes more setup and makes it your responsibility to keep the counts correct when the source changes. For ordinary numeric data, start with Excel’s Histogram chart; move to the ToolPak or a custom frequency table when you need more control over the table or presentation.

Frequently Asked Questions

Where is the histogram tool in Excel?
For a chart, select numeric data and choose Insert > Insert Statistic Chart > Histogram. For a frequency table, enable Analysis ToolPak and choose Data > Data Analysis > Histogram.

Why can’t I see Histogram under Data Analysis?
The Analysis ToolPak may not be installed or enabled. Check Excel Add-ins in the application’s add-in settings, enable Analysis ToolPak, and reopen Data > Data Analysis.

How do I change the bin size in Excel?
Right-click the histogram’s horizontal axis, select Format Axis, and change Bin width or Number of bins under Axis Options. Use a width that makes the distribution understandable without hiding important detail.

Can Excel make a histogram from text categories?
No: a histogram is designed for numeric observations grouped into ranges. For categories such as regions or product types, summarize their counts and use a bar or column chart instead.

What is the difference between Excel’s Histogram chart and the ToolPak?
The chart is a convenient visual that you can format by changing its axis bins. The ToolPak creates a frequency table from specified input and optional bin ranges, and can also produce a chart. Choose based on whether you primarily need an interactive chart or an auditable count table.

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.