Histogram in Excel: How to Create One From Your Data

Charts & pivot tables · Updated November 18, 2026

To make a histogram in Excel, put your raw numeric observations in one column, select the values, then choose Insert > Insert Statistic Chart > Histogram. Excel groups the values into intervals, or bins, and displays how many observations fall in each one. You can then adjust the bins and add a chart title so the distribution is easier to understand.

What You’ll Need

  • A desktop version of Microsoft Excel for Microsoft 365 on Windows. The ribbon labels are similar in Excel for Mac, though their placement or wording can vary slightly. Excel for the web may offer fewer chart-formatting controls, so use the desktop app if you need to customize bins.
  • A single column of raw numeric data, such as test scores, delivery times, heights, or item prices. Each row should represent one observation.
  • A clear idea of what the numbers represent and, if possible, the range of values you want to compare. This helps you select sensible bin intervals after Excel creates the chart.

Step-by-Step

  1. Prepare the data. Put a descriptive heading in the first cell of a column, such as Delivery time (minutes), and enter one numeric measurement per row underneath. For example, a list of 18, 22, 19, and 31 represents four individual delivery times. Keep the observations together in one column. Remove blank rows within the list, text notes, and totals that are not measurements. A blank cell or text entry can interfere with the range Excel interprets, while a total can distort the distribution.
  2. Check that the values are numeric. Select a few cells and look at the formula bar or the cell alignment. Numbers often align to the right by default, while text often aligns left, although formatting can change alignment. If entries such as “25 minutes” are stored as text, remove the unit from the cell and put it in the column heading instead. Also check for imported values with leading apostrophes or spaces. A histogram needs measurable numeric values, not categories such as product names or “High,” “Medium,” and “Low.”
  3. Select the observations. Click the first measurement and drag to the last one, including the heading if you want Excel to use it as a series label. Alternatively, click a cell in the continuous data column and press Ctrl+A to select the current data region; check the highlight before continuing, especially if nearby columns contain other data. On a Mac, use Command+A when selecting a current data region. Avoid selecting an entire worksheet column if it contains notes or unrelated numbers.
  4. Insert the histogram. On Windows, open the Insert tab, choose Insert Statistic Chart in the Charts group, and select Histogram. Excel inserts a chart based on the selected numeric values. If you do not see the command, check that you selected numeric observations and that you are using a version of Excel with the statistical chart option. In Excel for Mac, look on the Insert tab for the statistical chart or histogram option; the exact group placement can differ. In the web app, available chart options and formatting controls can vary, so open the workbook in desktop Excel if the histogram option or bin settings are missing.
  5. Check the first chart before changing anything. Excel chooses an initial bin arrangement automatically. The horizontal axis shows value intervals, and the vertical axis shows the count of observations in each interval. Check that the tallest bars and empty intervals make sense for your data. A histogram is a frequency chart: it shows the shape and spread of numerical measurements, not a separate bar for each individual record. If the chart looks like it has only one bar, or the labels seem unrelated to the values, revisit the data selection and chart type.
  6. Set the bin intervals. 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 version and pane layout, you can set a Bin width or a Number of bins. Bin width is the size of each value interval; the number of bins is how many intervals Excel uses. For example, if measurements run from about 0 to 100, a width of 10 creates intervals roughly ten units wide. Try a few reasonable settings and compare the chart rather than assuming the automatic choice is best.
  7. Use boundary bins only when they answer a real question. In the same axis options, Excel can provide an Overflow bin and an Underflow bin. An overflow bin groups values above a boundary; an underflow bin groups values at or below a boundary. These settings are useful when you want to identify unusually high or low values separately, such as response times beyond a service target. They can also hide useful detail if set without a reason. After applying one, read the axis labels and confirm which observations have been grouped at the boundary.
  8. Add labels and make the chart readable. Click the chart title and replace the default wording with a descriptive title, such as Delivery Times by 10-Minute Interval. Include units in the title or axis titles if readers might not know what the numbers mean. To add axis titles, select the chart and use Chart Design > Add Chart Element > Axis Titles in Excel for Windows, then choose the horizontal or vertical title. The ribbon may show Chart Design only while the chart is selected. Keep the vertical axis as a count unless you deliberately need a different measure. Use a legible font and avoid decorative effects that make the bar heights harder to compare.
  9. Review the result against the source values. Confirm that the chart uses the intended column, that its title and units are accurate, and that the chosen bins give enough detail to show meaningful patterns. If you change the underlying observations, Excel usually updates the chart when the values are in its source range. If you add new rows outside that range, check whether the chart includes them; expand the source range if it does not. Save the workbook after the final review.

As a practical example, suppose you record the time taken to complete 40 customer requests. A histogram with 5-minute bins can show whether most requests finish quickly, whether the times cluster around a typical duration, and whether a small group takes much longer. A bin width that is too large may merge the ordinary and unusually slow requests into one bar. A width that is too small may produce many nearly empty bars. The useful setting is the one that makes the pattern visible without implying more precision than the data supports.

Common Mistakes

  • Using a frequency table as though it were raw data. The built-in Histogram chart expects the individual observations, not a list of bin labels beside pre-counted frequencies. If you already summarized the values into intervals and counts, use a regular column chart for that summary, or return to the raw measurements to create the histogram.
  • Including headings, totals, or unrelated cells as observations. A heading is fine when Excel recognizes it as a label, but totals and notes should not be part of the selected numeric range. A stray large total can create an extreme value and make the other bars look compressed.
  • Choosing bins only because the chart looks smooth. Very wide intervals can conceal clusters or outliers; very narrow ones can make random variation look like a pattern. Choose a width that suits the scale and purpose, and explain it in the title or caption when the chart will be shared.
  • Confusing a histogram with a bar chart. Histograms summarize numeric ranges, and neighboring bars normally touch because the intervals form a continuous scale. Bar charts compare distinct categories such as departments or product types. Do not use a histogram for names or categories.
  • Leaving out units or context. A chart titled “Results” does not tell readers whether the values are scores, seconds, or dollars. State the quantity and, where relevant, the interval width.

Tips

  • Keep the original observations in a clearly labeled source column. If you need to try different bin widths, changing the axis settings is easier and safer than rearranging the source data.
  • Start by asking what comparison the chart should support. If you need to compare two groups, make sure each group has enough observations and consider using the same bin boundaries for both; different automatic bins can make distributions look more different than they are.
  • Use a sensible measurement scale. For whole-number ratings, bins that preserve the meaningful rating levels may be clearer than broad intervals. For measurements such as time or distance, wider bins may make sense when the values vary substantially.
  • Check outliers before narrowing the axis or using boundary bins. A genuine unusual value can be important. Do not remove it merely because it changes the appearance of the chart; investigate whether it is a data-entry error first.
  • If the chart is for a report, add a short note explaining the sample or time period. The histogram shows the distribution of the observations you supplied, but it does not explain how they were collected or whether they represent a larger population.
  • For a quick visual check, compare the bars with simple facts about the source data: the smallest and largest values, the number of records, and any known clusters. This can expose a mistaken selection or an unexpected text value before you share the workbook.

Troubleshooting

I cannot find the Histogram command. Confirm that you are on the Insert tab and have selected numeric cells. On Windows, look under Insert Statistic Chart. If you are using an older Excel release, the command may not be available in the same place or at all; update Excel or use a compatible desktop version. Excel for Mac and the web app may arrange or expose chart choices differently.

The chart has one bar, or almost everything falls in one bar. Right-click the horizontal axis, choose Format Axis, and try a smaller bin width or more bins. Then check for a mistakenly included total, a value far outside the expected range, or a text-formatted number. If a single legitimate outlier is stretching the scale, inspect it and decide whether a separate overflow bin helps communicate the result.

The axis labels do not match the intervals I expected. Reopen Format Axis and verify whether you set bin width or number of bins; they are different controls. Read the displayed boundary labels carefully, since Excel’s labels indicate interval cutoffs rather than listing every value inside a bar. If the setting is unclear, try a simple width that divides the data range into easy-to-read intervals, then review the labels and counts.

Some new rows are missing from the chart. The chart may still point to the original range. Select the chart and use Chart Design > Select Data to inspect or update its source range, if that command is available for the chart in your Excel version. Include the newly added measurements but exclude notes or totals. For recurring data entry, consider keeping the observations in a well-formed Excel table so its range can expand as rows are added, then confirm the chart has picked up the expanded source.

The histogram shows unexpected gaps or ignores entries. Check for blank cells, text values, numbers stored as text, and values outside the selected range. A gap can also be a legitimate bin with no observations; it is not automatically an error. Compare the source column with the chart and correct the data only when you have verified what the entry should be.

Frequently Asked Questions

Can Excel make a histogram automatically?
Yes. Select raw numeric observations and choose Insert > Insert Statistic Chart > Histogram in Excel for Microsoft 365 on Windows. Excel creates an initial chart and chooses bins automatically. You can change the bin width or number of bins through Format Axis.

What is the difference between a histogram and a bar chart?
A histogram groups numerical values into intervals and counts how many fall in each interval. A bar chart compares separate categories. Histogram bars usually touch to show that the numerical intervals are continuous; category bars are often separated.

How many bins should I use?
There is no single best number. The right choice depends on the number of observations, their spread, and what you want the chart to reveal. Begin with Excel’s automatic setting, then try a few alternatives. Avoid settings that hide meaningful variation or leave most bins empty.

Can I create a histogram from a table of counts?
The built-in Histogram chart is designed for raw observations, not pre-counted frequency data. If your table already lists intervals and counts, use a column chart to display those summaries. If possible, use the original observations to let Excel calculate the histogram counts.

Why are my histogram bars not touching?
Check whether you inserted a Histogram chart rather than a regular column chart. Histogram intervals are continuous and their bars normally touch. If you are displaying a frequency table with a column chart, the spacing is controlled by that chart’s formatting and does not make it the same as a histogram.

Related

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.