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+)
Select the numeric column
Include the header. Just one column — histograms show one variable's distribution.
Insert tab → Statistical chart icon
Small icon in the Charts group. Dropdown shows Histogram, Pareto, Box & Whisker.
Click "Histogram"
Excel auto-bins the data into ~5-10 bins and inserts the chart.
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.
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)
Enable the Toolpak
File → Options → Add-ins → Manage Excel Add-ins → Go → tick "Analysis ToolPak" → OK.
Create a bin range
Column with upper bounds of each bin (10, 20, 30, ...).
Data tab → Data Analysis → Histogram
Now visible after enabling the Toolpak.
Fill in the dialog
Input Range = your data. Bin Range = your bin bounds. Output Range = where to place the frequency table. Tick "Chart Output".
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:
- Create a bin column with upper bounds
- Adjacent to it, add a formula:
=FREQUENCY(dataRange, binRange) - Enter as an array formula (Ctrl+Shift+Enter in older Excel; automatic in Excel 365)
- Chart the frequency column as a column chart
- 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
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.
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.