The fastest way to build a histogram

A histogram in Excel is a chart that groups your numbers into ranges and shows how many values fall into each range. To create one, you enter your data, select it, go to the Insert tab, choose the histogram chart type, and Excel builds the chart for you. The whole process takes about two minutes once your data is ready.

Excel calls histograms "stock" charts in older versions and offers a dedicated histogram option in Excel 2016 and newer. Both work the same way — you point Excel at your numbers, pick the chart type, and it automatically sorts them into bins (the ranges on the x-axis) and counts how many values land in each bin.

Key Takeaways

  • Your data must be in a single column or row of numbers; Excel will not build a histogram from text or mixed data types.
  • Select your data first, then go to Insert > Charts and choose the histogram option to let Excel create bins automatically.
  • You can change the bin width and starting point after the chart is created by right-clicking the horizontal axis and selecting Format Axis.
  • If your data has outliers or very wide ranges, you may need to adjust the bin settings so the chart is readable.

Preparing your data for a histogram

Before you create the chart, put all your numbers in one column or one row. If your data is scattered across multiple columns or mixed with text labels, Excel will either ignore the non-numeric parts or fail to build the chart. A simple way to check: select the range you plan to use, and make sure every cell is either a number or empty.

You do not need to sort the numbers yourself — Excel does that automatically when it builds the histogram. You also do not need to create the bins or count how many values fall into each one. That is what the histogram chart type does for you.

If your data includes headers (like "Test Scores" at the top of the column), you can include the header in your selection. Excel will recognize it as a label and use it for the chart title.

Selecting data and inserting a histogram

Click on the first cell of your data and drag to the last cell, or click the first cell and then hold Shift and click the last cell. Your selection should be highlighted in blue. If your data is in column A from row 1 to row 50, you would select cells A1 through A50.

Once your data is selected, click the Insert tab at the top of the ribbon. Look for the Charts group — it usually appears in the middle of the ribbon. Click the small arrow or dropdown next to the chart icons to see all available chart types.

In Excel 2016 and newer, you will see a histogram option labeled "Histogram" in the list. In Excel 2013 and earlier, histograms are grouped under "Stock" charts. Click the histogram icon, and Excel will immediately create a chart and place it on your worksheet.

Adjusting bin width and range

When Excel creates a histogram, it automatically decides how many bins to use and what range each bin covers. For many datasets, this works fine. But if your chart looks too crowded, too sparse, or does not show your data clearly, you can change the bin settings.

Right-click on the horizontal axis (the numbers along the bottom of the chart) and select "Format Axis" from the menu. A panel will open on the right side of the screen. Look for the "Axis Options" section and expand it if needed.

You will see fields for "Bin width" and "Overflow bin" (or similar labels depending on your Excel version). Bin width controls how wide each range is — a smaller number creates more, narrower bins; a larger number creates fewer, wider bins. Start by trying a bin width that makes sense for your data. If your numbers range from 0 to 100 and you want to see ten bins, try a width of 10.

Reading and interpreting your histogram

The horizontal axis shows the ranges (bins), and the vertical axis shows how many values fall into each range. A tall bar means many values landed in that range; a short bar means few did. The shape of the histogram tells you how your data is distributed — whether it clusters in the middle, skews to one side, or spreads evenly.

If one bin is much taller than the others, that range contains most of your data. If the bars are roughly the same height, your data is spread fairly evenly. If there are gaps (missing bars), no values fell into those ranges.

Common problems and fixes

If Excel shows an error or a blank chart, check that your data contains only numbers. Text, dates formatted as text, or cells with formulas that return errors will cause problems. Select your data again and make sure every cell is a valid number.

If your histogram looks unreadable — bars too close together, or one huge bar with tiny ones — your bin width is wrong. Right-click the horizontal axis again, open Format Axis, and try a different bin width. Increase it if bars are crowded; decrease it if the chart is too sparse.

If you selected data that includes a header and Excel did not recognize it, you can edit the chart title manually. Right-click the title at the top of the chart and select "Edit Text" to change it to something more meaningful.

Frequently Asked Questions

Can I create a histogram from data in multiple columns?

No, a histogram needs all your numbers in a single column or row. If your data is spread across columns, copy it into one column first, then create the histogram. You can delete the copied data afterward.

What is the difference between a histogram and a bar chart?

A bar chart shows categories (like months or product names) on the x-axis. A histogram shows ranges of numbers and counts how many values fall into each range. Histograms are for continuous data; bar charts are for categories.

Can I change the colors of the bars in my histogram?

Yes. Right-click any bar in the histogram and select "Format Data Series." A panel will open where you can change the fill color, outline, and other appearance options. Changes you make apply to all bars in the chart.

What if my data has negative numbers?

Histograms work with negative numbers just fine. Excel will include negative ranges on the left side of the horizontal axis and positive ranges on the right. The bins will adjust automatically to fit your full range of data.

How do I move or resize my histogram?

Click the chart to select it — you will see a border around it. Drag it to move it, or drag the corners and edges to resize it. To delete it, select it and press Delete.