Histogram in Excel: Step-by-Step Guide

To make a histogram in Excel for Microsoft 365 on Windows, put your numeric observations in one column, select the data, then choose Insert > Insert Statistic Chart > Histogram. Excel creates bins automatically; right-click the horizontal axis and choose Format Axis to adjust the bin width or number of bins.

What a histogram shows

A histogram groups numerical measurements into intervals, called bins, and shows how many observations fall in each interval. The horizontal axis represents the value ranges; the vertical axis represents the count or frequency. Because the bars represent neighboring ranges on a number scale, they normally touch. This makes a histogram useful for spotting where values cluster, how widely they vary, and whether a distribution has a long tail or more than one peak.

For example, a list of delivery times might be grouped into ranges such as 0–9, 10–19, and 20–29 minutes. The height of each bar tells you how many deliveries took that long. A histogram is not the same as a chart of individual values: it summarizes the data, so you cannot identify a particular observation from a bar alone.

Prepare your data

Put the measurements you want to analyze in a single column or row. A heading such as “Delivery time (minutes)” is helpful, and keeping the observations together makes the range easy to select. Use one row per measurement rather than combining values into a sentence or splitting them across unrelated columns.

Use numeric values in a consistent unit, such as minutes, dollars, or centimeters.
Check for numbers stored as text, stray spaces, and notes mixed into the measurement cells.
Decide what to do with blanks or invalid entries before charting; they are not meaningful measurements.
Keep the original observations unchanged so you can check the chart against the source data.

Here is a small example: enter a heading in A1 and measurements in A2:A21. The values could be delivery times such as 12, 15, 16, 18, and 19, followed by additional observations. Select the heading and values together if you want Excel to use the heading as the series name. If the chart treats the heading as data, undo the chart and select only the numeric cells instead.

Create the histogram step by step

Select the data. On the worksheet, select the heading and the numeric observations, or select only the numeric cells if you do not have a heading. Avoid selecting blank columns or unrelated values.
Insert the chart. Choose Insert > Insert Statistic Chart > Histogram. Excel places a histogram on the sheet and assigns an initial set of bins. If you do not see the chart option, check that the selected range contains numerical data and that you are using a desktop version of Excel with the statistical chart command available.
Review the axes. The horizontal axis should show intervals or bin boundaries, while the vertical axis should show counts. If the chart title is generic, click it and type a descriptive title, such as “Delivery times by 10-minute range.”
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 controls. Set a Number of bins or a Bin width, depending on which approach suits your data.
Check the result. Confirm that the bars cover the full range of your observations and that the grouping is readable. Compare the total number of observations represented by the bars with the number of valid measurements in your source data.
Finish the presentation. Use the Chart Design and Format tabs to adjust the chart’s appearance, add or edit a chart title, and resize it. Keep labels and units clear so the chart can be understood without guesswork.

Excel for Mac has a similar chart feature; depending on the version, use Insert > Statistical Chart > Histogram. The chart options are also available by selecting or right-clicking the horizontal axis, although pane labels and ribbon layouts can differ slightly from Windows. Excel for the web may have fewer editing controls than the desktop app.

Choose bin width or number of bins

The bins determine how much detail the histogram shows. A small bin width creates many narrow bars and can reveal local patterns, but it may make ordinary variation look noisy. A large width creates fewer bars and a simpler picture, but can conceal meaningful differences. There is no single best setting for every dataset; choose one that helps answer the question you are asking.

In the Format Axis pane, the Number of bins setting tells Excel how many groups to make. Bin width instead specifies the size of each group in the units used by the data. Changing one setting can change the other because the number of groups depends on both the width and the data range. Excel’s automatic choice is a starting point, not a rule about what the data means.

The same pane may offer Underflow bin and Overflow bin settings. These options group values below or above a threshold into an end category, which can be useful when a few unusually small or large observations would otherwise stretch the axis. Check how the chart labels the resulting groups and make the thresholds clear to readers.

Work through a simple example

Suppose a worksheet contains 20 delivery times ranging from 12 to 51 minutes. You want to compare how often deliveries fall into roughly 10-minute spans. After inserting the histogram, set a bin width of 10 in Format Axis and inspect the horizontal-axis labels. Excel chooses the actual bin boundaries for the chart; do not assume that the labels automatically correspond to neatly rounded ranges such as 10–19 or 20–29.

For an independent check, you can count observations into ranges using a separate frequency table, provided you define the boundaries yourself. For example, a table that explicitly counts 10–19, 20–29, 30–39, 40–49, and 50–59 creates five clearly defined groups. If those groups contain 5, 6, 5, 3, and 1 deliveries respectively, their counts add to 20, matching the number of observations. The table is a useful check, but its boundaries may not match Excel’s automatically positioned histogram bins exactly. If exact categories are essential, document the chosen limits and use a frequency table or another chart built from those fixed categories.

Read and label the chart carefully

Look first at the overall shape rather than treating every bar as a separate conclusion. A single concentration of tall bars may indicate a common range; a long run of smaller bars on one side may suggest skew. Two separated clusters can mean that the data combines different groups, such as weekday and weekend deliveries. These patterns are clues to investigate, not proof of a cause.

Make the chart self-explanatory. Include the measured quantity and unit in the title or axis labels, and use a vertical-axis label such as “Number of deliveries” if the count is not obvious. If you compare multiple datasets, use consistent bin boundaries so the bar heights are comparable. Different widths can make two distributions appear more different or more similar than they really are.

Common problems and fixes

The histogram command is unavailable. Confirm that you selected numerical observations and are working in a version of Excel that includes histogram charts. If you are using a browser, try the desktop Excel app for more complete chart controls.
The chart has unexpected bins. Select the horizontal axis, open Format Axis, and set a more suitable bin width or number of bins. Check that the data uses the units you expect; a mix of seconds and minutes, for example, changes the scale.
The chart has too many bars. Increase the bin width or reduce the number of bins. Then verify that the broader ranges still answer the question rather than hiding useful variation.
The chart has only a few bars. Reduce the bin width or increase the number of bins, but avoid choosing so many that most bars contain only one or two observations.
Some observations seem missing. Inspect the source range for text-formatted numbers, blanks, errors, or accidental omissions. A histogram can only summarize the usable values in the selected range.
The bars look separated. A histogram’s bars represent adjacent intervals and are ordinarily shown touching. If you have made a column chart from a frequency table instead, adjust the series gap width in the formatting options if you want a histogram-like appearance.

Histogram versus bar chart

A histogram is for numerical data grouped into value ranges, such as ages, scores, or processing times. The order and width of its bins have numerical meaning, and the bars touch to show continuous intervals. A bar chart compares distinct categories, such as product names or departments; its categories are not automatically ordered by numeric range, and spaces between bars are common.

If the question is “How many people scored in each score range?”, use a histogram. If it is “How many sales came from each region?”, use a bar or column chart. A list of already grouped categories can also be displayed as a column chart, but the chart itself will not calculate or manage the numeric bins for you.

Other ways to group values

If you need precise, repeatable intervals, create a frequency table with explicit boundaries and chart that table. This gives you direct control over the categories and makes it easier to compare periods or groups using the same limits. Excel’s Data Analysis ToolPak also includes a Histogram tool; after enabling the add-in, open Data > Data Analysis > Histogram and provide an input range and bin range. It produces a frequency output and can create a chart, but it is a different workflow from inserting a Histogram chart and may be less convenient when you want to adjust bins interactively.

A PivotTable can be another option when you want to group records and explore categories, though its setup differs from a statistical histogram. Choose the method based on whether you need a quick visual summary, fixed boundaries, or a reusable analysis table.

Frequently Asked Questions

How do I change the bin size in an Excel histogram?
Select the horizontal axis, right-click it, choose Format Axis, and open Axis Options. Enter the desired value under Bin width. The width uses the same units as your measurements, so a width of 10 means 10 minutes if the data is measured in minutes.

Can Excel make a histogram automatically?
Yes. Select the numeric data and choose Insert > Insert Statistic Chart > Histogram in Excel for Microsoft 365 on Windows. Excel chooses an initial bin arrangement, which you can change in the Format Axis pane.

Why does my histogram show different ranges than I expected?
Excel determines bin boundaries based on the selected data and chart settings; a chosen width does not necessarily create ranges beginning at the round number you had in mind. Inspect the axis labels, and use a frequency table with explicit limits if exact ranges matter.

Can I make a histogram with text categories?
A standard histogram is designed for numerical values, not labels such as departments or colors. Use a bar or column chart for counts of named categories, or first convert the data into meaningful numerical measurements if that is appropriate.

What is a good number of bins?
There is no universally correct number. Try a few settings and choose one that shows the distribution clearly without reducing it to a handful of bars or making it unreadably busy. Consider the size of the dataset and the question the chart needs to answer.

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.