Yes. In Excel for Microsoft 365 on Windows, select your numeric data, then choose Insert > Insert Statistic Chart > Histogram. Excel creates the chart automatically; you can then set 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 successive ranges, called bins. Each bar represents one range, and its height represents the number of observations in that range. For example, a histogram of delivery times might show how many deliveries took 0–5 minutes, 5–10 minutes, 10–15 minutes, and so on. The bars usually touch because the ranges are continuous rather than separate categories.
Histograms are useful for spotting the shape and spread of a dataset. A chart may reveal that most values cluster around a typical result, that the distribution has a long tail, or that a few values sit far from the rest. It can also show whether values are concentrated in one range or spread fairly evenly. A histogram does not show the exact value of every observation, so keep the source data available when individual records matter.
Unlike a column chart of named categories, a histogram groups measurements into numeric intervals. That distinction matters: a chart of sales by product is generally a column chart, while a chart of order values grouped into dollar ranges is a histogram.
Create a histogram in Excel for Windows
Put the observations in one column, with one numeric value per row. A heading is useful, but avoid including totals or explanatory notes in the selected range. To create the chart:
- Select the numeric cells, optionally including the column heading.
- On the ribbon, choose Insert > Insert Statistic Chart > Histogram.
- Excel inserts a histogram on the worksheet. Move or resize it as needed, and use the chart title to describe the data and units.
- To change how values are grouped, right-click the horizontal axis and choose Format Axis. In the Format Axis pane, open Axis Options and adjust the bin settings.
The chart is linked to its source data, so changes to the selected values generally update the chart. If Excel treats a header as a data point or the chart appears to include unrelated cells, check the selected range and the chart’s data source. You can select the chart and use Chart Design > Select Data to review or change its source range.
For example, if the values are in A2:A101 and A1 contains the heading Delivery time (minutes), select A1:A101. If the chart does not recognize the heading as a series name, selecting only A2:A101 is a straightforward alternative; add a clear chart title and axis labels so the measurement is still apparent.
Choose a useful bin width or bin count
The bin setting can change the story a histogram appears to tell. Very wide bins can conceal meaningful differences, while very narrow bins can make random fluctuations look like a pattern. Excel chooses an automatic grouping when it first creates the chart, but that default is a starting point, not a rule. To adjust it, right-click the horizontal axis, select Format Axis, and look under Axis Options for Bins.
- Bin width: Sets the size of each interval. This is helpful when a unit has a natural meaning, such as 5 minutes, 10 points, or $100.
- Number of bins: Sets how many intervals Excel uses. This can be useful when you want a particular level of detail, though the resulting interval widths may not match a convenient measurement unit.
- Underflow bin: Groups values at or below a specified boundary into one bin.
- Overflow bin: Groups values above a specified boundary into one bin.
Consider a list of 100 commute times ranging from 3 to 48 minutes. A width of 5 minutes gives a reader a clear, practical scale; a width of 1 minute may produce many small bars, while a width of 20 minutes may hide useful variation. Try a few reasonable settings and choose one that makes the distribution readable without obscuring important detail. If you compare two histograms, use consistent bin boundaries so differences are not caused simply by different grouping choices.
Read and format the chart
Read the horizontal axis as ranges and the vertical axis as counts. A tall bar means many records fall into that interval; a short bar means few do. If the vertical axis shows a count of 12, for instance, that bin contains 12 observations. The total count across bins should correspond to the number of valid numeric observations included, except where settings or source-data issues exclude or group values unexpectedly.
Use a chart title that names the subject and, where helpful, the time period. Axis titles can clarify units: minutes, test scores, or dollars. In Excel, select the chart and use Chart Design > Add Chart Element to add titles or other chart elements. Keep labels legible and avoid decorative effects that make the bar heights harder to compare. If bin labels are crowded, a wider chart or fewer bins may improve readability.
Excel’s bin labels describe the intervals, but do not assume a label alone tells the whole story about a boundary. When exact inclusion rules matter—for example, in a report defining pass bands or service-level thresholds—check how the bins are set and consider creating an explicit frequency table with clearly stated lower and upper limits. A chart is a visual summary, not a substitute for a documented definition.
A practical example with test scores
Suppose a teacher has 40 test scores from 0 to 100 and wants to see whether results cluster around the middle or near the top. With the scores in one column, create a histogram and set a bin width of 10. The chart then groups results into ten-point intervals, making it easier to see whether most scores fall in the 60s, 70s, or 80s. The exact displayed intervals depend on Excel’s bin boundaries, so check the axis labels before describing a particular score range.
If the chart’s automatic settings produce too many narrow bars, a width of 10 may make the overview clearer. If the purpose is to investigate small differences near a cut score, narrower intervals around that part of the scale may be more informative—but they should not be chosen merely to make one group look larger. For comparing classes, use the same bin width and boundary settings for each class. Also consider showing the number of scores in each group, since a chart can look different when groups have different class sizes.
Common problems and how to fix them
- The histogram option is unavailable or disabled: Check that a single numeric data range is selected and that you are using a version of Excel that supports statistical charts. If the command still is not available, try the Analysis ToolPak method described below.
- Bars or intervals look wrong: Look for numbers stored as text, blank cells, error values, or stray entries included in the selection. Convert text-formatted numbers to numeric values and select only the intended observations.
- One bar dominates the chart: A genuine extreme value may stretch the range. Check the underlying records before changing the chart. You can use an overflow bin to group values above a meaningful threshold, but do not discard an outlier simply because it makes the chart less attractive.
- There are too many or too few bars: Open Format Axis and adjust Bin width or Number of bins. Choose a setting that suits the question and label the scale clearly.
- The chart changes when the data changes: That is normally expected because the chart reflects its source range. If new rows are not included, update the chart’s data source or use an Excel table as the source so additions are easier to manage.
One common misconception is that a histogram is just a column chart with touching bars. The appearance is similar, but the grouping is different: a histogram bins quantitative values, while a column chart compares named categories. Changing the order of categories in a column chart is often meaningful; rearranging histogram bins arbitrarily would make the numeric scale misleading.
Native chart, Analysis ToolPak, or frequency table?
The built-in Histogram chart is the simplest choice for most Excel 365 users. It gives a visual result directly from the selected observations and lets you adjust the bins through the axis settings. Excel for Mac also includes histogram chart functionality, though ribbon layout and wording can differ; look under Insert for the Statistical chart options. Excel for the web may present different chart-creation options depending on the available features in that version, so desktop Excel is a reliable choice if you cannot find the histogram command in the browser.
The Analysis ToolPak offers another route and can produce a frequency table as well as a chart. On Windows, enable it through File > Options > Add-ins. At the bottom, set Manage to Excel Add-ins, choose Go, check Analysis ToolPak, and select OK. Then open Data > Data Analysis > Histogram. Enter the input range and, if you want to define your own intervals, a separate bin range; choose an output location and select Chart Output if you want a chart. On Mac, the add-in is managed through Tools > Excel Add-ins, and the available dialog layout may differ.
A frequency table is useful when readers need exact counts by explicitly defined range, or when the chart must follow a particular reporting standard. A PivotTable can also summarize values into groups in some workflows, but it is a different setup and may require grouping the numeric field. Choose the native chart for a quick distribution view, the ToolPak when its output table is useful, and a carefully defined table when precise interval rules are central to the analysis.
Prepare and share reliable results
Before sharing a histogram, confirm what one row represents and whether every observation should count equally. Remove or resolve headers, subtotals, duplicate records, and nonnumeric entries only when the data rules justify doing so. If missing values exist, note whether they were excluded; otherwise, a reader may assume the chart covers every record. For measurements collected over time, check whether mixing different periods would conceal a change in the underlying process.
When the chart supports a decision, include the sample size and the units in nearby text or in the chart title. State the bin width or the interval definition if readers might need to reproduce the result. Preserve the source data and, when appropriate, the workbook’s chart settings. This makes it easier for someone else to verify the totals, understand how boundaries were chosen, and distinguish a real change in the data from a change in the chart’s binning.
Frequently Asked Questions
Can Excel make a histogram automatically?
Yes. Select a numeric range and choose Insert > Insert Statistic Chart > Histogram in Excel for Microsoft 365 on Windows. Excel chooses initial bins automatically, and you can change them through Format Axis.
Can I make a histogram in Excel without the Analysis ToolPak?
Yes. The built-in Histogram chart does not require the ToolPak. Use the add-in only if you want its separate frequency-table workflow or prefer its output options.
How do I change the bins in an Excel histogram?
Right-click the horizontal axis, choose Format Axis, and use the Bins controls under Axis Options. Set a bin width or number of bins; underflow and overflow bins are available for grouping values at the ends.
Can a histogram use text categories?
A histogram is intended for numeric observations that can be grouped into ranges. For names such as products, departments, or regions, use a column or bar chart instead.
Why does my histogram have a different number of bars than expected?
Excel may be using automatic bins, and the chosen width, data range, or extreme values can affect the display. Check the source selection and Format Axis settings, then set a bin width or number of bins that fits your purpose.
Related
- Excel: Why Can’t I Group Columns? Causes and Fixes
- Excel Won’t Group Columns? Causes and Fixes
- Excel Not in Column? Why Data Looks Misplaced
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- How to Put a Pivot Table in Google Sheets: Step by StepTo put a pivot table in Google Sheets, select a cell in your data, choose Insert > Pivot…
- Excel Bar Graph Different Colors: How to Set ThemYes. In Excel for Microsoft 365 on Windows, select the chart’s data series, right-click it, choose Format Data…
- Stacked Waterfall Chart Excel Template: A Setup GuideExcel does not have a separate chart type called a stacked waterfall chart. To make one in Microsoft…
- Excel Pivot Chart: Hide Zero Values the Right WayYes. In Excel for Microsoft 365 on Windows, hide zero-value categories in a PivotChart by applying a value…
- Adding Sparklines in Excel: Steps, Types, and TipsTo add a sparkline in Excel for Microsoft 365 on Windows, select the cell where it should appear,…
- How to Make a Flow Chart in Word Online: Step by StepTo make a flow chart in Word Online, open a document, choose Insert > Shapes, draw and label…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.