Excel Histogram: Easy Steps to Create and Format One

To make an Excel histogram, put your numeric observations in one column, select the data, then choose Insert > Insert Statistic Chart > Histogram. Excel creates a chart that groups the values into ranges, or bins; you can adjust those ranges by formatting the horizontal axis.

What an Excel histogram shows

A histogram summarizes the distribution of numeric data. Its horizontal axis divides the values into adjacent ranges, and the height of each column represents how many observations fall into that range. For example, a histogram of delivery times could show how many deliveries took 0–9 minutes, 10–19 minutes, 20–29 minutes, and so on. The shape can make a typical value, spread, gaps, clusters, and unusually high or low observations easier to notice than in a long list.

Unlike a chart that plots every individual observation, a histogram compresses the data into counts. That makes it useful for exploring measurements such as test scores, response times, product weights, ages, or daily sales. It does not show which particular record produced each count, so keep the source data available when you need to investigate individual cases.

Prepare the data before inserting the chart

Start with one column containing the values you want to summarize. A clear header is useful, and a single header row is fine when selecting the range. The observations should be numeric and measured on a scale where grouping into intervals makes sense. Dates and times can also be analyzed as numeric values, but their underlying units and display formats can affect how useful the resulting bins are.

Keep the measured values together in one column rather than mixing them with names or categories.
Check for numbers stored as text, stray notes, and units typed into cells. Store a value such as 12.5 as a number and put its unit in the column heading.
Decide how to treat blanks, errors, and values that are not part of the population being studied. Clean or exclude them deliberately rather than assuming they are valid observations.
For a fair comparison between groups, use the same measurement units and, where appropriate, the same bin boundaries.

Suppose cells A1:A21 contain the heading Delivery time (minutes) and 20 measurements in A2:A21. Select A1:A21 to include the heading, or select just A2:A21. Excel can use a heading to label the series, but selecting only the numeric observations avoids ambiguity if the heading is missing or unusual. Keep a copy of the original values if you plan to filter or clean the list.

Create the histogram in Excel for Microsoft 365

Select the numeric data, including the header if it has one.
On the ribbon, choose Insert > Insert Statistic Chart > Histogram. In some ribbon layouts, the statistical chart choices appear within the Insert Chart options.
Excel inserts a histogram on the worksheet. Drag its edges to resize it, and move it if it covers the source data.
Use the chart title and axis titles to explain the measure and units. Select the chart, then use the Chart Design and Format tabs to change its appearance or add chart elements.

Excel initially chooses bin groupings automatically. That is convenient for a first look, but the automatic choice is not necessarily the most informative one. A chart with too few bins can hide meaningful structure; too many can make random variation look like a pattern. Review and adjust the grouping before interpreting or presenting the chart.

On Excel for Mac, select the data and use the Insert tab’s statistical chart options to insert a Histogram; the exact grouping or button placement can vary by release. The axis settings are available by selecting or control-clicking the horizontal axis and opening Format Axis. Excel for the web may have a different set of chart controls, so if the bin options are unavailable there, open the workbook in the desktop app.

Set bin width, number of bins, and end bins

To control the grouping in the Windows desktop app, right-click the horizontal axis and choose Format Axis. In the Format Axis pane, open Axis Options and find the Bins settings. Depending on the chart and Excel build, you can specify a Bin width or a Number of bins. These are alternative ways to control the grouping: setting a width defines the size of each interval, while setting a count asks Excel to divide the data into that many intervals.

For the delivery-time example, a bin width of 10 minutes makes intervals that are easy to explain to a general reader. A width of 1 minute might produce too many thin columns for a small set of 20 observations, while a width of 30 minutes could conceal differences among short and moderate deliveries. The right choice depends on the purpose, the number of observations, and the scale of the data; there is no single bin width that is best for every histogram.

The axis settings can also include an underflow bin and an overflow bin. An underflow bin groups values at or below a specified cutoff, and an overflow bin groups values at or above a specified cutoff. These options can be useful when a few extreme observations would otherwise stretch the axis and make the main body of the distribution hard to see. Check the displayed labels and included values after setting a cutoff, especially if an observation lies exactly on the boundary.

For a chart comparing two or more populations, use consistent boundaries so the columns represent the same ranges. Separate histograms with different automatic bins may look different simply because Excel grouped them differently. Matching bin width and range makes the visual comparison more meaningful, although differences in sample size can still affect the column heights.

Choose bins that answer the question

Choose a bin width based on what a reader needs to learn, not merely on which setting makes the chart look neat. If a service manager wants to know how many orders take longer than an hour, a boundary at 60 minutes may be particularly useful. If an instructor wants to see whether scores cluster around a pass mark, bins that blur the pass threshold may be a poor fit. A useful histogram makes the important scale and cutoffs visible.

Look at the data range and sample size as a starting point. A narrow range with many observations can support finer intervals than a small sample with only a handful of values. Then inspect the shape under more than one reasonable bin width. If a supposed peak or gap vanishes after a modest change, describe it cautiously; it may be an effect of the chosen grouping rather than a robust feature of the data.

There is a trade-off. Narrow bins preserve detail but can create a jagged chart that overemphasizes small fluctuations. Wide bins smooth the display but can merge separate clusters or hide skew. In a report, state the bin width or show clear interval labels so readers can understand what each column counts. If the chart supports a decision, consider showing the data source, time period, and sample size as well.

Use the Analysis ToolPak when you need a frequency table

The built-in Histogram chart is generally the quickest option when the goal is a chart that updates with its source data. If you also need a frequency table with specified bin limits, Excel’s Analysis ToolPak offers a separate Histogram analysis. The ToolPak output is a table of counts and can optionally include a chart; it is not the same chart object as the built-in statistical histogram.

On Windows, enable the add-in if needed through File > Options > Add-ins. At the bottom, choose Excel Add-ins in the Manage box, select Go, check Analysis ToolPak, and select OK. Then open Data > Data Analysis > Histogram. Specify the Input Range and a Bin Range, choose an output location, and select Chart Output if you want a chart. The bin range contains numeric upper limits for the groups, so sort the limits in ascending order and check the resulting labels and counts. ToolPak results are analysis output; rerun the analysis after changing the source data if the output does not update as needed.

On Mac, the Analysis ToolPak can be managed from Tools > Excel Add-ins, if the add-in is available in that installation. After enabling it, look for Data Analysis on the Data tab. Menu placement can vary with Excel version. If the add-in is unavailable or you only need a visual distribution, use the built-in Histogram chart instead.

Common histogram problems and fixes

The Histogram option is missing: Confirm that the selection contains numeric data and that you are using a desktop Excel version with the statistical chart feature. Check the Insert tab’s chart menus rather than looking for a regular column-chart subtype.
The chart has one bar or an unhelpful number of bars: Open Format Axis and change the bin width or number of bins. Also check that the data values are truly numeric and that the selected range is correct.
The axis shows unexpected groups: Review the units and scale. A mixture of values recorded in seconds and minutes, for instance, does not represent one consistent measurement. Check for outliers and adjust the bins only after confirming the data are valid.
The chart looks like a bar chart: A histogram’s columns represent numeric intervals and normally touch because the ranges are continuous. A bar chart compares distinct categories, such as departments or product names.
The chart does not reflect a revised dataset: Verify that the source range includes the new observations. If rows were added outside the chart’s source range, update the source selection or use an Excel Table as the data source to make expansion easier to manage.

Do not remove a valid outlier just because it makes the chart less attractive. First check whether it is a recording error, a unit conversion issue, or a genuine extreme value. If it is genuine, you can use an overflow bin or a separate view to make the main distribution easier to read, while documenting that choice rather than hiding the observation.

Histogram versus column chart

Both charts use vertical columns, but they answer different questions. A histogram groups numerical measurements into ranges; the order and boundaries of those ranges matter. A column chart compares named categories, and the categories can be rearranged without changing their meaning. For example, ages grouped into 10-year intervals belong in a histogram. Counts by department belong in a column chart, even if the departments happen to be numbered.

A histogram can help reveal a roughly symmetric distribution, a long tail, multiple clusters, or possible outliers, but it cannot prove why the pattern exists. A bimodal-looking shape, for example, may reflect two different populations mixed together, or it may be sensitive to bin choice. Investigate the records and context before drawing a substantive conclusion. For small datasets, a dot plot or a list of the individual values may communicate more than a histogram because each observation remains visible.

Frequently Asked Questions

How do I make a histogram in Excel?
Select the numeric data, then choose Insert > Insert Statistic Chart > Histogram. Use Format Axis to change the bin width or number of bins.

How do I change the bin size in Excel?
Right-click the histogram’s horizontal axis, choose Format Axis, and adjust Bin width under Axis Options. If you prefer to set how many intervals appear, choose Number of bins instead.

Can Excel make a histogram from text categories?
Not as a meaningful numeric histogram. Histograms group numerical measurements into ranges. For categories such as regions or product names, summarize the category counts and use a column or bar chart.

What is the difference between a histogram and a bar chart?
A histogram displays counts for numeric intervals, usually in adjoining columns. A bar chart compares distinct categories, which are separate labels rather than continuous numeric ranges.

Why does my histogram show unexpected counts?
Check the selected range, numeric values, units, bin settings, and any underflow or overflow cutoff. Also confirm that the intervals suit the question and that you are comparing the same boundaries when looking at multiple groups.

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.