Excel Histogram: Create, Format, and Choose the Right Bins

Charts & pivot tables · Updated November 21, 2026

Yes. In Excel for Microsoft 365 on Windows, select a column of numeric data, then choose Insert > Insert Statistic Chart > Histogram. Excel creates a chart and groups the values into bins; you can change the bin width or number of bins from the horizontal axis settings.

What a histogram shows

A histogram summarizes the distribution of numerical data. It divides a number range into intervals, called bins, and uses a bar for each interval to show how many observations fall within it. The horizontal axis represents value ranges, and the vertical axis represents frequency, or count. For example, a histogram of delivery times might show how many deliveries took 0–10 minutes, 10–20 minutes, and so on.

Unlike a typical column chart, a histogram’s categories are adjacent numerical intervals, so its bars normally touch. The shape can make patterns easier to see than a long list of measurements: a cluster, a long tail, a gap, or more than one peak may become apparent. A histogram does not show every individual data point, however, and its appearance depends partly on how the intervals are chosen.

Create a histogram with Excel’s chart tool

The built-in Histogram chart is the quickest option for a standard analysis. Begin with one column containing the observations you want to count. Include a clear heading if useful, but avoid mixing the measurements with notes, totals, or other unrelated values.

  1. Select the numeric cells, including the heading if there is one. If the data is in a continuous block, clicking a cell in the column may also let Excel recognize the range when you insert the chart.
  2. On the ribbon, select Insert > Insert Statistic Chart > Histogram. The chart appears on the worksheet.
  3. Click the horizontal axis, right-click it, and choose Format Axis. In the Format Axis pane, find the Bins settings under Axis Options.
  4. Choose a bin setting, such as Number of bins or Bin width, and enter a value that makes the distribution readable. You can also set an Underflow bin or Overflow bin to group values below or above a chosen threshold.
  5. Add a useful chart title and, if needed, axis titles. Select the chart and use the Chart Design and Format tabs to adjust its appearance.

Excel’s automatic bin choice is a starting point, not a guarantee of the best view. Check that the intervals make sense for the question being asked and that the chart is not hiding important structure. If you add or change values in the source range, the chart may update when the range includes those cells; verify the selected data range if new observations do not appear.

Choose a useful bin width

Bin width controls how much numerical territory each bar covers. A smaller width creates more bars and reveals finer variation, but can make random fluctuations look like meaningful patterns. A larger width produces a simpler chart, but may combine distinct groups or conceal a skewed shape. Number of bins controls how many intervals Excel uses across the data range; the resulting width depends on the spread of the values.

Suppose 120 students’ test scores run from 42 to 98. A width of 5 creates intervals that are easy to interpret as score bands, while a width of 20 would make a much coarser summary. If the question is how many students scored in each five-point band, set Bin width to 5. If you are comparing general distribution shapes and do not have meaningful score bands, try a few reasonable bin counts and see whether the broad pattern remains.

Useful choices depend on the data and purpose. Consider:

  • The measurement scale: Use intervals that fit the units. A width of 10 may suit whole-number ages, while a decimal width could make sense for precise measurements.
  • The number of observations: A large dataset can support more intervals than a tiny sample, though there is no universal bin count that works for every dataset.
  • The question: Operational thresholds, such as response-time targets, can make better bin boundaries than arbitrary intervals.
  • Comparisons: When comparing two groups, use the same bin boundaries for both. Different widths can make similar data look unlike, or unlike data look similar.

There is no single ideal histogram for all purposes. Treat bin settings as a transparent presentation choice: if a conclusion changes substantially when you make a modest adjustment, report that sensitivity rather than presenting one chart as definitive.

Format the chart for clear reading

A chart is more useful when readers can tell what was measured and how the intervals work. Replace the default title with a specific one, such as Delivery time in minutes, and add axis titles when units or counts might be unclear. Keep the horizontal labels legible; too many narrow intervals can crowd them.

Click the bars to select the data series, then open Format Data Series if you want to adjust the gap width. Histograms usually communicate their continuous intervals best with little or no visible gap between bars. Avoid decorative effects that make the heights difficult to compare. If you use an underflow or overflow bin, explain what threshold it represents; these bins collect values outside the ordinary displayed intervals.

For a quick visual check, compare the total number of observations with the sum of the bar frequencies. A chart can appear plausible even when the source range accidentally excludes rows or includes an unwanted value. A clear title, stated units, and understandable intervals are more valuable than extra styling.

Use the Analysis ToolPak for a frequency table

The Analysis ToolPak offers a different workflow: it creates a frequency table from upper bin limits and can also produce a chart. It is useful when you want the counts in worksheet cells as well as a visualization, or when you need to specify exact cutoffs. On Windows, enable it through File > Options > Add-ins. At the bottom, set Manage to Excel Add-ins and select Go, check Analysis ToolPak, and select OK. Then open Data > Data Analysis > Histogram.

In the Histogram dialog, set the Input Range to the measurements. Set the Bin Range to a separate column of numeric upper limits arranged in ascending order. Select Labels if the selected ranges include headings. Choose an Output Range or a new worksheet, and select Chart Output if you want Excel to create a chart. The exact dialog labels may vary slightly by Excel release.

ToolPak bins are boundaries, not descriptions of equal-width intervals that Excel invents for you. If the bin limits are 10, 20, and 30, the output counts observations up to 10, above 10 through 20, and above 20 through 30; values beyond the last limit are reported in a More category. Make sure the limits and the resulting categories match your intended interpretation. The ToolPak chart is based on its frequency output, so you may need to adjust labels or formatting for presentation.

On Mac, the ToolPak may need to be enabled through Excel’s Add-ins settings, and availability or dialog details can vary by version. The built-in chart is often the simpler choice when you only need a histogram. Excel for the web has a more limited feature set than the Windows desktop application, so if the Histogram chart command or ToolPak options are unavailable, open the workbook in desktop Excel.

Prepare and check the source data

Histograms are intended for numerical observations. Before creating one, confirm that the selected range contains comparable measurements in consistent units. For example, a column should not mix minutes with hours or temperatures in Celsius with temperatures in Fahrenheit. A text value that looks like a number may not be treated as a measurement, and headers should not be counted as data.

Check for blanks, text entries, errors, duplicates, and values that are outside the plausible range. Do not remove unusual values simply because they make the chart look less tidy: first determine whether they are valid observations or data-entry mistakes. A genuine extreme value can create a long tail or widen the chart’s range. If a value is excluded, document the reason and apply the same rule consistently.

Duplicates are not automatically a problem. If each row is a valid observation, repeated values should contribute repeatedly to the frequency. Similarly, a blank may indicate missing information rather than zero. Replacing missing measurements with zero changes the distribution and can create a misleading cluster at the low end.

Common problems and what they mean

  • The chart command is missing: Confirm that you are using a desktop version that includes the Histogram chart, and select a suitable data range. In Windows desktop Excel, look under Insert > Insert Statistic Chart.
  • The bars look too crowded: Increase the bin width or reduce the number of bins. Then check that any apparent peaks or gaps are not artifacts of the change.
  • Most values fall into one bar: The bin width may be too large, the data range may be unusually broad, or the values may genuinely be concentrated. Inspect the source measurements before changing the chart.
  • Unexpected categories appear: Review the input range for headings, text, blanks, errors, or stray numbers. With ToolPak, also check that the bin limits are numeric and ascending.
  • The chart does not include recent rows: Check the chart’s source range. Data entered outside the selected range may not be included automatically, depending on how the source was selected.

A common misconception is that Excel’s automatically chosen bins reveal the one objectively correct distribution. They do not. Bins are a way to summarize continuous values, and different sensible choices can emphasize different details. For a consequential comparison, show consistent bins across groups and consider checking whether the conclusion holds under another reasonable width.

Histogram chart or another Excel chart?

Use a histogram when the input is a set of numerical observations and the aim is to understand their distribution. Use a column chart when the categories are distinct labels, such as sales by department, and the bars represent separate groups rather than contiguous value intervals. A bar chart of age bands can be appropriate if the bands are predefined categories; a histogram is more suitable when exploring the underlying individual ages.

A box-and-whisker chart, available in current desktop Excel versions, can summarize median, quartiles, and potential outliers more compactly, especially for comparing groups. It does not show the same interval-by-interval counts as a histogram. A scatter chart is better for examining the relationship between two numerical variables, while a line chart is commonly used to show a measure in time order. Choose based on the question, not simply on which chart looks familiar.

Frequently Asked Questions

Can Excel make a histogram automatically?
Yes. Select the numerical data and choose Insert > Insert Statistic Chart > Histogram in Excel for Microsoft 365 on Windows. Excel chooses an initial bin arrangement, which you can refine through Format Axis.

How do I change the number of bins in an Excel histogram?
Right-click the horizontal axis, choose Format Axis, and locate Bins under Axis Options. Select Number of bins and enter a value. To control interval size instead, select Bin width and enter the desired width.

Can a histogram include negative numbers?
Yes. Negative measurements can be included if they are valid for the subject being analyzed. Check that the chart’s range and chosen bins cover them and that a zero-centered or negative distribution is interpreted in the right units.

Why does my histogram have a More bar?
In a ToolPak histogram, More counts observations above the largest supplied bin limit. Add a higher limit or reconsider the boundaries if the category is too broad for your analysis. The built-in chart has separate overflow-bin controls.

What is the difference between a histogram and a bar chart?
A histogram groups numerical values into intervals, and its bars usually touch to show that the intervals form a continuous scale. A bar chart compares separate categories, such as product names, which do not have numerical intervals between them.

Can I make a histogram in Excel for the web?
Some chart capabilities differ between Excel for the web and desktop Excel, and the Analysis ToolPak workflow is a desktop feature. If you cannot find the required Histogram command or settings in the browser, open the file in desktop Excel for the full workflow.

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.