To create a histogram in Microsoft Excel for Microsoft 365 on Windows, select your numeric data and choose Insert > Insert Statistic Chart > Histogram. Excel groups the values into intervals called bins; you can then change the bin width or number of bins to make the distribution easier to understand.
What a histogram shows
A histogram summarizes how often numeric values fall within defined ranges. The horizontal axis shows the ranges, or bins, and the vertical axis shows the number of observations in each range. For example, a histogram of 100 delivery times might show how many took 0–10 minutes, 10–20 minutes, and so on. It is a way to see the overall shape of a dataset without reading every value individually.
The shape can reveal patterns that a list or average hides. A cluster of tall bars near one end may indicate that most observations are small or large. A long tail can point to a few unusually high or low values. Two separate peaks might suggest that the data combines distinct groups, such as weekday and weekend measurements. A histogram can help you notice these patterns, but it does not explain their cause; that requires checking the underlying data and context.
A histogram is intended for quantitative values, such as ages, weights, scores, or elapsed times. It is not usually the right chart for unrelated categories such as product names. The bars touch because the numeric intervals are continuous. That visual convention distinguishes a histogram from a column chart, which typically compares separate categories.
Create a histogram with the built-in chart
The built-in histogram chart is the simplest option when you want a chart that updates as the source values change. In Excel for Microsoft 365 on Windows, put the observations in one column, with an optional descriptive heading above them. Select the numeric cells, then use these steps:
- Choose Insert > Insert Statistic Chart > Histogram.
- Excel inserts a chart and assigns bins automatically.
- To change the grouping, right-click the horizontal axis and choose Format Axis.
- In the Format Axis pane, adjust the options under Axis Options, including bin width or number of bins.
- Use the chart title and axis titles to explain what the observations and counts represent.
For instance, a column of exam scores can be selected and charted directly. Excel chooses an initial set of ranges, but its automatic choice is only a starting point. If the chart has too many thin bars, the pattern may be hard to see; if it has too few broad bars, meaningful differences can disappear. Review the grouping before using the chart in a report.
In Excel for Mac, use Insert > Statistic Chart > Histogram where the chart command is available; axis settings are still managed through the Format Axis pane, though ribbon placement can differ. Excel for the web has a different interface and may offer fewer chart-formatting controls. If you cannot find the histogram option or need detailed bin settings, open the workbook in the desktop app.
Choose useful bin boundaries
A bin is an interval that collects values. The bin width controls how broad each interval is, while the number of bins controls how many intervals appear. Narrow bins show more detail but can make random variation look important. Wide bins produce a smoother summary but can conceal clusters, gaps, or skew. There is no single bin setting that is best for every dataset, so compare a few reasonable choices and consider what question the chart is meant to answer.
For example, if a dataset contains test scores from 0 to 100, bins of width 10 are easy to explain: 0–10, 10–20, and so forth. A width of 2 may be useful for a larger dataset when fine differences matter, but could make a small class’s results look noisy. For product delivery times, widths should use a sensible unit, such as five minutes, rather than a fraction of a minute that readers cannot act on.
In the Format Axis pane, Excel’s histogram options include setting a bin width or a number of bins. You can also set an underflow bin to group values at or below a chosen threshold and an overflow bin to group values above a threshold. These are useful when extreme values would otherwise stretch the axis or occupy several sparsely populated bins. Check the resulting labels carefully: the selected boundaries determine how observations are grouped.
When choosing bins, consider the size and range of the dataset, the precision that matters, and whether readers need to compare multiple histograms. If you are comparing groups, keep the same bin boundaries across charts. Different automatic bins can make two distributions appear more different—or more similar—than they really are.
Use the Analysis ToolPak for a frequency table
The Analysis ToolPak creates a frequency table and can also produce a histogram chart. It is helpful when you want the counts as worksheet cells, need to choose specific upper limits for bins, or want a cumulative percentage. To enable the add-in on Windows, choose File > Options > Add-ins. At the bottom, set Manage to Excel Add-ins, select Go, check Analysis ToolPak, and select OK. Then choose Data > Data Analysis > Histogram.
In the Histogram dialog, set Input Range to the numeric observations and Bin Range to a separate column of ascending numeric limits. Select Labels if the selected ranges include headings. Choose an Output Range or a new worksheet, and select Chart Output if you want a chart. The Pareto option sorts the bars from most frequent to least frequent; Cumulative Percentage adds a running percentage column. These options are useful for different purposes, so do not select Pareto if the natural order of the bins is important to the question.
ToolPak bins are upper limits, not pairs of lower and upper endpoints. If the bin limits are 10, 20, and 30, the output counts values up to 10, then values above 10 and up to 20, then values above 20 and up to 30. The output includes a final category for values above the largest listed limit. This convention can surprise people who expect to enter labels such as 0–10 directly. Enter numeric limits, then label or explain the resulting ranges clearly.
On a Mac, the add-in is generally managed through Tools > Excel Add-ins, then the Data Analysis command appears on the Data tab when enabled. If your edition or organization does not provide the add-in, the built-in chart or a frequency formula may be a practical alternative.
Build counts with FREQUENCY
Use the FREQUENCY function when you want to control the table yourself or build a chart from worksheet results. It returns the number of values at or below each bin limit, plus one extra count for values above the final limit. This extra result matters: allow one more output cell than the number of bin limits.
For a small example, assume A2:A7 contains 2, 3, 4, 4, 7, and 9, while C2:C4 contains the ascending bin limits 3, 6, and 9. Enter this formula in D2 in Microsoft 365 Excel:
=FREQUENCY(A2:A7,C2:C4)
The result spills into D2:D5 as 2, 2, 2, and 0. The first two observations are at or below 3; the next two are above 3 and at or below 6; the next two are above 6 and at or below 9; none are above 9. The counts add to six, matching the six observations. In Microsoft 365, the formula spills automatically, so leave the cells below D2 clear. Older Excel versions may require selecting the output range first and confirming the formula as an array formula with Ctrl+Shift+Enter.
Once the counts are calculated, select the bin labels and counts and insert a column chart if you want a visual representation. This method gives you explicit control over labels and counts, but you are responsible for keeping the bin limits sorted and making the displayed interval names consistent with the counting rule.
Format and interpret the chart
Give the chart a specific title, such as Delivery Time Distribution, rather than leaving the generic title Excel supplies. Axis titles can identify the measurement and the count of observations. If the chart is for an audience unfamiliar with the data, state the unit in the axis label or title. Avoid decorative effects that make the bars harder to compare.
Read the horizontal axis as ranges, not as individual values. A bar with height 12 means 12 observations belong to that bin; it does not mean the observation at the bin label occurred 12 times. Look for where the tallest bars occur, whether the distribution is roughly balanced or skewed, and whether there are gaps or isolated bars. Then check the sample size and the raw values before drawing conclusions. A histogram is a summary, and bin choices can change its appearance.
If you need percentages rather than counts, divide each bin count by the total number of valid observations, or use the ToolPak cumulative percentage output when that is the quantity you need. Make sure the denominator matches the chart: excluded blanks, text entries, or invalid values should not silently alter the interpretation. For comparisons across groups of different sizes, percentages may be more informative than raw counts, provided the same bin boundaries are used.
Histogram versus a column chart
Use a histogram when numeric observations should be grouped into continuous intervals. Use a column chart when each bar represents a distinct category, such as sales by department or votes by candidate. A histogram’s bins have a numerical order and generally touch; a category chart’s bars commonly have gaps because categories are separate rather than adjacent ranges.
There is also a practical difference in how the data is prepared. The built-in histogram chart groups raw observations for you. A column chart usually expects a table of categories and their values, such as a frequency table. If you already have counts by score band, a column chart may be appropriate, but make the bands explicit and keep their order numeric. Avoid using a histogram for labels that merely look like numbers, such as postal codes or account IDs; those are identifiers, not measurements.
Common problems and fixes
- The chart option is unavailable: Confirm that the selected range contains numeric observations and that you are using a desktop Excel version with histogram chart support. In the web app, open the file in desktop Excel if the needed command is missing.
- There is one bar or too many bars: Right-click the horizontal axis, choose Format Axis, and adjust the bin width or number of bins. Try settings that fit the data’s scale and the intended explanation.
- Unexpected values are missing: Look for numbers stored as text, blanks, headings included in the selection, or values outside a ToolPak bin range. Verify that the source cells are numeric and that the highest bin limit covers the intended range.
- The ToolPak output has an extra row: This is the overflow category for observations above the final bin limit, not necessarily an error. Increase the final limit if those values should be included in a regular interval.
- The chart changes when the data changes: The built-in chart uses its source range, while ToolPak output is a generated analysis result. Rerun the ToolPak analysis after changing observations; check the chart source range if you add rows to the original data.
Frequently Asked Questions
Does Excel have a built-in histogram chart?
Yes. In Excel for Microsoft 365 on Windows, select numeric data and choose Insert > Insert Statistic Chart > Histogram. Use Format Axis to adjust the bins.
How do I change the bin size in Excel?
Right-click the horizontal axis, choose Format Axis, and set Bin width under Axis Options. You can instead set the number of bins or use underflow and overflow bins to group extreme values.
Can Excel make a histogram from text categories?
Not in the usual statistical sense. A histogram groups quantitative numbers into ranges. For categories such as departments or colors, use a column or bar chart instead.
Why does FREQUENCY return one more result than the number of bins?
It returns one count for each bin limit and an additional count for values greater than the final limit. Leave an extra output cell available and label that overflow result if you display it.
Should histogram bars touch?
Usually, yes. The bars represent neighboring intervals on a continuous numeric scale. Gaps are more typical in a column chart of separate categories.
Related
- QuickBooks Excel and CSV Toolkit Cost: What to Know
- Why Excel Files Get Corrupted and How to Prevent It
- Quadrant Scatter Plot in Excel: Create and Format One
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Clustered Column Chart Overlap: Causes and FixesYes—columns in an Excel clustered column chart can overlap when the series overlap setting is above 0%, or…
- Google Sheets Data Chart: Create, Customize, and Fix ItTo make a data chart in Google Sheets, select the cells you want to visualize, then choose Insert…
- OEE Waterfall Chart in Excel: Build and Interpret ResultsTo make an OEE waterfall chart in Excel, put the starting 100% and each staged loss in a…
- Excel Histogram: Create and Format One From Your DataTo create a histogram in Microsoft Excel for Microsoft 365 on Windows, put your numerical observations in one…
- Excel Pie Chart: How to Change the Order of SlicesTo change the order of slices in an Excel pie chart, reorder the category and value rows in…
- Add a Pareto Line to an Excel Bar ChartYes. In Excel for Microsoft 365 on Windows, add a cumulative-percentage column beside your category counts, then use…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.