To create a histogram in Microsoft Excel for Microsoft 365 on Windows, put your numerical observations in one column, select the data (including its heading if present), then choose Insert > Insert Statistic Chart > Histogram. Excel builds a chart that groups the values into ranges, or bins, and shows how many observations fall in each range; you can adjust those ranges by formatting the horizontal axis.
What an Excel histogram shows
A histogram summarizes the distribution of numerical data. The horizontal axis shows adjacent value intervals, and the height of each bar shows the number of observations in that interval. For example, a histogram of delivery times might show how many deliveries took 0–10 minutes, 10–20 minutes, and so on. Taller bars mean more observations in that range.
Histograms are useful for spotting features that are hard to see in a long list: a typical range, spread, gaps, clusters, skew, and unusually high or low values. They are descriptive, not explanatory: a chart can reveal that some deliveries took much longer than most, but it cannot tell you why.
A histogram is not the same as a bar chart. A bar chart compares separate categories, such as departments or product names, and the category order can be rearranged. Histogram bins represent ordered, continuous number ranges, so the bars usually touch. Use a regular column or bar chart when the data consists of named categories rather than measurements.
Prepare the data before inserting the chart
Place one observation in each cell of a single column. A heading such as Delivery time (minutes) in the first row helps identify the series. Below it, enter individual numeric values, not a list of ranges or a pre-counted frequency table. A histogram needs the raw observations so Excel can count how many belong in each bin.
For example, a short list might contain 8, 12, 12, 17, 23, 25, 29, and 34. These are eight separate measurements. If you already have a table saying that 0–9 occurred once, 10–19 occurred three times, and so forth, those are summarized counts, not raw observations; a regular column chart is often the more suitable way to chart that table.
- Keep the measurements in one column, with one value per row.
- Remove explanatory text from the data cells. Keep labels in a heading row instead.
- Check that numbers are stored as numbers. Values imported as text may be skipped or handled unexpectedly.
- Decide whether blanks or unusual entries should be excluded. Do not replace missing observations with zero unless zero is a real measured value.
- For a useful comparison, use consistent units and comparable collection methods.
Excel can include a heading when you select it along with the measurements, but inspect the resulting chart if the first value appears to be missing or the series name is wrong. If there are several measured variables, make a separate histogram for each column rather than combining unlike quantities into one series.
Create the histogram in Excel for Windows
- Click a cell in the data column, or select the heading and all the numeric observations.
- Open the Insert tab on the ribbon.
- Choose Insert Statistic Chart in the Charts group, then select Histogram.
- Review the chart and its axis labels. Drag the chart to reposition it, or use the chart title and other chart elements to make its purpose clear.
- To control the ranges, right-click the horizontal axis and choose Format Axis. In the Format Axis pane, use the settings under Axis Options to change the bins.
The command may appear as a chart-type button with an icon rather than as a text label, depending on the ribbon width. If it is not visible, widen the Excel window or inspect the Insert tab’s chart options. The built-in Histogram chart is available in modern desktop Excel versions, including Microsoft 365. In Excel for Mac, select the data and look under Insert for the statistical chart options; the exact ribbon arrangement can differ. Excel for the web has fewer chart-editing controls in some environments, so use desktop Excel if you cannot find Histogram or need the full bin-formatting pane.
Choose bins that make the pattern readable
Bin settings determine how the horizontal axis groups the observations. Excel initially chooses bins automatically. That is a convenient starting point, not a universal statistical rule: a different bin width can make the same data look more or less detailed. Too few bins can hide important structure, while too many can make random variation look like a meaningful pattern.
Right-click the horizontal axis and select Format Axis. Under Axis Options, Excel offers settings such as Automatic, Bin width, and Number of bins. Depending on the data and Excel build, you can also set an Overflow bin or Underflow bin to group values above or below a chosen cutoff.
- Bin width: Sets the size of each value interval. If the width is 10, a measurement scale might be grouped into intervals such as 0–10, 10–20, and 20–30.
- Number of bins: Sets how many intervals Excel uses across the data range. This changes the detail, not the underlying observations.
- Overflow bin: Collects values greater than a specified boundary in a final group. This can make a long upper tail easier to summarize.
- Underflow bin: Collects values at or below a specified boundary in a lower group. It can be useful when values below a threshold are not the focus.
Try a couple of sensible widths and compare the shapes. For data ranging from 0 to 100, widths of 5, 10, or 20 may answer different questions; none is automatically correct without knowing the measurement context. State the chosen width when sharing the chart, especially if readers might compare it with another histogram. When comparing two groups, use the same bin boundaries so differences in bar heights are meaningful.
Read and label the finished chart
Start by checking the axes. The horizontal axis should communicate the measured quantity and its units, while the vertical axis generally shows frequency, or count. A title such as Delivery times in minutes is more informative than Chart Title. If the chart is for a report, add a brief note about the data period or sample when that context affects interpretation.
Look at the overall shape rather than treating one bar as a conclusion. A roughly symmetric mound may indicate that values cluster around a center. A long tail on one side suggests skew. Multiple peaks can point to distinct groups, a mixture of processes, or simply a choice of bins that emphasizes variation. Check the raw records before explaining a surprising feature.
Excel’s default histogram displays counts. It does not automatically show percentages as the vertical axis. To discuss proportions, divide each bin count by the total number of valid observations or use a charting approach that represents relative frequency. Also be careful when comparing samples of different sizes: a larger sample can have taller count bars even when the underlying proportions are similar. In that situation, compare percentages or use an appropriate normalized display.
Alternative: use the Analysis ToolPak
The Analysis ToolPak offers a separate Histogram analysis. It is useful when you want an output table of frequencies and want to specify the bin boundaries directly, or when you need a static report-style result. Unlike the built-in chart, the ToolPak procedure creates a frequency output from the input range; its results do not automatically update as the source data changes.
On Windows, enable the add-in if it is not already available: choose File > Options > Add-ins. At the bottom, set Manage to Excel Add-ins, choose Go, select Analysis ToolPak, and choose OK. Then open Data > Data Analysis, select Histogram, and provide the input range. You may also supply a bin range containing upper limits, choose an output location, and select Chart Output if you want a chart along with the table.
With the ToolPak, the bin range is a list of numerical upper limits rather than a list of category names. For example, limits of 10, 20, and 30 define successive cutoffs; values above the final limit appear in a final More category in the output. Check the generated labels and counts before publishing, especially if values sit exactly on a boundary. On Mac, the Analysis ToolPak can be enabled through Tools > Excel Add-ins in supported desktop versions, and the analysis command is on the Data tab. This add-in is not available in Excel for the web.
Common problems and fixes
- Histogram is missing from the Insert menu: Confirm that you are using a supported desktop version and have selected numerical data. In the web app, open the workbook in desktop Excel if the chart type or formatting controls are unavailable.
- The chart has unexpected or empty bins: Check for numbers stored as text, stray spaces, blank cells, or values outside the range you expected. Excel may ignore text entries rather than treating them as measurements.
- There is only one bar, or the chart looks too coarse: Open Format Axis and try a smaller bin width or a higher number of bins. Conversely, reduce the number of bins if the chart is too fragmented to interpret.
- Some extreme values seem lost: Inspect the minimum and maximum in the source data, then review the axis settings. An underflow or overflow bin can group extremes, but does not remove the need to verify them.
- The bars do not match a frequency table: Check the bin boundaries and whether your table uses inclusive or exclusive endpoints. A value exactly on a boundary must be assigned consistently for the counts to agree.
- The chart changes when the data is edited: The built-in chart is tied to its source range. Confirm that newly added rows are included; converting the source into an Excel table before charting can help keep a growing data range together.
For a fair comparison, avoid changing the bin width between charts without making that choice explicit. A histogram can be visually persuasive while still being misleading if its intervals are poorly chosen, the sample is incomplete, or different groups are measured on different scales.
Frequently Asked Questions
Can Excel make a histogram from a frequency table?
Not directly in the same way it makes one from raw observations. The built-in Histogram chart expects individual numeric values and counts them into bins. For an existing table of bin labels and frequencies, use a column chart to display the summarized counts, or return to the raw data and create the histogram from those observations.
How do I change the interval size in an Excel histogram?
Right-click the horizontal axis, select Format Axis, and set Bin width under Axis Options. If you want a fixed number of groups instead, choose Number of bins. Check the resulting boundaries and labels to make sure they suit the question you are answering.
Why are my histogram bars touching?
That is normal: adjacent bars represent neighboring numerical intervals on a continuous scale. If your values represent separate named categories, make a regular column chart instead; categories are not histogram bins.
Can I make a histogram in Excel for Mac?
Yes, supported desktop versions of Excel for Mac include histogram charting. Select the values and look under the Insert tab for the statistical chart options. Ribbon layout and some add-in steps differ from Windows; use the Analysis ToolPak through Tools > Excel Add-ins when that alternative is needed.
Does an Excel histogram show percentages?
The standard histogram shows counts by default. For percentages, calculate each bin’s share of the total valid observations or use another charting method that plots relative frequency. Make the denominator clear, particularly when comparing samples of different sizes.
Related
- Excel Geographical Heat Map: Create and Troubleshoot One
- Excel Get Data From Table or Range: A Practical Guide
- Excel Frequently Not Responding? Causes and Fixes
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Pivot Text to Columns in Excel: Split or Reshape?If you mean splitting text from one Excel column into separate columns, select the cells and choose Data…
- Build a Gantt Chart in Google Sheets: Step-by-StepTo build a Gantt chart in Google Sheets, list each task with its start and finish dates, calculate…
- Excel Pivot Table Not Grouping Dates? Causes and FixesIf Excel will not group dates in a PivotTable, first check the source date column for blanks, errors,…
- Excel Chart Series Order: Bring a Data Series to FrontYes. In Excel for Microsoft 365 on Windows, select the chart, choose Chart Design > Select Data, select…
- How to Make a Waterfall Chart in ExcelTo make a waterfall chart in Excel, arrange your categories and positive or negative changes in two columns,…
- Pivot Chart Not Updating? Fix the Source and RefreshIf an Excel PivotChart is not updating, refresh its underlying PivotTable first: select the PivotTable and choose PivotTable…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.