How to Make a Histogram in Excel (2026 Guide)
Home›Excel Charts›Make a Histogram
ExcelHow-To⏱ 2 min read

How to Make a Histogram in Excel (2026)

Histograms visualize the distribution of a single numeric variable — spotting normality, outliers, and spread at a glance. This guide covers the native histogram (Excel 2016+), bin configuration, and the Data Analysis Toolpak alternative for older versions.

⚡ Quick Answer

Select your numeric column. Insert tab → Statistical chart icon → Histogram. Excel auto-bins the data. Adjust bins via right-click axis → Format Axis → Bin Width or Number of Bins.

Method 1: Native histogram (Excel 2016+)

  1. Select the numeric column

    Include the header. Just one column — histograms show one variable's distribution.

  2. Insert tab → Statistical chart icon

    Small icon in the Charts group. Dropdown shows Histogram, Pareto, Box & Whisker.

  3. Click "Histogram"

    Excel auto-bins the data into ~5-10 bins and inserts the chart.

  4. Adjust bins

    Right-click the horizontal axis → Format Axis → Axis Options. Options: By Category, Automatic, Bin Width, Number of Bins, Overflow Bin, Underflow Bin.

Configuring bins

Bin size is the histogram's most important knob. Too few bins hides distribution shape; too many creates visual noise.

Bin Width

Set a fixed width. If your data ranges from 0-100 and you set Bin Width to 10, you get 10 bins (0-10, 10-20, ..., 90-100). Best for standardized ranges.

Number of Bins

Set the count. Excel divides your range into that many equal-width bins. Best when you want a specific level of detail.

Overflow & Underflow bins

Bin all values above (or below) a threshold together. Great when a few extreme outliers would otherwise stretch the axis and squish the main distribution. Set Overflow Bin = 100 → all values 100+ get one bin at the far right.

Bin-size rule of thumb

Start with the square root of your sample size. 100 data points → ~10 bins. 400 → ~20. Adjust until the shape of the distribution is clear without being noisy.

Method 2: Data Analysis Toolpak (Excel 2013 and earlier)

  1. Enable the Toolpak

    File → Options → Add-ins → Manage Excel Add-ins → Go → tick "Analysis ToolPak" → OK.

  2. Create a bin range

    Column with upper bounds of each bin (10, 20, 30, ...).

  3. Data tab → Data Analysis → Histogram

    Now visible after enabling the Toolpak.

  4. Fill in the dialog

    Input Range = your data. Bin Range = your bin bounds. Output Range = where to place the frequency table. Tick "Chart Output".

  5. Click OK

    Excel produces a frequency table and a column chart. Format the chart with no gaps between bars for a proper histogram look.

Method 3: Manual histogram with FREQUENCY

For total control over bins:

  1. Create a bin column with upper bounds
  2. Adjacent to it, add a formula: =FREQUENCY(dataRange, binRange)
  3. Enter as an array formula (Ctrl+Shift+Enter in older Excel; automatic in Excel 365)
  4. Chart the frequency column as a column chart
  5. Right-click a bar → Format Data Series → Gap Width → 0 (bars touch)

Reading a histogram

Symmetric (normal)

Bell shape — most data in the middle, less at the extremes. Common for measurements (height, test scores).

Right-skewed

Long tail on the right. Most data on the left, a few high outliers. Common in incomes and web-page views.

Left-skewed

Long tail on the left. Rare in nature; sometimes seen in age-at-death data or high-ceiling test scores.

Bimodal

Two peaks. Suggests two subpopulations mixed together (e.g., customer sizes from two segments).

Uniform

Flat — all bins roughly equal. Rare in real data; usually indicates random processes or artificially generated data.

Common histogram use cases

  • Quality control — is production consistent, or bimodal?
  • Financial analysis — distribution of returns, transaction sizes
  • HR analytics — salary distribution, tenure distribution
  • Test score analysis — shape of student performance
  • Data quality — spotting unexpected outliers or gaps
Don't confuse histograms with bar charts

Bars in a histogram touch (no gaps) because the X-axis is continuous. Bars in a bar chart have gaps because categories are distinct. This visual difference matters — mixing them up misleads readers about the data type.

Excel Wizard

Distribution analysis, automated

Making a histogram is easy; interpreting it takes practice. Excel Wizard analyzes your data and calls out what the distribution shows — skewness, potential outliers, bimodality — so you don't have to eyeball it. Great for data quality checks before deeper analysis.

Install Excel Wizard →

Frequently asked questions

How do I make a histogram in Excel?

Select the column containing your numeric data. Go to Insert tab → Statistical chart icon → Histogram. Excel automatically bins the data. Native histograms require Excel 2016 or later.

How do I change bin size in an Excel histogram?

Right-click the horizontal axis → Format Axis → Axis Options. Set Bin Width (fixed size) or Number of Bins (specific count). Bin size affects the shape of the distribution.

What's the difference between a histogram and a bar chart?

A bar chart shows values for distinct categories with gaps between bars. A histogram shows distribution of a numeric variable across continuous bins with no gaps — adjacent bins physically touch to emphasize continuous scale.

How do I make a histogram in Excel 2013 or earlier?

Use the Data Analysis Toolpak (File → Options → Add-ins → Analysis ToolPak). Or use FREQUENCY with a manual bin column, then chart as a column with 0 gap width.