How to Draw a Histogram | Step-by-Step for Any Dataset

A histogram is a bar-style display that shows how numerical data distributes across equal-width intervals, with bar heights matching how many values fall in each bin.

One glance at a histogram tells you whether your data clusters in the middle, spreads evenly, or piles up at one end. The process is the same whether you’re sketching by hand or building one in Excel: divide the range into equal-width bins, count observations, and draw adjacent bars whose heights reflect those counts. This walkthrough covers both methods so you can produce a clean, accurate histogram from any quantitative dataset.

What Exactly Is a Histogram?

A histogram groups a set of numbers into intervals — called “bins” — and plots each bin as a bar whose height equals the number of data points that fall inside that interval. The bars touch each other, which is the visual cue that the x-axis represents a continuous range of values rather than separate categories. You use a histogram when you want to see distribution shape, center, and spread at a glance.

Histograms work for both discrete data (whole numbers like test scores) and continuous data (measurements like height or time). The key rule: all bins should be the same width unless you have a specific statistical reason to vary them.

How to Draw a Histogram by Hand in 5 Steps

Step 1: Create Equal-Width Bins

Look at your data’s minimum and maximum values. Subtract the smallest value from the largest, then divide that range by the number of bins you want — typically 5 to 10 bins works well for most datasets. Round up to a convenient number so each bin is the same size. For example, scores ranging from 40 to 100 with 6 bins would give you a bin width of 10 (60 ÷ 6 = 10), producing bins of 40–49, 50–59, 60–69, 70–79, 80–89, and 90–100.

Write your bin intervals in order from lowest to highest. Remember that each bin includes values from its lower bound up to — but not including — the upper bound, except for the final bin which includes both endpoints.

Step 2: Tally Frequencies in a Frequency Table

Build a simple frequency table with two columns: “Bin Interval” and “Frequency (Count).” Go through your raw data one value at a time and place a tally mark in the bin it belongs to. After the last value, add up the tallies and write the total count for each bin.

Skipping the frequency table and trying to draw bars directly from raw data is the most common source of counting errors. The extra minute spent here saves you from redrawing.

Step 3: Label Both Axes Correctly

The horizontal (x) axis gets your bin intervals — write them in order from left to right. The vertical (y) axis represents frequency, meaning the number of observations that fell in each bin. Scale the y-axis so it reaches a bit above your tallest bar’s count.

Include the unit of measurement on the x-axis when it helps (“Score on Final Exam”) and use “Frequency” or “Count” on the y-axis.

Step 4: Draw Adjacent Bars

For each bin interval, draw a rectangle whose height matches that bin’s frequency. The bars must touch each other — this is the visual difference between a histogram and a bar chart. A bar chart leaves gaps between categories; a histogram’s touching bars signal that the horizontal axis is a continuous range.

Draw each bar’s width so it exactly spans its bin interval on the x-axis. If your first bin is 40–49, the bar’s left edge sits at 40 and its right edge at 50 (because 50 is the start of the next bin).

Step 5: Add a Title and Units

A clear title tells readers what the data represents, like “Distribution of Final Exam Scores.” Add the unit label on each axis if it isn’t already obvious from the bin labels. That’s it — your histogram is complete.

How to Build a Histogram in Excel (Built-In Chart Method)

Excel’s built-in Histogram chart type, introduced in Excel 2016, is the simplest route for current versions. Open your dataset in a worksheet with one column for values, select the data range, then go to Insert > Insert Statistic Chart > Histogram. Excel will create a histogram with automatically chosen bins.

To customize binning, right-click the horizontal axis and select Format Axis. Under Axis Options, you can set Bin width to a specific number, or use Overflow bin and Underflow bin to group any values above or below a threshold into a single bar. To make the bars truly adjacent — which is critical for a proper histogram — set the Gap Width to 0% in the Format Data Series panel.

Older Excel Versions: The Data Analysis ToolPak Method

If you’re using Excel 2013 or earlier, the built-in histogram chart may not be available. Instead, enable the Data Analysis ToolPak by going to File > Options > Add-ins. Click Go next to “Manage: Excel Add-ins,” check Analysis ToolPak, and click OK. The ToolPak then appears under Data > Data Analysis.

Select Histogram from the list. In the dialog box, set the Input Range to your data column and the Bin Range to a column where you’ve already listed your bin upper limits. Check Chart Output and click OK. Excel produces a frequency table and a histogram chart. After the chart appears, set Gap Width to 0% to remove spaces between the bars.

Common Mistakes to Avoid

The most frequent error is confusing a histogram with a bar chart. Bar charts have gaps between bars because they compare distinct categories; histograms have touching bars because they plot a continuous range. A second common mistake is using unequal bin widths without adjusting your interpretation — equal-length intervals are the standard instructional approach. Finally, never skip the frequency table. Drawing bars directly from raw data almost always produces counting errors that force a redraw.

In Excel, watch for the wrong Input Range or Bin Range selection. The Input Range must be your raw data, not your bins. And if you use the ToolPak, make sure Chart Output is checked before you click OK — otherwise you get a frequency table with no chart.

Double-Check Your Histogram Against This Checklist

• The x-axis shows equal-width number ranges, not category names.
• All bars touch with zero gap.
• Bar heights match the count of data points in each bin.
• The y-axis is labeled “Frequency” or “Count” and is scaled to fit the tallest bar.
• The chart has a clear title describing the data.

If your chart passes every item on this list, it’s a correct histogram ready for analysis or presentation.