An Excel histogram is usually blank because its source range contains no usable numeric values, the chart points to the wrong cells, or filters and bin settings hide the distribution. In Excel for Microsoft 365 on Windows, first confirm that the selected source cells contain real numbers, then select the chart and check its data source and horizontal-axis bin options.
What a blank histogram can look like
A blank histogram does not always mean the same thing. You might see an empty chart frame with axes, a chart with no bars, or a single bar that makes the distribution look missing. The distinction helps narrow down the cause: no bars usually points to the source data or visibility settings, while a single bar often means the bin width is too large or there are too few bins.
A histogram groups numeric observations into intervals, called bins, and displays how many values fall in each interval. It is not the same as a column chart of categories: the horizontal axis represents ranges of numbers, and the bar height represents a count. Excel cannot build a meaningful histogram from labels such as names or product types alone.
Check that the source cells contain numbers
Start by inspecting the values selected for the chart. A cell can look like a number but be stored as text, for example when data was imported from a website or copied from a report. Text values, headings, and error values are not numeric observations for the histogram. A range containing only a heading or text can therefore produce no bars.
- Look for numbers aligned differently from nearby values, or for a green warning triangle indicating that a number is stored as text.
- Check whether decimal separators, thousands separators, currency symbols, or leading apostrophes prevented Excel from recognizing the values as numbers.
- Make sure the selected range includes the observations, not just a title row, a summary, or empty cells.
- Look for formulas that return an empty string. A cell displaying nothing because its formula returns an empty string is not an observation.
To convert text-formatted numbers, select the affected cells and use the warning icon’s Convert to Number command when it appears. Another option is Data > Text to Columns, then finish the wizard with the appropriate delimiter settings; this can convert recognizable numeric text. Check a few converted cells before rebuilding the chart, especially if the source contains dates or values with regional decimal formats. Do not replace missing observations with zero unless zero is genuinely what those observations mean: doing so changes the distribution.
Verify the chart’s data range
A chart can remain on a worksheet after its source cells are moved, deleted, or replaced. Click the chart and inspect the highlighted source range on the worksheet, if Excel displays it. If the chart was copied from another sheet or workbook, it may still refer to the old location. A histogram based on a range that is now empty, or that contains only text, will not show a useful distribution.
The most reliable repair is often to select the intended numeric values first and create a fresh chart. On Windows, select one column of observations, then choose Insert > Insert Statistic Chart > Histogram. Include a heading if you have one, but do not include explanatory notes or totals in the observation range. If the values are in separate, non-adjacent columns, put the observations together in one column before creating the histogram; a histogram is intended to summarize one numeric data series at a time.
If you want to edit an existing chart, use Chart Design > Select Data to review its source where that command is available for the chart. If the source is unclear or the chart type does not expose the expected controls, creating a new histogram from a clean range is usually faster than trying to repair a damaged reference. Excel for Mac has similar chart tools, though ribbon labels and their locations can differ slightly. Excel for the web may not offer the same statistical-chart editing controls as desktop Excel, so use the desktop app if the Histogram command or bin controls are missing.
Adjust bins without mistaking them for missing data
When Excel has recognized the data but the result looks empty or unhelpful, inspect the bins. Right-click the horizontal axis and choose Format Axis. In the Format Axis pane, look under Axis Options for the Bins settings. Excel can choose bins automatically, or you can set a Bin width or Number of bins. The exact appearance depends on the range and spread of the data.
A very large bin width can combine most observations into one bar, making detail disappear. A very small width can spread observations across many intervals, leaving numerous bins with zero counts and making the nonempty bars hard to notice. Try Automatic first, then adjust one setting at a time. Number of bins controls how many intervals Excel uses; Bin width controls the size of each interval, so they are related but not interchangeable.
The Underflow bin and Overflow bin options group values at or beyond a boundary into an end bin. They are useful when you want to keep extreme values together, but can make the chart’s distribution look different from what you expect. Check the axis scale and the displayed interval labels before concluding that Excel has lost values. Changing bins changes how the observations are grouped; it does not change the underlying data.
Check filters, hidden rows, and table ranges
If the chart became blank after filtering a table, the filter may have hidden the rows containing the observations. Clear the filter temporarily and see whether bars return. Some chart configurations omit data in hidden rows or columns. For a standard chart, select it and look for Chart Design > Select Data > Hidden and Empty Cells, then check whether the option to show data in hidden rows and columns is available and appropriate. Statistical charts can expose different controls, so if the option is unavailable, test with a clean, unfiltered range.
Also check whether the chart source includes newly added observations. A chart based on a fixed range such as A2:A50 will not automatically include values added below row 50. Converting the source to an Excel table with Insert > Table can make ranges easier to maintain as data grows, but verify that the chart actually uses the expanded table data. Do not assume that adding rows near a chart automatically updates its source.
Rule out display and formatting problems
If the data is numeric and the chart has the right source, look for a display problem. The bars may be formatted with no fill, a fill color that blends into the plot area, or a very thin border. Click a bar and open Format Data Series to inspect Fill & Line settings. Choose a visible solid fill if the series has no visible color. Also check that the chart has not been reduced to a tiny size or covered by another object.
Look at the axes as well. If the horizontal axis or plot area is hidden, bars can be difficult to interpret, even if they exist. If the chart includes a vertical axis, an unusual scale can make the bars appear almost flat. Resetting the relevant axis bounds to automatic can help determine whether a manually set scale is the cause. A chart title or legend alone does not prove the histogram has plotted data; look for bars and interval labels.
Distinguish a histogram from similar chart types
A common misconception is that any chart of numeric data is a histogram. A regular column chart displays categories supplied by the worksheet, while Excel’s Histogram chart calculates numeric intervals and counts observations in each interval. If you inserted a column chart and expected Excel to create bins automatically, you may see a result that seems wrong or empty because the chart type is not a histogram.
For a proper histogram in Microsoft 365 for Windows, select the numeric observations and choose Insert > Insert Statistic Chart > Histogram. Excel’s built-in histogram chart is available in modern desktop versions, including Excel 2016 and later. If you cannot find the command, check the chart options in your version or use desktop Excel rather than assuming a regular column chart will behave the same way. Keep the workbook in a current format such as .xlsx or .xlsm when working with newer chart features, rather than relying on an older compatibility format.
A quick troubleshooting order
Work through these checks in order so that you do not change several things at once and lose track of the cause:
- Confirm that the intended source cells contain actual numeric observations, not text, headings, errors, or empty results.
- Clear worksheet filters temporarily and check whether the chart source includes the visible data you expect.
- Create a new Histogram chart from a single clean column to separate a source problem from a chart-formatting problem.
- Right-click the horizontal axis, choose Format Axis, and test Automatic bins before setting a bin width or number of bins.
- Inspect the bar fill, chart size, plot area, and axis scale if the chart still looks empty.
For example, if a column contains the values 12, 14, 15, 18, 19, 21, 22, 24, 28, and 32, it should produce bars when Excel recognizes all ten entries as numbers. If the chart is blank, check for text formatting or a source range that stops before the values. If the chart displays just one prominent bar, change the bin settings rather than replacing the observations with different values.
Frequently Asked Questions
Why is my Excel histogram blank even though I can see numbers?
Some displayed values may be numbers stored as text, or the chart may point to different cells from the ones you are viewing. Confirm the source range and convert recognizable text-formatted numbers to numeric values, then create a fresh histogram to test.
Why does my histogram show one bar instead of several?
The bin width may be too large, or Excel may have selected only a few bins for the data’s spread. Right-click the horizontal axis, choose Format Axis, and try a smaller Bin width or a suitable Number of bins. The best setting depends on the values and the question you want the chart to answer.
Can a histogram show text categories?
No. A histogram groups numeric observations into intervals. For categories such as departments or colors, use a column or bar chart that counts each category instead.
Why did my histogram disappear after I filtered the data?
The filter may have hidden the rows the chart uses, or the chart may be set not to display hidden data. Clear the filter as a test. If your chart offers the relevant control, review Chart Design > Select Data > Hidden and Empty Cells.
Can I make an Excel histogram in the browser?
Excel for the web has different chart-creation and editing capabilities from desktop Excel, and some statistical-chart controls may be unavailable. If you cannot find Histogram or cannot change bins, open the workbook in Excel for Microsoft 365 on Windows or Mac and make the changes there.
When to rebuild rather than keep troubleshooting
Rebuild the chart when the source is unclear, the data has been rearranged, or repeated repairs still leave no bars. A fresh chart from a checked numeric column is a useful diagnostic, not just a workaround: if it displays correctly, the original chart’s range or formatting was the issue. If the fresh chart is also blank, focus on data types, errors, and whether the selected cells actually contain observations. Once the chart works, review its bins and labels so the displayed shape communicates the data accurately rather than merely looking filled.
Related
- Excel Goal Seek With Two Variables: Solver Options
- Excel Goal Seek With Multiple Inputs: Use Solver
- Excel Goal Seek Precision: Accuracy and Limits
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Waterfall Chart Example: Build One Step by StepAn Excel waterfall chart shows how a starting value changes through a series of increases and decreases to…
- Excel Chart With Two Y-Axes: How to Make OneTo make an Excel chart with two different y-axis values, select the chart, choose Chart Design > Change…
- Stacked Waterfall Chart Excel Template: A Setup GuideExcel does not have a separate chart type called a stacked waterfall chart. To make one in Microsoft…
- Excel Sparklines Line Chart: How to Add and Format OneIn Excel for Microsoft 365 on Windows, select the data, choose Insert > Sparklines > Line, and specify…
- Can You Make a Graph in Google Sheets?Yes—you can make a graph in Google Sheets by selecting your data and choosing Insert > Chart. Sheets…
- Google Sheets Chart Examples: Types, Uses, and TipsGoogle Sheets chart examples include a line chart for monthly sales trends, a bar chart for comparing products,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.