To create a histogram in Microsoft Excel for Microsoft 365 on Windows, select your numeric data, then choose Insert > Insert Statistic Chart > Histogram. Excel creates the chart; you can then adjust the bin width and other settings by right-clicking the horizontal axis and choosing Format Axis.
What a histogram shows
A histogram groups numeric observations into ranges, called bins, and shows how many values fall in each range. The horizontal axis represents the ranges, while the vertical axis represents their counts, or frequency. A histogram can reveal where values cluster, how spread out they are, whether the distribution is skewed, and whether unusually high or low values appear.
For example, a list of 100 delivery times might show how many deliveries took 0–10 minutes, 10–20 minutes, and so on. This makes the overall pattern easier to see than a long list of individual times. Histograms work best with quantitative data that can be meaningfully divided into ordered ranges, such as times, scores, weights, temperatures, or measurements.
A histogram is not the same as a bar chart. A bar chart commonly compares separate categories, such as sales by product, and its bars can be rearranged. Histogram bins represent consecutive numeric intervals, so their order matters and the bars generally touch. If your values are category labels rather than measurements, use a column or bar chart instead.
Create a histogram with the built-in chart
Prepare a single column of numeric observations. A header is fine, but keep it out of the data if you select the numbers alone. Blank cells and nonnumeric entries do not contribute as ordinary numeric observations, so clean the column before charting if those entries represent missing or invalid data.
- Select the numeric cells you want to summarize. If the column has a heading, you can select the heading too; Excel usually recognizes it as a label.
- Choose Insert > Insert Statistic Chart > Histogram. If the chart button is displayed as a gallery, look for the histogram under the statistical chart options.
- Excel inserts a histogram based on its initial bin settings. Click the chart title to replace it with a descriptive title, such as Delivery time in minutes.
- Right-click the horizontal axis labels and select Format Axis. In the formatting pane, open Axis Options to set the number or width of the bins and, when useful, underflow or overflow bins.
- Review the chart against the underlying values. Make sure the bin ranges and counts communicate the question you are trying to answer, then add axis titles or adjust the chart size if needed.
The chart is linked to its source data. If you change a value in the selected range, Excel can update the chart. If you add new observations outside the original selection, however, they may not be included automatically. Convert the source range to an Excel table with Insert > Table before charting if you expect the dataset to grow; check that the chart source expands as intended after adding rows.
Choose a useful bin width
Bin width controls how much numeric ground each bar covers. A narrow width produces more bars and can reveal smaller variations, but it may also make random noise look meaningful. A wide width gives a simpler summary, but can conceal important differences. There is no single best width for every dataset: choose one that makes the pattern readable and fits the question.
In the Format Axis pane, Excel may offer an automatic choice, a specific Bin width, or a Number of bins. Setting a width is useful when the intervals have a natural interpretation, such as 5 minutes or 10 points. Setting a number of bins is useful when you want to control the chart’s overall detail. The exact options shown can depend on the chart and Excel version.
Suppose a class has test scores from 42 to 98. A bin width of 10 might produce ranges around 40–50, 50–60, and so on, making performance by ten-point band easy to interpret. A width of 2 would create many more bars and might be appropriate for a larger dataset, but could distract from the broad pattern in a small class. Try a few reasonable settings and check whether the interpretation changes substantially.
Consider the units and audience as well as the data. For ages, whole-year intervals may make sense; for a measurement recorded to hundredths, grouping by 0.1 may be more readable than showing every hundredth. Keep intervals consistent unless there is a clear reason not to. Comparisons between two histograms are easier when they use the same bin boundaries and widths.
Use underflow and overflow bins
Underflow and overflow bins gather values beyond a chosen boundary into an end group. An underflow bin can collect values at or below a lower cutoff, while an overflow bin collects values above an upper cutoff; check the displayed setting and chart labels to confirm how your Excel version treats the boundary. These options can keep a few extreme observations from stretching the axis and making the central pattern hard to read.
For instance, if most response times are between 0 and 60 seconds but a handful take much longer, an overflow group above 60 seconds can keep the main bins focused on typical responses. This is a presentation choice, not a reason to discard the long times. Label the chart or explain the cutoff so readers know that the final bar combines values rather than showing one narrow interval.
Format the chart for readers
A useful histogram should make its measurement and grouping apparent without requiring readers to guess. Add a chart title that identifies the data, and use axis titles when the units are not obvious. For a chart of exam scores, for example, the horizontal axis might be labelled Score range and the vertical axis Number of students.
- Keep the bins in numeric order. Do not rearrange them as if they were independent categories.
- Use a readable number format and avoid excessive decimal places on axis labels.
- Choose a simple colour with enough contrast against the chart background.
- Reduce unnecessary gridlines or decoration if they compete with the distribution.
- Include the sample size or data period in the title, subtitle, or nearby note when that context affects interpretation.
Excel’s automatic axis scale is a starting point, not a guarantee that the chart is the clearest possible view. Check whether the first and last bins cover the data appropriately and whether labels are legible at the chart’s final size, especially if you plan to paste it into a report or presentation.
Use the Analysis ToolPak as an alternative
Excel’s Analysis ToolPak offers a different way to calculate histogram frequencies and produce a chart. It is useful when you want to provide your own bin limits or keep a frequency table alongside the graph. On Windows desktop Excel, enable it through File > Options > Add-ins. At the bottom, set Manage to Excel Add-ins, choose Go, select Analysis ToolPak, and choose OK. Then look for Data > Data Analysis > Histogram.
In the Histogram dialog, provide the input range containing the observations and, if desired, a separate range containing the bin limits. Select Labels if the selected ranges include headings. Choose an output location, and select Chart Output if you want Excel to create a chart. The tool can also provide a cumulative percentage output. Bin limits in this tool are upper limits for groups, so arrange them in ascending order and make sure they suit the values being summarized.
On Excel for Mac, the Analysis ToolPak may need to be enabled through Tools > Excel Add-ins; after enabling it, look for the data-analysis command on the Data tab. Ribbon wording and availability can differ by release. Excel for the web has a different interface and may not offer the same ToolPak workflow, so use the desktop app if you need that analysis tool. The built-in chart is generally the more direct option when you simply want a histogram from a selected column.
Prepare data and troubleshoot common problems
If Excel inserts an unexpected chart or the bars do not reflect the values you expect, inspect the source range first. A histogram needs numerical observations, not pre-counted category totals. Check for numbers stored as text, stray headings selected as data, blank rows, or values imported with unexpected units. Dates and times are stored numerically in Excel, but the chart’s interpretation and labels may not be useful unless the underlying values and units are appropriate.
- The chart is missing values: Confirm that every intended observation is inside the chart’s source range and is a real number, not text that looks like a number.
- There are too many or too few bars: Right-click the horizontal axis, choose Format Axis, and adjust the bin width or number of bins.
- Extreme values dominate the scale: Consider an underflow or overflow bin, but disclose what the grouped end bar contains.
- The result looks like a bar chart: Confirm that you selected the Histogram statistical chart type rather than a clustered column chart.
- New rows do not appear: Check the chart’s data source. If the source range did not expand, update it or build the chart from a table.
Also distinguish a count from a percentage. The standard histogram’s vertical axis usually reports how many observations fall in each bin. A taller bar therefore means more observations in that interval, not necessarily a higher individual measurement. If groups have different sample sizes and you need to compare proportions, make that goal explicit and use a suitable normalized frequency approach rather than treating raw counts as directly comparable.
Built-in chart or ToolPak?
Choose the built-in Histogram chart for a quick, editable visual and convenient adjustment of bin settings. Choose the Analysis ToolPak when you need a frequency table based on specified upper limits, cumulative percentages, or a chart generated as part of a broader analysis. Both approaches summarize the same kind of numerical distribution, but their controls and outputs are not identical.
A third option is to create a frequency table manually and chart it, which can help when the bin definitions must be documented or reused exactly. It requires more setup and careful counting, so it is not automatically better. Whichever method you use, state the units, boundaries, and sample being summarized. That context matters more than choosing a particular Excel feature.
Frequently Asked Questions
How do I change the bin size in an Excel histogram?
Right-click the horizontal axis, choose Format Axis, and open Axis Options. Set Bin width to the interval you want, or choose a number of bins. Review the resulting labels to ensure the ranges are sensible for your data.
Can I make a histogram from a frequency table?
The built-in Histogram chart is designed for raw numeric observations, not a table that already lists categories and their counts. For existing bins and counts, use a column chart and format it to resemble a histogram, or use the ToolPak if you want Excel to calculate frequencies from raw values.
Why are my histogram bars not touching?
Check whether you created a Histogram chart rather than a regular column chart. A histogram represents adjacent numeric intervals, so its bars normally touch. If you have a column chart of pre-counted bins, adjust the gap width in the data series formatting to reduce the spaces.
Can I make a histogram in Excel for Mac?
Recent desktop versions of Excel for Mac include histogram chart options, though ribbon labels and layout can vary. Look under the Insert tab’s statistical chart options. The ToolPak has a separate add-in setup through Tools > Excel Add-ins.
What data should I use for a histogram?
Use a set of numerical measurements or observations, such as prices, times, or scores. Each row should represent one observation. If the data consists of named categories such as departments or product types, use a bar or column chart instead.
Related
- How to Unhide Rows in Excel All at Once on Windows
- How to Hide Multiple Columns in Excel at Once: 3 Ways
- How to Hide the Rest of the Columns in Excel
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pivot Table: How to Hide Rows With Zero ValuesTo hide rows whose PivotTable result is zero in Excel for Microsoft 365 on Windows, open the drop-down…
- Excel Histogram: How to Show PercentagesExcel’s built-in Histogram chart shows frequency—the number of observations in each bin—not a normalized percentage option. To show…
- Pivot Table Spill Error: Causes and FixesA PivotTable spill error usually means a dynamic-array formula cannot place its results because the intended spill range…
- How to Make a Pie Chart in ExcelTo make a pie chart in Microsoft Excel for Microsoft 365 on Windows, arrange category names in one…
- Can You Power Pivot Two Excel Sheets? How to Do ItYes. In Excel for Microsoft 365 on Windows, turn each sheet’s data range into an Excel table, add…
- Excel Series Trendline: Add, Choose, and Interpret OneTo add a trendline to a data series in Excel for Microsoft 365 on Windows, select the chart,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.