To draw a histogram in Excel for Microsoft 365 on Windows, put your numeric observations in one column, select the values, then choose Insert > Insert Statistic Chart > Histogram. Excel creates a chart that groups the values into intervals, called bins, and shows how many observations fall in each interval.
What a Histogram Shows
A histogram summarizes the distribution of numerical data. Its horizontal axis is divided into adjacent ranges, and each bar represents the number of values in one range. The vertical axis usually shows the frequency, or count. For example, a histogram of exam scores might use bins from 50 to less than 60, 60 to less than 70, and so on. A bar’s height tells you how many scores fall into that interval.
Histograms are useful for spotting the shape and spread of a dataset: whether values cluster around a typical range, whether the distribution has a long tail, or whether there are gaps or unusually high or low observations. They do not show every individual value, so keep the source data if you need to inspect specific records.
A histogram is not the same as a column chart. A column chart compares separate categories, such as sales by product. A histogram groups values along a continuous numerical scale, so its bars normally touch. Changing a column chart’s gap width does not turn it into a histogram; the binning of the numbers is the important difference.
Prepare the Data Before Charting
Use one column of numeric observations, with one value per row. A heading in the first cell is helpful, but do not include totals, notes, or category names among the values. Blank cells are generally ignored, but text mixed into the data can be excluded or handled unexpectedly. Check that values that look numeric are actually stored as numbers rather than text.
For example, if you are measuring delivery times in minutes, the column might contain 18, 22, 25, 31, and other observed times. Each row should represent one delivery. Do not create a table of pre-counted intervals for the built-in Histogram chart; that chart expects the ungrouped observations and calculates the counts itself.
- Use a consistent unit, such as minutes throughout rather than a mix of minutes and hours.
- Remove or correct obvious data-entry errors, but do not delete unusual values just because they look surprising.
- Decide whether zero is a valid observation. If it is, retain it; if it represents missing data in your source, correct the data before charting.
- Keep a copy of the original data so you can revise bins or investigate outliers later.
Create a Histogram with the Insert Chart Command
- Click a cell in the numeric data column, or select the values and their heading. If you select a heading, make sure Excel recognizes it as a label rather than an observation.
- Open the Insert tab on the ribbon.
- Choose Insert Statistic Chart in the Charts group, then select Histogram.
- Excel inserts the chart in the worksheet. Move or resize it as needed, then inspect the axis labels and bins before sharing it.
If the Statistic Chart button is not visible, look in the Charts area of the Insert tab; the ribbon may show a compact icon or menu depending on window size. You can also use Excel’s chart recommendations, but choosing Histogram directly makes the intended chart type clear. The chart updates when its source range changes, although you may need to adjust the selected range if new data is added outside it.
Excel for Mac has a similar histogram chart feature, though ribbon arrangement and labels can vary by release. In Excel for the web, chart creation and formatting choices can differ from the Windows desktop version. The steps above describe Microsoft 365 for Windows; use the available chart options in the web interface if Histogram is offered there.
Choose Useful Bin Settings
Excel often chooses bins automatically. That is a convenient starting point, not a guarantee that the chart answers your question well. Too few bins can hide important structure by lumping values together. Too many bins can make random variation look like meaningful patterns. The right setting depends on the data’s range, sample size, and the detail readers need.
To adjust the bins, right-click the horizontal axis and choose Format Axis. In the Format Axis pane, find Axis Options and the Bins settings. Depending on the available options, you can set the number of bins or their width. Excel also provides overflow and underflow bins, which group values above or below specified limits into end bins.
- Bin width: Sets the numerical span of each interval. For delivery times measured in minutes, a width of 10 creates ranges roughly 10 minutes wide.
- Number of bins: Divides the observed range into a chosen number of intervals. This can help when you need a chart with a controlled level of detail.
- Overflow bin: Groups values greater than a chosen cutoff into one final bar, useful when a few large values stretch the scale.
- Underflow bin: Groups values at or below a chosen cutoff into one initial bar, useful when the lower end needs a single category.
Suppose 100 delivery times range from 12 to 86 minutes. A bin width of 10 gives readers a straightforward view of how counts change across the range. A width of 1 would create many narrow bars and may be hard to interpret; a width of 40 could conceal differences between common delivery times. Try a sensible setting, then check whether the chart reveals the distribution without overwhelming the reader.
Label and Format the Chart
A chart is easier to understand when its title and axes describe the measurement. Select the chart, then use the chart design and formatting controls on the ribbon to add or edit chart elements. You can also use the chart’s plus-shaped Chart Elements button when it appears beside the chart. Add a clear title such as Delivery Time Distribution, and label the horizontal axis with the unit, such as Delivery time (minutes). The vertical axis can be labeled Number of deliveries.
Keep the bars readable and avoid decorative effects that distract from the pattern. If you change colors, use enough contrast to distinguish the bars from the chart background. A histogram generally does not need a legend when it contains one data series. If Excel displays an unnecessary legend, select it and remove it.
For a report, explain any non-obvious bin choice in a nearby note. A reader should know whether a bar represents, for example, values from 20 up to but not including 30, or some other interval. Axis labels and the bin settings help communicate this, but a short caption can prevent confusion when the chart is copied into another document.
Use the Analysis ToolPak for a Frequency Table
The built-in chart is the quickest route when you want a histogram from raw values. The Analysis ToolPak is useful when you also want a frequency table or need to specify a list of bin limits. On Windows, first enable the add-in if it is not already available: choose File > Options > Add-ins, select Excel Add-ins in the Manage box, choose Go, check Analysis ToolPak, and select OK.
Put your raw observations in one column. In another column, enter the upper limits for the bins in ascending order. Then choose Data > Data Analysis > Histogram. In the dialog, set the Input Range to the observations and the Bin Range to the limits. If the selected ranges include headings, check Labels. Choose an output range or a new worksheet, and select the chart output option if you want Excel to create a histogram chart along with the frequency results.
The ToolPak’s output is a frequency table based on the limits you supplied; its interval conventions and chart appearance may not match the automatically generated chart exactly. Read the labels in the output carefully, especially at the endpoints, and verify that the frequencies account for the observations you intended to include. On Mac, the Analysis ToolPak is accessed through the Excel Add-ins controls, whose location can vary by version. It is not available in Excel for the web, so use desktop Excel for this workflow.
Interpret the Shape Without Overclaiming
Look first for the overall pattern. A roughly symmetric mound suggests that values are concentrated around a central range, while a long tail on one side indicates skew. Separate clusters may point to distinct groups, different operating conditions, or a mixture of populations. Gaps and isolated bars can indicate unusual values, but they may also result from a small sample or the chosen bin width.
A histogram alone does not explain why a pattern exists, prove that a process is stable, or identify which individual records created an unusual bar. Compare the chart with the source data and relevant context before drawing conclusions. If the appearance changes substantially when you adjust bin width, describe the result cautiously and consider showing a second view or reporting summary statistics alongside it.
Common Problems and Fixes
- The chart looks empty or has an odd range: Check that the selected cells contain numbers, not numeric-looking text, and that the range excludes unrelated cells.
- The first row appears as a value: Recreate the chart with the heading included and check that Excel treats it as a label, or select only the numeric observations.
- There are too many or too few bars: Right-click the horizontal axis, open Format Axis, and change the bin width or number of bins.
- One extreme value makes the rest hard to see: Confirm that the value is valid. If it is, consider an overflow bin or a separate chart, and explain the choice rather than silently omitting the observation.
- The bars do not touch: Confirm that you inserted a Histogram rather than a regular column chart. The chart type, not just bar spacing, defines the grouping.
- New rows are missing: Update the chart’s source data range or place the data in an Excel table and check that the chart includes the added rows.
Frequently Asked Questions
Can I make a histogram in Excel with text categories?
A histogram is for numerical measurements that can be grouped into intervals. For categories such as product names or departments, use a column or bar chart instead. If the categories represent ordered numeric ranges already, a frequency table and column chart may be appropriate, but that is different from binning raw measurements.
How do I change the histogram interval in Excel?
Right-click the horizontal axis, choose Format Axis, and change the bin width or number of bins under Axis Options. The exact settings available depend on the chart and Excel version. Review the resulting interval labels to make sure they suit the units and purpose.
Can a histogram show percentages instead of counts?
The standard Histogram chart displays frequencies. To show proportions, calculate each bin’s share of the total in a frequency table and chart those percentages, or use a charting workflow that supports the desired statistic. Label the vertical axis clearly so readers can distinguish percent from count.
Why does my histogram have a bar for values above the last interval?
An overflow bin may be enabled, or the chosen bin limits may leave higher observations grouped at the end. Open Format Axis and inspect the overflow setting. If using the Analysis ToolPak, check the bin limits and output labels against the raw data.
Can I create a histogram from a pivot table?
A pivot table can summarize values, but the built-in Histogram chart is designed to group raw numerical observations. You can group numeric fields in a PivotTable and chart the resulting counts, but confirm the grouping intervals and chart type; the result may be a column chart rather than Excel’s dedicated Histogram chart.
Related
- Convert Text to Columns in Excel: Steps, Options & Tips
- Copilot Not Responding in Excel? Fixes to Try
- Consolidate Values in Excel: Steps and Options
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Logarithmic Trendline: How to Add and InterpretAn Excel logarithmic trendline is a curve that models how a value changes as the predictor grows by…
- Excel Pivot Table Not Pulling All Data? Fix ItIf an Excel PivotTable is missing rows, first refresh it, then check whether its data source includes those…
- Excel Pivot Chart: Remove “Sum of” From LabelsTo remove “Sum of” from a PivotChart legend label in Excel for Microsoft 365 on Windows, rename the…
- How to Make a Chart in Excel: A Clear Step-by-Step GuideTo make a chart in Excel, arrange your information in labeled rows or columns, select the data, then…
- How to Display a Trendline Equation in Excel ChartsTo display a trendline equation in Excel, select a chart, add a trendline, open its formatting options, and…
- How to Left Align a Pie Chart in ExcelTo left align a pie chart in Excel, select the chart’s outer border and drag it until its…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.