Add a Histogram in Excel: Create, Format, and Read It

Charts & pivot tables · Updated November 18, 2026

To add a histogram in Excel for Microsoft 365 on Windows, select one column of numeric data, then choose Insert > Insert Statistic Chart > Histogram. Excel creates a chart that groups values into ranges, or bins; you can adjust those bins by formatting the chart’s horizontal axis.

What a Histogram Shows

A histogram summarizes the distribution of one numeric variable. Each bar represents a range of values, and its height shows how many observations fall into that range. For example, a histogram of delivery times can show whether most orders arrive within a few days, whether the times have a long tail, or whether there are unusual delays.

Histograms resemble column charts, but they answer a different question. A column chart usually compares separate categories, such as sales by product. A histogram groups numerical measurements into adjoining intervals, such as sales from 0 to 99, 100 to 199, and 200 to 299. The bars touch because the intervals cover a continuous numerical scale.

The shape can reveal useful patterns that a list of values hides: a concentration around a typical value, a wide spread, a skew toward unusually high or low results, gaps, or multiple clusters. A histogram does not identify individual records, and its appearance depends partly on the chosen bin width. Treat it as a summary, not a substitute for checking the underlying data.

Prepare the Data Before Creating the Chart

Put the measurements in a single column, with one observation per row. A heading such as Delivery days is useful, but keep it in the first row and make sure Excel can recognize it as a label. Avoid mixing measurements with notes, dates stored as text, totals, or unrelated columns in the selected range.

For example, a column containing the number of days taken to complete 40 orders could produce a useful histogram. Include the 40 order-level measurements, not a row that adds them together. A total or average is not another observation and can distort the distribution if it is included.

  • Use numeric values for measurements. Values that look like numbers but are stored as text may not be counted as expected.
  • Check for blanks, error values, and accidental entries such as a zero used to mean missing data.
  • Decide whether extreme values are valid observations. Do not remove them merely because they make the chart look less tidy.
  • If the data is in a table, select the numeric column and its heading. A table can make it easier to maintain the source range when rows are added.

Blank cells are not observations. Text and errors can also cause confusing results or be excluded from the numeric distribution. If the chart seems to omit records, check the source range and the cell values before changing the bin settings.

Create a Histogram with the Built-In Chart

  1. Select the measurement column, including its heading if there is one. If the values are not next to one another, it is usually clearer to copy them into a clean column first.
  2. On the ribbon, choose Insert > Insert Statistic Chart > Histogram. Excel inserts a histogram based on the selected values.
  3. Click the chart title and replace the default text with a descriptive title, such as Distribution of Delivery Times.
  4. To change the intervals, right-click the horizontal axis and choose Format Axis. In the Format Axis pane, look under Axis Options for the bin controls.

Excel chooses an initial grouping automatically. That is a convenient starting point, not a guarantee that the default is the best view for every question. You can select a bin width or number of bins, and, where appropriate, set an underflow or overflow bin. The options shown can depend on the chart and Excel version.

In Excel for Mac, select the data and use the Insert tab’s statistical chart options to choose Histogram; the chart’s axis settings are available through the formatting pane. Ribbon labels and pane layout can differ slightly from Windows. Excel for the web may also have a different set of chart controls, so use the desktop app if the bin options you need are not available.

Choose Useful Bins

A bin is an interval, not an individual category. If delivery times range from 1 to 30 days, a bin width of 5 groups observations into intervals about five days wide. This can make a broad pattern easier to see than a separate bar for every possible day. A smaller width exposes more detail but can make the chart noisy; a larger width gives a simpler overview but can conceal differences.

In the Format Axis pane, select the horizontal axis and review the available bin settings. Depending on the chart, you can set the number of bins or specify a bin width. You can also use an underflow bin to collect values at or below a chosen boundary and an overflow bin to collect values above a boundary. These options are useful when you want to group unusually small or large measurements rather than give them separate intervals.

There is no universally correct bin count. Choose settings that fit the measurement scale and the purpose of the chart. For a first look, compare a few reasonable widths and see whether the central pattern remains understandable. If a conclusion changes dramatically with a small adjustment, mention that the grouping affects the visual impression.

For example, with 40 delivery times spanning roughly 1 to 30 days, bins of 5 days might make it easy to compare the main ranges. If the question is whether delays cluster around particular individual days, a narrower width may be more informative. If readers need to compare the same measure across several months, use consistent bin boundaries in each chart; independently chosen bins can make comparisons misleading.

Use the Analysis ToolPak for a Frequency Table

The built-in chart is generally the quickest option. Excel also has a Histogram tool in the Analysis ToolPak, which is helpful when you need a frequency table alongside a chart or want to define specific upper bounds for the bins. The ToolPak produces a separate output table and chart rather than the same kind of directly linked histogram chart.

If Data Analysis is missing from the Data tab on Windows, enable the add-in through File > Options > Add-ins. At the bottom, choose Excel Add-ins in the Manage box, select Go, check Analysis ToolPak, and select OK. On Mac, use Tools > Excel Add-ins and enable Analysis ToolPak if it is available in your installation.

  1. Choose Data > Data Analysis, select Histogram, and select OK.
  2. Set the Input Range to the measurement cells. Include the heading only if you also select the Labels option.
  3. Optionally set a Bin Range containing the upper limits you want to use. Put those limits in ascending order in a separate column.
  4. Choose an Output Range or a new worksheet, then select Chart Output if you want Excel to create a chart too.
  5. Select OK and review the frequency table and chart. If the output is not as expected, verify the input range, label setting, and bin limits.

For the ToolPak, the bin range is a list of upper bounds, not a list of start-and-end pairs. For example, limits of 5, 10, and 15 define successive groups up to those limits, with an additional category for observations above the last limit. The output table names the groups, so inspect those labels and the values around each boundary when exact classification matters. The ToolPak output is a snapshot: if the source values change, run the tool again to refresh the results.

Make the Chart Easier to Read

A histogram can be technically correct but hard to interpret if its title, scale, or labels are unclear. Give it a title that names the variable and, if useful, the population or period. Axis titles can clarify what the horizontal measurement represents and that bar height is a count. Use a sensible number format: a chart of percentages, for example, should not be labeled as though its axis were a count.

Check that the horizontal axis covers the values readers need to see. An overflow bin can keep a few extreme values from stretching the scale, but it also hides how far those values extend unless you explain the boundary. If the goal is to compare different groups, make their bin widths and boundaries identical. Otherwise, apparent differences may come from the grouping rather than the data.

Keep the chart’s purpose in mind. A histogram shows counts by interval, so it does not show which person or transaction contributed a bar. If readers need to investigate individual records, pair the chart with a filtered data table or another suitable view. When comparing groups of very different sizes, raw counts may not be directly comparable; a percentage-based view or a carefully constructed comparison may better answer the question.

Common Problems and How to Fix Them

  • The histogram option is unavailable. Confirm that you selected numeric data and are using a version of Excel with the statistical chart option. If you need ToolPak output, enable Analysis ToolPak and look under Data > Data Analysis.
  • The chart has too many or too few bars. Right-click the horizontal axis, choose Format Axis, and adjust the bin width or number of bins. Recheck whether the new grouping still makes the underlying pattern understandable.
  • Some observations seem missing. Inspect the selected range for text-formatted numbers, blank cells, errors, or a heading treated as data. Also check whether a limit has placed a value in an underflow or overflow group.
  • The intervals look confusing. Use a measurement scale that makes sense for the data, such as whole days for a whole-day measure. Review the axis labels and, if necessary, test the boundary values in the source data.
  • The chart does not update after using Data Analysis. ToolPak results are generated output, not a live histogram chart. Run the Histogram tool again after changing the source data, or use the built-in chart when you want a chart linked to its source range.

Histogram, Column Chart, or Frequency Table?

Use a histogram when the values are numerical measurements and the question is how those measurements are distributed. Use a regular column chart when the bars represent distinct categories, such as departments or product names. Although both can have vertical bars, a histogram’s adjoining intervals represent ranges on a numeric scale; category bars do not need to touch.

A frequency table is useful when exact counts for each range matter more than the overall shape. The Analysis ToolPak provides that table directly. A built-in histogram is a convenient visual summary and is easier to adjust interactively. Neither format is automatically better: choose the one that lets the reader answer the actual question without hiding important detail.

Frequently Asked Questions

Can Excel make a histogram automatically?
Yes. Select the numeric data, then choose Insert > Insert Statistic Chart > Histogram. Excel creates the chart with initial bins, which you can change using Format Axis.

How do I change the bin size in Excel?
Right-click the histogram’s horizontal axis, choose Format Axis, and look under Axis Options for Bin width. Enter a useful interval for your data. If that option is not shown, check that you selected the histogram axis and that your Excel version supports the setting.

Can I make a histogram with custom intervals?
Yes. The built-in chart allows you to adjust its bins, while the Analysis ToolPak lets you provide a Bin Range of ascending upper bounds. Choose the ToolPak when a frequency table with explicitly defined limits is useful.

Why does Excel show a column chart instead of a histogram?
You may have chosen the regular column chart command rather than the statistical chart command, or your Excel version may not show histogram charts in the same place. On Windows, select the data and use Insert > Insert Statistic Chart > Histogram. A column chart does not automatically group raw measurements into histogram bins.

Does a histogram update when I change the data?
A built-in histogram chart linked to its source range generally reflects edits to that source data. A frequency table and chart created by the Analysis ToolPak are generated output and should be run again when the input changes.

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.