Histogram in Excel: Video Guide and Steps

Charts & pivot tables · Updated November 21, 2026

If you’re looking for a histogram Excel video, the essential steps in Microsoft 365 for Windows are to select a column of numeric data and choose Insert > Insert Statistic Chart > Histogram. The guide below walks through the same process, explains how to set useful bins, and covers what to check if your chart looks wrong.

What a histogram shows

A histogram groups numerical observations into intervals, called bins, and displays how many values fall in each interval. It is useful for seeing the shape and spread of a dataset: whether values cluster in one area, form a roughly balanced distribution, have a long tail, or include unusually high or low observations. For example, a list of 100 delivery times could be grouped into intervals such as 0–10, 10–20, and 20–30 minutes.

A histogram resembles a column chart, but the bars represent consecutive numeric ranges rather than separate categories. The bars usually touch because the intervals are continuous. A column chart is more appropriate for comparing distinct categories, such as sales by product. A histogram is intended to show the distribution of numerical measurements, such as scores, weights, waiting times, or monthly usage.

Create a histogram in Excel

For the built-in chart, put the observations in one column, with one number per row. A descriptive heading in the first cell is helpful, but keep notes, totals, and other unrelated figures outside the selected data range. Then use these steps in Excel for Microsoft 365 on Windows:

  1. Select the numeric values, including the heading if there is one.
  2. Choose Insert > Insert Statistic Chart > Histogram.
  3. Excel inserts a chart. Select its title to replace the default wording with a useful description.
  4. If the grouping is not suitable, right-click the horizontal axis and choose Format Axis. In the Format Axis pane, adjust the bin options.

The chart updates as you change the settings. If your selection contains a heading, Excel generally uses it as the series name; including a heading makes the chart easier to identify later. To make a histogram from several distinct data columns, create and review one series at a time or use the Analysis ToolPak method, which offers more explicit input and bin ranges.

On Excel for Mac, the chart is also available from the Insert tab in the chart options, though the ribbon layout and pane labels can differ slightly by release. Excel for the web has a different interface and may not show every desktop control in the same place. If a specific axis option is missing, open the workbook in the desktop app.

Choose bins that make the pattern readable

Bins determine how detailed the histogram appears. In the Format Axis pane, Excel lets you set a bin width or a number of bins. It also provides underflow and overflow bins, which can group values below or above a boundary into one end category. Those settings are useful when a few extreme values would otherwise stretch the scale and make the main distribution hard to inspect.

There is no universally correct bin count. Too few bins can hide important differences: a dataset with two clusters might look like one broad mound. Too many bins can make ordinary random variation look like a meaningful pattern. Start with a sensible width based on the measurement and the question. For test scores recorded in whole points, a width of five or ten points may be easier to interpret than a width of 0.37. For time measurements, intervals of five minutes may make more sense than intervals of one second.

Check the horizontal-axis labels after changing the settings. The intervals should be easy to read and should fit the precision of the source data. If the values are mostly whole numbers, highly precise decimal boundaries may create an unnecessarily technical chart. Also consider the number of observations: a tiny sample divided into many bins will leave several bars with very few values, while a large dataset can often support more detail.

Read the chart with a concrete example

Imagine a class has 30 quiz scores between 40 and 100. With bins ten points wide, the bars show how many students scored in ranges such as 40–50, 50–60, and 60–70, continuing across the score range. A tall bar indicates that many scores fall in that interval; it does not mean that the interval itself is a separate group of students. The total count across the bins should correspond to the valid numeric observations included in the chart.

Look at the overall shape before drawing conclusions. A single high bar may indicate a common range, while a long run of bars toward one end can suggest a skewed distribution. A gap may be real, but it can also result from a small sample or a poorly chosen bin width. A histogram can help reveal patterns; it does not explain why they occurred. For example, a cluster of low scores cannot by itself show whether the cause was a difficult topic, missed classes, or another factor.

Histogram chart or Analysis ToolPak?

The built-in Histogram chart is the quickest choice when you want Excel to create bins and draw a chart from a selected column. It is convenient for an exploratory view, and you can revise the bin settings from the axis pane. The Analysis ToolPak is an alternative when you want to provide your own bin boundaries and produce a frequency table along with a chart.

To enable the ToolPak in Excel for Microsoft 365 on Windows, choose File > Options > Add-ins. At the bottom, next to Manage, select Excel Add-ins and click Go. Check Analysis ToolPak and choose OK. Then select Data > Data Analysis > Histogram. Enter the input range and, if you have prepared boundaries in a separate column, the bin range. Choose an output location and select Chart Output if you want a chart as well. The dialog labels and availability can vary in other Excel editions; on Mac, manage Excel add-ins through Tools > Excel Add-ins.

ToolPak bin values act as upper limits for the groups, so prepare and label them deliberately and check the resulting frequency table. The ToolPak chart and the built-in chart may not use identical default groupings. If consistent bins are important for comparing datasets, use the same boundaries for each dataset rather than accepting separate automatic choices.

Format the chart so it communicates clearly

A useful histogram should tell readers what was measured and in what units. Give it a specific title, such as Quiz scores in points, and label the axes where the meaning is not obvious. The horizontal axis represents value intervals; the vertical axis represents frequency, or the number of observations. If you are reporting percentages rather than counts, make that clear and verify that your chart is actually showing percentages.

Keep formatting restrained. A clear scale and readable bin labels are more valuable than decorative effects. If you change the chart’s colors, maintain enough contrast and avoid implying that different colors represent different categories unless that is what the data show. When copying a chart into a report, check that the labels remain legible at the size readers will see.

Common histogram problems

  • The chart option is unavailable or produces an unexpected result: check that the selected range contains numerical observations, not a column of labels alone. Remove unrelated totals or other data from the selection.
  • There is a large gap or an unexpected bar: inspect the source values for unusually large or small observations, and review the underflow and overflow settings. Do not remove an outlier just to make the chart look neater; first determine whether it is a valid measurement or a data-entry error.
  • The bars look too wide or too narrow: right-click the horizontal axis, choose Format Axis, and adjust the bin width or number of bins. Look for a grouping that makes the pattern understandable without hiding useful detail.
  • Some observations appear to be missing: check for blanks, numbers stored as text, error values, or rows excluded from the selected range. Correct the source data as appropriate, then recreate or refresh the chart.
  • The chart looks like a regular column chart: confirm that you inserted the Histogram chart type rather than a clustered column chart. A histogram groups numeric values into intervals; a column chart compares named categories.

Before presenting a histogram, compare the number of plotted observations with the number of valid records you expected to include. A chart can look plausible even when the selected range omitted the last few rows or included an extra summary value.

Finding a useful Excel histogram video

A good video tutorial should match your Excel version and show the actual ribbon or menus, not just display a finished chart. Search for terms such as Microsoft 365 Excel histogram chart, Excel histogram bin width, or Excel Analysis ToolPak histogram. Prefer a tutorial that demonstrates the data layout, the chart insertion path, and how to change bins; these details answer the practical questions that a short overview may skip.

Check whether the presenter is using Windows, Mac, or Excel for the web, since menus can differ. Also note whether the demonstration uses the built-in chart or the ToolPak. Both methods can make a histogram, but their setup and bin controls are not identical. If the video uses a much older Excel release, the general idea may still apply while the ribbon labels and chart tools have changed.

Frequently Asked Questions

How do I make a histogram in Excel?
Select the numerical data, then choose Insert > Insert Statistic Chart > Histogram. Adjust the grouping by right-clicking the horizontal axis and selecting Format Axis.

Why can’t I see Histogram under Insert?
Check that you are using a desktop version of Excel that supports the statistical chart and that you selected a suitable numeric range. The web and Mac interfaces can differ from Windows; opening the file in Microsoft 365 for Windows may make the documented controls easier to find.

What is the difference between a histogram and a bar chart?
A histogram counts numerical observations inside value intervals, so its bars normally touch. A bar chart compares separate categories, such as departments or product names, and its bars usually have spaces between them.

How many bins should I use?
There is no fixed best number. Choose boundaries that fit the scale and size of your dataset, then compare a slightly coarser or finer grouping to see whether the main interpretation changes. Explain the bin width when readers need to reproduce or assess the result.

Can Excel make a histogram with custom intervals?
Yes. In the built-in chart, adjust the bin settings in Format Axis. For a frequency table based on specified boundaries, use Data > Data Analysis > Histogram after enabling the Analysis ToolPak, then supply a bin range.

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.