Excel has a built-in histogram chart type in current desktop, web, and Microsoft 365 versions. It handles binning automatically, and the axis panel lets you switch between automatic bins, bin width, number of bins, overflow bins, and underflow bins. Here's how to use it — and what to do when you need more control over the bin table.
Method 1: Built-in Histogram Chart (Excel 2016+)
Enter your data in one column
Put all your values in a single column (e.g., A1:A100). No headers needed, but they won't cause problems if present. Each cell should contain one number.
Select your data
Click the first cell in your data column, then press Ctrl+Shift+End (Windows) or Cmd+Shift+End (Mac) to select through the last value.
Insert the Histogram chart
Go to Insert → Charts → Insert Statistic Chart → Histogram. Excel inserts a histogram with automatic bins.
Adjust the bin width
Right-click the X axis → Format Axis. Under Axis Options, change Bin width to a specific number (for example, 10 for test scores), set Number of bins, or enable overflow/underflow bins for values outside a chosen range.
Method 2: Analysis ToolPak (all Excel versions)
If you need an explicit frequency table with bin upper limits, use the Analysis ToolPak add-in:
Enable the Analysis ToolPak
Go to File → Options → Add-ins. At the bottom, set "Manage" to "Excel Add-ins" and click Go. Check "Analysis ToolPak" and click OK.
Create your bin column
In a separate column (e.g., column B), enter your bin upper boundaries. For test scores in 10-point ranges: 60, 70, 80, 90, 100. Each cell is the upper limit of one bin.
Run the Histogram tool
Go to Data → Data Analysis → Histogram → OK. Set Input Range to your data column, Bin Range to your bin column. Check "Chart Output". Click OK.
Remove gaps between bars
Excel bar charts have gaps by default. Right-click any bar → Format Data Series → set Gap Width to 0%. This makes it look like a proper histogram.
Fixing the common Excel histogram problems
- Bars have gaps — fix by setting Gap Width to 0% in Format Data Series. A histogram has no gaps; a bar chart does.
- Bin labels show ranges, not numbers — Excel 2016+ shows bin ranges (e.g., "[70, 80)"). This is correct for a histogram.
- Overflow and Underflow bins — these are optional axis settings in the built-in chart, and optional bin rows in the Analysis ToolPak output. Use them when you want to separate extreme values from the main distribution.
- Chart won't update when data changes — the Analysis ToolPak histogram is static. If you add data, re-run the tool. The built-in chart type (Method 1) updates automatically.
Excel histogram limitations
Excel's built-in histogram is fine for quick spreadsheet work, but it has a few practical constraints:
- You can't easily control exact bin start/end points (only width or count)
- The Y axis always shows frequency (count); you can't switch to density or proportion without manual calculations
- Styling options are limited compared to purpose-built tools
- No outlier detection or statistical summary
When to use an online histogram maker instead
For quick visualizations during analysis, Excel works fine. But when you need:
- Control over the exact number of bins with a slider
- Y-axis switching between count, frequency, and density
- A clean, professional chart to export for a report or paper
Use the free online histogram maker — paste your data, adjust bins with a slider, and export without much setup.
FAQ
Which Excel version supports the built-in histogram?
Microsoft documents the built-in histogram chart for Excel 2016 and newer desktop versions, Excel for the web, Excel 2021/2024, and Microsoft 365. Excel 2013 and earlier usually require the Analysis ToolPak method.
Why does my histogram show '[60, 70)' instead of just '60–70'?
The bracket notation means the bin includes 60 but excludes 70 — so a value of exactly 70 goes in the next bin. This is standard mathematical notation for half-open intervals. It's correct behavior.
Can I make a histogram in Google Sheets?
Yes — select your data, go to Insert → Chart → Chart type → Histogram. Google Sheets has similar bin controls. For more control over bin width and Y-axis type, use our free histogram maker.
References
How this guide is reviewed
This guide is maintained by the ChartsMakers Editorial Team and reviewed for statistical accuracy, product behavior, and clarity. Sources used for factual checks are listed in the References section. See our editorial policy.