ExcelHow-ToBeginner · 3 min read

How to Create Histogram in Excel: Step-by-Step Guide

To create a histogram in Excel, select your data and go to the Insert tab, then choose Insert Statistic Chart and select Histogram. Excel will automatically group your data into bins and display the frequency distribution as bars.

📐

Syntax

Excel does not use a formula for histograms but uses built-in chart tools. The main steps involve selecting your data range and using the Insert Statistic Chart feature to create a histogram.

Key parts:

Data Range: The cells containing your numeric data.
Insert Tab: The menu where chart options are found.
Histogram Chart: A chart type that groups data into bins and shows frequency.

text

1. Select your numeric data range.
2. Click the Insert tab on the ribbon.
3. Click on Insert Statistic Chart.
4. Choose Histogram from the dropdown.

💻

Example

This example shows how to create a histogram from a list of exam scores to see how many students scored within certain ranges.

text

Data in cells A1:A15:
78
85
92
88
76
95
89
84
91
73
77
85
90
87
82

Steps:
1. Select cells A1:A15.
2. Go to Insert tab.
3. Click Insert Statistic Chart.
4. Select Histogram.

Excel creates a histogram chart showing score ranges on the horizontal axis and number of students on the vertical axis.

Output

Histogram chart with bars showing frequency of scores grouped in ranges like 70-75, 75-80, 80-85, etc.

⚠️

Common Pitfalls

Not selecting numeric data only can cause errors or empty charts.
Using empty cells or text in the data range can distort the histogram.
Not having the Analysis ToolPak enabled in older Excel versions (before 2016) can prevent histogram creation.
Manually creating bins without using the chart tool can be confusing and error-prone.

text

Wrong way:
- Selecting data with text or blanks.

Right way:
- Select only numeric data without blanks.
- Use Insert > Statistic Chart > Histogram for automatic binning.

📊

Quick Reference

Step	Action
1	Select numeric data range
2	Go to Insert tab on ribbon
3	Click Insert Statistic Chart button
4	Choose Histogram chart type
5	Adjust bins or chart style if needed

✅

Key Takeaways

Select only numeric data before creating a histogram in Excel.

Use Insert > Statistic Chart > Histogram for quick automatic binning.

Avoid blanks or text in your data range to prevent errors.

Older Excel versions may require enabling Analysis ToolPak for histograms.

You can customize bin size and chart style after creating the histogram.