How to Make a Proper Histogram in Excel: Step by Step

Charts & pivot tables · Updated November 18, 2026

To make a proper histogram in Excel, put one set of numeric measurements in a column, select the data, then choose Insert > Insert Statistic Chart > Histogram. Adjust the bin width or number of bins, add a clear title and axis labels, and check that the bins show the distribution you want readers to see. A histogram groups numbers into intervals, making it easier to spot the shape, spread, clusters, and unusual values in a data set.

These steps are for Excel for Microsoft 365 on Windows. You will need a worksheet containing numerical observations, such as delivery times, test scores, or product weights. If your data is text categories such as department names, use a bar or column chart instead. Keep the original values in the sheet; the histogram chart calculates the frequencies for you.

What You’ll Need

  • A column of numeric data, with one observation per row. A descriptive heading in the first row is useful.
  • A clear idea of what one observation represents and the measurement units, such as minutes, dollars, or centimeters.
  • Excel for Microsoft 365 on Windows. Histogram charts are also available in recent desktop versions of Excel, though menu labels and options may vary slightly. Excel for the web may not expose every formatting control; use the desktop app if you cannot change bin settings.

Step-by-Step

  1. Arrange and inspect the data. Put the measurements in one column, with no subtotals or merged cells inside the list. For example, use A1 for the heading Delivery time (minutes) and A2:A51 for 50 recorded delivery times. Each row should hold one observation. Remove accidental text entries, check for values stored as text, and decide how to handle blanks or errors before charting. Do not delete valid zeroes: zero is a measurement, not a blank.

    If your worksheet contains several numerical columns, make a histogram for one variable at a time. Combining unrelated measures, such as age and income, would not produce a meaningful distribution.

  2. Select the observations. Click a cell in the data column or select the heading and data together. If the numbers are in a continuous block, clicking any cell within that block is usually enough for Excel to identify it. Check the highlighted range before inserting the chart, especially if adjacent columns contain other data. Including the heading helps Excel use it as a series name rather than treating it as a measurement.

  3. Insert the histogram. On the Windows ribbon, choose Insert > Insert Statistic Chart > Histogram. In some ribbon layouts, the chart option appears in the Charts group under the statistical chart choices. Excel creates a histogram with automatically selected bins. On a Mac, use Insert > Statistical Chart > Histogram where available; wording can differ by release. If the Histogram option is missing, confirm you are using a desktop Excel version that supports statistical charts.

  4. Check that Excel used the intended data. Look at the chart’s horizontal axis and the bars. The horizontal axis should show numeric intervals, and the vertical axis should show counts or frequency. If the chart title or legend contains an unexpected label, or the bars suggest that a heading was counted as a value, right-click the chart and choose Select Data to review the chart data range. Correct the range so it contains only the intended measurement column and, if appropriate, its heading.

  5. Set a useful bin size. Right-click the horizontal axis and choose Format Axis. In the Format Axis pane, open Axis Options and find the Bins controls. Excel can use automatic binning, a specified Bin width, or a specified Number of bins. Choose one setting and enter a value. For example, delivery times recorded in minutes might be easier to read in 10-minute intervals than in many tiny intervals. A bin width of 10 groups observations into ranges 10 units wide; the exact displayed boundaries depend on the data and Excel’s bin placement.

    There is no universally correct number of bins. Too few can hide clusters or peaks; too many can make random variation look like a pattern. Start with Excel’s automatic setting, then compare a slightly smaller and larger number of bins. Keep the setting that makes the distribution readable without concealing important features. For comparisons between groups, use the same bin width and boundaries for every histogram.

  6. Decide how to show extreme values. In the same Axis Options pane, Excel may offer Underflow bin and Overflow bin settings. These group values below or above a boundary into an end bin. Use them when you want to emphasize a practical cutoff or keep a long tail from stretching the axis. Set boundaries deliberately and label the chart so readers understand what the grouped end bars mean. Do not use them simply to hide unusual observations; first check whether those values are valid.

  7. Add an informative title and axis labels. Select the chart, then choose Chart Design > Add Chart Element > Chart Title and pick a placement such as Above Chart. Replace the generic title with a description, for example Delivery times for May. Add axis titles through Chart Design > Add Chart Element > Axis Titles, then select the horizontal and vertical titles. Name the horizontal axis with the measured variable and units, and name the vertical axis Count or Frequency. A reader should not have to guess what one bar represents.

  8. Make the chart easy to read. Resize the chart so the interval labels are legible. Keep the bars visually connected, because a histogram represents continuous numeric intervals rather than separate categories. If the chart has distracting colors, gridlines, or a legend that adds no information, simplify them using the Chart Design and Format tabs. A single data series usually does not need a legend. Avoid 3-D effects, which can make bar heights harder to compare.

  9. Validate the result before sharing it. Compare the chart with the source values. Check that the smallest and largest observations are represented, that the vertical axis is a count or frequency rather than a measurement, and that changing the bin setting has not produced a misleading picture. The total number of observations represented across the bins should match the number of valid measurements, except where you intentionally excluded data or used boundary bins. Add a note if you excluded records or grouped extreme values.

Common Mistakes

Using a regular column chart instead. A column chart compares named categories; a histogram groups numeric measurements into consecutive ranges. A column chart can look similar, but it does not automatically create meaningful numeric bins.

Accepting the automatic bins without review. Excel’s default is a starting point, not a guarantee that the chart communicates the data well. A very wide bin can conceal multiple peaks, while very narrow bins can leave many empty or tiny bars.

Mixing different variables or units. Do not place unrelated columns in one histogram or compare minutes with seconds as though they were the same measure. Convert units consistently and chart one variable at a time.

Removing unusual values without checking them. A high or low value might be a typing error, but it might also be an important real observation. Verify the source record and explain any exclusion rather than deleting a value just because it makes the chart less tidy.

Leaving labels vague. A title such as Results and an unlabeled vertical axis do not tell readers what was measured or what the bars count. Include the variable, relevant period or group, and units where useful.

Tips

  • Choose bins that match the question. A report about the proportion of deliveries within 30 minutes may need a bin boundary that makes that threshold easy to interpret. If exact, custom upper limits are essential, use Excel’s Analysis ToolPak Histogram rather than relying on automatic chart bins. The ToolPak accepts a separate bin range; its bin values act as upper limits for the frequency groups.
  • Use consistent scales for comparisons. When comparing two months or locations, make separate histograms with the same bin widths and boundaries. Different automatic settings can make similar distributions appear unlike each other.
  • Consider whether counts or proportions are more useful. The standard histogram’s vertical axis shows counts. When groups have very different sample sizes, counts can make the larger group look more substantial simply because it has more observations. Consider presenting percentages alongside the chart or clearly stating each group’s sample size.
  • Keep the source data intact. Leave the observations in a clearly labeled range and avoid manually replacing the bars with typed values. Editing the source data should update a chart based on that range, making later corrections easier to track.
  • Use the ToolPak only when it fits the task. To enable it on Windows, choose File > Options > Add-ins. At the bottom, select Excel Add-ins in the Manage box and click Go, then check Analysis ToolPak. After enabling it, use Data > Data Analysis > Histogram. On a Mac, the add-in is managed through Tools > Excel Add-ins in supported releases. The ToolPak produces a frequency table and an optional chart, which is useful for custom bin limits but is less convenient than a linked Histogram chart for routine formatting.

Troubleshooting

The Histogram command is missing. Confirm you are using a supported desktop version and have selected numeric data. Some Excel web or older versions have a different set of chart tools. Open the workbook in desktop Excel for Microsoft 365 and check the Insert tab again. If you need custom bins and do not see a histogram chart option, enabling the Analysis ToolPak is another route.

The chart has one bar or no meaningful intervals. Review the selected range and make sure it contains multiple numeric observations, not a single summarized value or a column of text. Check for numbers stored as text: select the affected cells and use Excel’s warning icon to convert them when offered, or correct the source values. Also confirm that blanks, error cells, and a heading have not been included as data.

The bars look too crowded or too sparse. Right-click the horizontal axis, choose Format Axis, and change the bin width or number of bins. If labels overlap, widen the chart or use fewer bins. If the distribution looks overly compressed, try more bins. Do not change the bin size solely to create a preferred story; use a setting that makes the data interpretable.

Some values seem to be missing. Check the source range, filters, and any underflow or overflow settings. A filtered-out row may not appear as expected, and a boundary bin can group values at the edge. Compare the number of valid records with the sum of the chart’s bar counts. If they do not agree, inspect the data range and any exclusions.

The chart labels the vertical axis incorrectly. Select the chart, add or edit the vertical axis title through Chart Design > Add Chart Element > Axis Titles, and use Count or Frequency. If the axis shows percentages or a different measure, verify that you inserted a Histogram chart and did not select another chart type.

Frequently Asked Questions

What is the difference between a histogram and a bar chart?
A histogram displays the distribution of numeric data in intervals, with bars generally touching. A bar chart compares separate categories, such as departments or product names, and its bars are usually separated.

How many bins should a histogram have?
There is no single right number for every data set. Start with Excel’s automatic choice, then compare nearby settings and select one that shows the distribution clearly. Use the same bins when comparing groups.

Can Excel create a histogram from text categories?
No. The built-in Histogram chart is for numerical measurements. For category counts, first summarize the categories or create a bar or column chart instead.

Can I set exact bin boundaries?
For a standard Histogram chart, use the Format Axis pane to set a bin width or number of bins and, where available, underflow and overflow cutoffs. For a list of exact upper boundaries, use Data > Data Analysis > Histogram with the Analysis ToolPak and provide a bin range.

Why does my histogram change when I edit the data?
The chart is linked to its source range, so Excel may recalculate the bins or bar counts when observations change. If you need stable boundaries for comparisons, set the same bin width and boundary options for each chart, then recheck the displayed range.

Can I make a histogram in Excel for the web?
Available chart and axis controls can vary in the web app. If you can insert a Histogram chart but cannot find the Bins settings, open the workbook in desktop Excel for Microsoft 365 and adjust the axis there.

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.