How to Make a Histogram in Excel (and a Faster Way)

Excel can build a histogram, but it does not make it obvious. The feature moved around across versions, the bin settings are buried, and the first chart you get out of it usually looks nothing like what you pictured. This walks through the two ways that actually work, the settings people miss, and when it is faster to skip Excel entirely.

First, what you need in the sheet

A histogram needs one column of numbers. Not a summary, not counts, just the raw values, one per row. Put a header in the top cell like "Value" so Excel labels the axis, then list every data point below it.

If your data is already summarized into groups and counts, that is a frequency table, not raw data, and Excel's histogram tools will not read it the way you want. In that case you are really making a column chart of a table you already have. The difference between the two is worth knowing, and the frequency distribution table page lays it out.

Method 1: the built-in histogram chart

Modern Excel, meaning 2016 and later plus Microsoft 365, has a histogram chart built into the ribbon. This is the quickest native route.

Select your column of values, header included. Go to the Insert tab, find the Charts group, and click the icon for statistical charts, the one that looks like a small histogram. Pick Histogram from the menu. Excel drops a chart onto the sheet with its own automatic bins.

Those automatic bins are almost never what you want, and this is the step everyone misses. Double-click the numbers along the horizontal axis to open the Format Axis panel. There you can set Bin width to a round number, or set Number of bins directly, and toggle overflow and underflow bins to gather the extremes into a single bar on each end.

Bin choice changes the whole story a histogram tells, so do not accept the default. Too few bins hides the shape, too many shatters it into noise. The walkthrough on how many bins a histogram should have covers how to land on a sensible number, and how to choose bins gives the quick version.

Method 2: the Analysis ToolPak

Older Excel, or anyone who wants a frequency table alongside the chart, can use the Analysis ToolPak. It is an add-in that ships with Excel but sits switched off by default.

Turn it on first. Go to File, then Options, then Add-ins. At the bottom, next to Manage, choose Excel Add-ins and click Go. Tick Analysis ToolPak and press OK. A new Data Analysis button appears on the Data tab.

To use it, you usually build a bin column yourself. In an empty column, list the upper edge of each bin, for example 10, 20, 30, and so on up past your largest value. Then click Data Analysis, choose Histogram, set the Input Range to your data, set the Bin Range to that column of edges, tick Chart Output, and click OK.

The ToolPak returns a small table of bins and counts plus a chart. The upside is you get the actual frequency numbers, not just bars. The downside is the chart comes out as a plain column chart with gaps between the bars, which is technically wrong for a histogram since the bars should touch. You fix that by right-clicking a bar, opening Format Data Series, and setting Gap Width to zero.

The settings people get wrong

A few things trip people up no matter which method they use.

Gaps between bars. Histogram bars represent a continuous range, so they should sit flush against each other. If yours have gaps, set the gap width to zero. A chart with gaps reads as a bar chart, which answers a different question. The distinction is spelled out in histogram vs bar chart.

Uneven bins. Excel lets you set one bin width for the whole chart, which is what you want. Hand-built bin edges of uneven size distort the bars, since a wider bin naturally catches more values and looks taller than it should.

Blank cells and text. A stray label or empty cell inside the data range can throw off the counts or break the chart. Keep the value column clean, numbers only, before you start.

Reading the result. Once the chart is built, the job is to read it, not just admire it. Run the center, spread, shape check from how to read a histogram so the chart actually tells you something.

When Excel is the wrong tool

Excel is fine when your data already lives in a spreadsheet and you only need one chart. It gets tedious fast when you are iterating, because every bin change means clicking back into the Format Axis panel, and sharing the result means exporting an image or sending the whole file.

If you just want to see the shape of a column of numbers, a paste-in maker is quicker. Copy the column, paste it into the histogram maker, and the chart appears with bin controls right next to it, so you can slide the bin count and watch the shape change in real time instead of digging through menus. There is a plain guide to that flow at how to make a histogram if you want the steps.

It also sidesteps the two Excel headaches. Bars touch by default, and there is no add-in to enable. For a one-off read of some numbers, it is the difference between ten seconds and ten minutes.

The short version

Excel makes histograms two ways. The built-in statistical chart in Excel 2016 and later is fastest, just remember to open Format Axis and set the bin width yourself. The Analysis ToolPak works on older versions and hands you a frequency table too, but you have to enable the add-in and close the gaps between the bars afterward. Either way, the bins decide the story, so never trust the default. And if you are only trying to see the shape of a column of numbers, pasting it into an online histogram maker skips the menus entirely.