How to Make a Histogram: A Step-by-Step Guide

Key Takeaways

• A histogram groups continuous numerical values into ranges called bins. Touching bars show how often values fall within each range.
• To learn how to make a histogram, start with clean numeric data, choose equal intervals, count values in each interval, and plot those frequencies.
• Bin choices shape what you can see. Compare a second reasonable bin width when the first histogram looks too vague or too busy.
• In Excel, select your data, insert a Histogram chart, and review the horizontal-axis settings rather than accepting the default bins without question.
• Histograms reveal center, spread, skew, gaps, clusters, and possible outliers. A histogram differs from a bar graph in the data it displays and how its bars are arranged.

A histogram can look simple while hiding a surprisingly consequential choice: the bins. Pick ranges that are too broad, and meaningful variation disappears. Pick ranges that are too narrow, and ordinary noise may look like a meaningful pattern.

So, how do you make a histogram you can trust? You prepare one numerical variable, group its values into consecutive intervals, count each interval, and draw touching bars. You will learn the process by hand and in Excel, plus how to read patterns without treating them as proof.

What a Histogram Shows and When to Use One

A histogram shows the distribution of one continuous numerical variable. It divides the variable's range into consecutive bins, then uses each bar's height to represent the frequency within that interval.

The bars touch because each interval connects to the next along a numerical scale. On the horizontal axis, you see value ranges such as 0 to under 10 or 10 to under 20. On the vertical axis, you see a count or percentage.

According to NIST, a histogram can summarize a data distribution for a univariate data set and show its center, spread, skewness, outliers, and multiple modes. Those traits make the chart useful when you want to see how observations are distributed, rather than only calculating an average.

For example, an average support-response time cannot show whether most tickets receive similar service or whether the data splits into fast and slow groups. A histogram makes clusters, gaps, tails, and extreme values easier to notice.

Use a histogram when your question concerns variation within numeric data. If you need to compare categories, a different chart may fit better. This overview of types of charts and graphs can help you match the display to your question.

A chart should answer the question you actually have, not fill an empty dashboard space. Before building one, ask what you want to learn: Is the data tightly grouped? Does it lean toward higher or lower values? Are there separate clusters worth investigating?

Histogram vs. Bar Graph: The Fast Distinction

The histogram vs. bar graph distinction starts with the data: a histogram organizes continuous numerical values into ordered ranges, while a bar graph compares separate categories.

Suppose you chart delivery times from 0 to under 10 minutes, 10 to under 20 minutes, and so on. That is a histogram because the ranges form one continuous scale. If you compare delivery counts for bikes, cars, and vans, you need a bar graph because the labels are distinct categories.

Prepare Your Data and Choose Useful Bins

Start with one numerical variable, such as order value, response time, test score, or transaction amount. Remove blank cells that do not represent observations, and check for entries stored as text or recorded in inconsistent units.

Next, identify the lowest and highest values so you know the full range. Divide that span into consecutive bins, which are the intervals used to group observations. In most standard histograms, those intervals have equal width so that bar heights are easy to compare.

Frequency is the number of observations in a bin. Bin width is the distance covered by each interval, such as 10 minutes or $25. Together, these choices determine the structure of your frequency table and histogram graph.

Carleton College notes that too few bins can hide important detail, while too many can obscure overall characteristics when choosing histogram bin sizes. You are looking for a view that shows meaningful structure without giving every small fluctuation equal weight.

There is no universal bin count that works for every data set. Begin with a consistent interval that fits the measurement. If the result seems too coarse or noisy, test a second reasonable width.

Context matters here. Five-minute bins may be useful for short support-response times, while hourly bins could erase differences you care about. For broader guidance on matching a display to its purpose, see these ideas for strategic chart selection.

Watch your interval boundaries as well. A value should belong to exactly one bin, so labels such as 10 to under 20 prevent both overlap and double counting. Use the same boundary rule across the full table.

Build a Frequency Table First

A frequency table gives you a checkpoint before you draw the chart. Consider these 12 support-response times, measured in minutes: 4, 7, 8, 12, 14, 16, 18, 21, 24, 27, 31, and 38.

Using 10-minute intervals produces the following counts:

Carleton College's construction process is to select bin ranges, sort values, count points in each range, and plot frequency against the bins. Following those steps helps you build a frequency table that can be checked before any bars are drawn.

Review the total after counting. The frequencies above add to 12, matching the number of observations, which confirms that each response time was counted once. If the totals differ, fix the table before building the chart.

How to Make a Histogram by Hand

Once your frequency table is accurate, drawing the histogram is straightforward. Keep the data, units, interval labels, and frequency counts visible as you work.

1. Sort the values or scan them carefully. Ordered values make it easier to confirm the minimum, maximum, and full range.

2. Create equal, consecutive intervals. Define boundaries clearly so every value fits into one bin and no ranges overlap.

3. Tally each observation once. Check that the sum of all frequencies matches the total number of data points.

4. Label the horizontal axis with the intervals. Include the measured unit, such as minutes, dollars, or points.

5. Label the vertical axis as frequency or percentage. State which measure you use so readers can interpret bar height correctly.

6. Draw touching bars at the correct heights. Keep bar widths consistent because each bin covers the same numerical span.

7. Add a descriptive title. Name the variable and context, such as “Distribution of Support-Response Times.”

Using the worked example, your bars would have heights of 3, 4, 3, and 2. The completed chart would show a concentration below 30 minutes, with fewer observations from 30 to under 40 minutes. With only 12 observations, treat that shape as a description of the sample, not a broad conclusion.

Before you finish, check the construction. The bars should touch, ranges should not overlap, and interval widths should stay consistent. Your labels should also make clear whether the vertical axis reports counts or percentages.

Carleton College describes four histogram construction steps: select bins, sort the data, count values in each interval, and plot frequency vertically against bins horizontally. If you want more context on how chart choices affect interpretation, this data visualization guide covers the wider role of visual displays.

How to Make a Histogram in Excel

Excel can create the bars for you, but your judgment still matters. According to Microsoft, to create a histogram in Excel, select the numeric data, choose Insert > Insert Statistic Chart > Histogram, and configure bins through Format Axis.

Begin by placing your numerical observations in one column with a clear header. Select the values, insert the Histogram chart, and click the horizontal axis when you want to adjust how Excel groups the data.

In Format Axis, the settings you are most likely to use include:

• Automatic lets Excel choose the bin arrangement.

• Bin width sets the numerical size of each interval.

• Number of bins sets how many intervals appear.

• Underflow bin groups values at or below a boundary you choose.

• Overflow bin groups values above a boundary you choose.

Automatic binning is a useful starting point, but it should not make the final decision for you. Compare the chart with your data question, then adjust the width or number of bins if the pattern looks overly smooth or needlessly jagged.

Underflow and overflow bins can be helpful when the central range deserves attention and values beyond set thresholds can be grouped. Label the chart clearly, though, because grouped extremes may hide differences among the values they contain.

You should also confirm the source cells and scan for blanks, text values, or mixed units. A polished chart cannot correct inconsistent input. Once the histogram is readable, interactive data visualizations can support natural follow-up questions about the segments behind a pattern.

Read the Shape Before You Act on It

After you make a histogram, look at the whole shape before focusing on one bar. Where is the main concentration, how wide is the spread, and do any gaps or isolated bars stand out?

Inspect the full shape for patterns that deserve a closer look, then return to the underlying data with a focused question. A histogram helps you decide where to investigate, not what caused the pattern.

Still, a histogram shows a pattern, not its cause. Two peaks in response times could reflect ticket priority, staffing periods, customer type, or another factor. The chart tells you where to ask a sharper question.

That next question might compare time periods, inspect a segment, or review the records within an unusual bin. When you drill into your data, keep the original measurement and bin rules visible so the follow-up analysis stays connected to the pattern you noticed.

Check whether the shape changes under another sensible bin width. If a striking feature disappears after a modest adjustment, treat it cautiously. When a pattern remains visible across reasonable choices, you have a stronger basis for further investigation.

Build the Chart, Then Ask the Next Question

Now you know how to make a histogram: prepare one numerical variable, choose sensible bins, and count each interval. Then plot the frequencies as touching bars. Whether you work by hand or in Excel, reviewing the bin choices is part of the analysis.

A well-made histogram helps you see where values gather, how widely they vary, and which observations deserve attention. Use the chart as a starting point, then explore interactive visualizations to examine the segments, periods, or records behind the shape.