Histogram vs Bar Chart in Excel: The Real Difference

Histogram vs bar chart is one of the most common chart mix-ups, because both draw rectangles. The real difference is the data behind them. A histogram shows how one set of numbers is spread out, grouped into ranges. A bar chart compares separate categories, such as regions or products. This guide explains how to tell which one a task needs, shows both on the same data, and covers the mistakes that make either chart misleading.

Histogram vs bar chart at a glance#

The table sums up the differences that matter in Excel:

A note on names: in Excel, a bar chart has horizontal bars and a column chart has vertical ones. In everyday speech, "bar chart" covers both, and that's how this guide uses it. A histogram is usually drawn with vertical columns.

What makes a histogram different#

A histogram takes one numeric variable, such as delivery time in minutes, and cuts its range into equal pieces called bins: 20 to 29, 30 to 39, 40 to 49. Each bar shows how many values fall into its bin. Together the bars show the distribution: where most values sit, how spread out they are, and whether there are unusual ones far from the rest.

Because the bins follow each other on one number scale, the bars touch. And because 30 to 39 always comes after 20 to 29, you can't sort the bars by height without destroying the picture. The guide to making a histogram in Excel covers every method in detail.

When to use a histogram#

Use a histogram when you have many values of one measurement and the question is about their spread:

• What is a typical value? Most deliveries take 30 to 39 minutes.
• How much do values vary? Are times tightly grouped or all over the place?
• Are there outliers? One delivery took far longer than the rest.
• Is the shape lopsided? Many small orders and a few very large ones.

The values must be numbers on a continuous scale: times, amounts, weights, scores out of 100. If you're counting categories, you need a bar chart instead.

When to use a bar chart#

Use a bar chart when you compare a value across separate categories:

• Totals by group: sales by region, spend by department.
• Averages by group: average delivery time per region.
• Counts by group: tickets per agent, orders per product.
• Rankings: the five best-selling products, sorted largest first.

The categories have no fixed order, so you can sort them to make the chart easier to read. The guide to making a bar chart in Excel shows how to sort the bars and add labels.

The same data as a histogram and a bar chart#

One table can feed both charts, as long as each answers its own question. Here are seven deliveries in A1:C8:

The histogram: how long do deliveries take?#

Count the Minutes values in each 10-minute bin with COUNTIFS. For the 30 to 39 bin:

=COUNTIFS(C2:C8,">=30",C2:C8,"<40")

The result is 4 (38, 31, 33 and 36). The full bin table:

The counts add up to 7, so every delivery landed in exactly one bin. Using >= at the bottom and < at the top stops a value of exactly 30 being counted twice. Chart the counts as a column chart, then right-click a bar, choose Format Data Series and set Gap Width to 0% so the bars touch. The COUNTIFS function guide and the article on COUNTIFS and SUMIFS with multiple conditions explain the two-condition pattern. For a bin table with percentages and running totals, see the guide to a frequency table in Excel.

In Excel 2016 and later, you can skip the table. Select C1:C8 and go to Insert > Insert Statistic Chart > Histogram (on a Mac, the statistic chart button on the Insert tab). Under Format Axis, set Bin width to 10 and Underflow bin to 29, and the bins become ≤29, (29, 39] and (39, 49], with the same counts of 2, 4 and 1. One difference to watch: the built-in chart includes the upper edge of each bin (the ] in the label), while the COUNTIFS table above includes the lower edge. With whole minutes the two methods agree here, but a value such as 39.5 lands in the (39, 49] bin of the chart and in the 30 to 39 row of the table.

The bar chart: which region is slowest?#

Now ask a category question: what is the average delivery time per region? Use AVERAGEIF for each region, such as =AVERAGEIF(B2:B8,"East",C2:C8):

Chart this as a bar chart, sorted slowest first. Same data, different question, different chart. The histogram says most deliveries take 30 to 39 minutes. The bar chart says East is slowest on average.

Common mistakes#

These are the slips that most often make one chart pretend to be the other:

1. Drawing a histogram from a category column. If you select text, such as the Region column, Excel's Histogram chart switches to By Category bins and counts each name. That's really a bar chart of counts, so make a bar chart.
2. Leaving gaps in a column-chart histogram. Gaps suggest separate categories. Set Gap Width to 0%.
3. Sorting histogram bins by height. The bins must stay in number order or the shape of the distribution is lost.
4. Uneven bin widths. Bins of 0 to 10, 10 to 50 and 50 to 100 make the wide bins look more important. Keep widths equal.
5. Too many or too few bins. With seven values, three bins are plenty. With hundreds of values, ten or more may show the shape better. Try a couple of widths.
6. Charting a raw list in a bar chart. One bar per order, in sheet order, is hard to read. Summarise by category first.

Our recommendation#

Decide by looking at your data. If you have one column of numbers and want to know how they're spread, make a histogram: use the built-in chart in Excel 2016 or later for speed, or a COUNTIFS bin table when you need exact control over the edges. If you have categories and want to compare a value across them, make a bar chart and sort it. When a task gives you both kinds of question, make both charts from the same table, as in the example above. The guide to Excel chart basics has a quick table for picking the right chart for other questions.

Practise it#

Try the exercise on this page to build one histogram bin with COUNTIFS. Then practise COUNTIFS and SUMIFS in a live spreadsheet to fill a whole bin table with locked ranges, and build a pivot-style summary with formulas to create the category totals a bar chart needs.