Excel Bar Graph Not Showing All Data? Fix It

If an Excel bar graph is missing bars or categories, first check its source range in Chart Design > Select Data, then check chart filters, hidden rows or columns, and axis settings. The chart may contain the data but hide its labels, so identify whether bars, series, or only category names are missing before changing the chart.

First identify what is missing

A bar chart uses categories along the vertical axis and values along the horizontal axis. A column chart swaps that arrangement. That difference matters: a missing bar usually points to excluded or filtered source data, while a missing category name may be an axis-label display issue. If every category appears but one bar is too short to notice, the value may be zero, blank, very small compared with other values, or formatted in a way that makes it hard to see.

Compare the graph with the worksheet, not just with the labels you expect. Look for a missing row in the chart’s source range, a filter applied to the table, blank cells, and categories that are hidden or grouped. Then select the chart and see whether a funnel-shaped Chart Filters button is available; selected chart filters can hide individual categories or series without changing the worksheet data.

Bars are missing: inspect the source range, filters, and hidden rows.
Category names are missing: inspect axis-label intervals and available chart space.
A series is missing: check the chart’s series list and whether the wrong rows or columns were selected.
A bar is present but looks wrong: check its underlying value, number format, and value-axis bounds.

Check and correct the chart data range

Excel charts plot the cells included in their source data. If a chart was created from A1:B8, for example, a new record entered in row 9 is not necessarily included when the chart uses an ordinary fixed range. A title row accidentally included in the range, or a row omitted when selecting the data, can also produce unexpected categories or series.

Select the chart so the chart tabs appear on the ribbon.
Choose Chart Design > Select Data.
Review the Chart data range box and the entries under Legend Entries (Series) and Horizontal (Category) Axis Labels. For a bar chart, the category labels are still listed as horizontal category-axis labels in this dialog, even though they appear vertically in the finished chart.
Correct the range or edit the series and category labels, then select OK.

For example, a simple two-column list might have product names in A1:A6 and sales values in B1:B6, with headings in row 1. If the chart range ends at row 5, the final product is omitted. Expand the selection to include row 6, making sure the product names are assigned as category labels and the sales values as the plotted series. If the data layout is confusing, select the intended heading and data cells on the sheet and create a new chart as a comparison.

If categories and series have been swapped, select the chart and use Chart Design > Switch Row/Column. This changes how Excel interprets the selected rows and columns; it does not add omitted data to the source range. Check the chart preview and series names afterward, especially when the source contains several rows or columns.

Look for chart filters and worksheet filters

A chart can have its own selection of visible categories or series. Select the chart and open the funnel-shaped Chart Filters control if it appears. On its Values and Names tabs, review which categories and series are checked, select the missing items, and apply the change. This is separate from removing data from the worksheet.

Also inspect filters on the source table or range. A worksheet filter hides rows that do not meet its criteria, and charts commonly reflect the visible data. Clear the relevant filter temporarily to see whether the missing bars return. If you need a chart to include data in rows or columns that are hidden, select the chart and go to Chart Design > Select Data > Hidden and Empty Cells, then turn on Show data in hidden rows and columns if that option is available for the chart. This setting is useful when rows are deliberately hidden, but it may not be the right choice if the chart is meant to follow a filtered view.

Keep the purpose of the filter in mind. A chart that includes hidden rows can show values a worksheet filter was intended to exclude. If the requirement is to chart only records that meet a condition, leave excluded records out of the plotted results rather than enabling hidden data. Conversely, if hiding rows is only a way to tidy the worksheet, enabling hidden data can preserve a complete chart.

Distinguish missing labels from missing bars

Excel may plot every bar but omit some category labels to prevent them from colliding. This is common when there are many categories, long names, a narrow chart, or a large font. To check, widen the chart or select the category axis, open Format Axis, and review the label interval under Labels. An automatic interval can show only some labels while retaining all the bars.

Setting the interval to show every category label can make the text overlap or become unreadable. Better options include enlarging the chart, reducing label font size, shortening category names in the source, or splitting a long chart into smaller charts. Rotating or changing the layout of labels may also help where the chart type and axis options support it. Do not assume that a missing name means its data point was dropped; count the bars and compare them with the source rows.

Long category names can be especially confusing in a bar chart because labels sit beside the bars. Increase the plot area or the overall chart width so Excel has space for both labels and bars. If a category name is blank in the source, Excel may show an empty-looking category instead of a useful label; correct the source text if the name should be visible.

Inspect axes, scale, and category order

Axis settings can make a plotted value look absent or misleading. In a bar chart, the value axis runs horizontally. Select it, choose Format Axis, and review the minimum and maximum bounds. A manually fixed maximum that is too low can cut off longer bars; a very large maximum can make small values appear almost invisible. Returning a bound to automatic scaling is a useful diagnostic. A zero minimum is generally appropriate for bar comparisons because it preserves the visual meaning of bar length.

The category axis has its own settings. In a bar chart, categories may appear in an order that differs from the worksheet because Excel places the first category at the bottom by default in some layouts. On the category axis, Format Axis includes options such as Categories in reverse order. Changing the order can make a category easier to find, but it does not restore data that is absent from the source. Check the category count and labels before treating a reversed order as a missing-record problem.

For date-based categories, Excel may group dates or use a date axis with spacing that makes individual dates less obvious. Check whether the source cells are real dates, whether the axis is using a date scale, and whether the chart type suits the task. If every date needs to appear as a separate category, a text-style category axis may be more suitable, though it can make the timeline less proportional.

Check blanks, errors, and small values

A blank source cell does not provide an ordinary bar value. A cell containing zero is a real value, but its bar has no visible length when the value axis begins at zero. A tiny value beside much larger values may also be difficult to see. Select the source cell and inspect the formula bar or number format instead of relying only on the bar’s appearance.

Error values in source data can affect how a chart plots a point. Find and resolve errors in the relevant cells, or decide deliberately how the data should be represented. Avoid replacing a missing measurement with zero unless zero is factually correct: zero means a measured value of none, while a blank may mean unknown or not supplied. Those meanings are different and can change the story the graph tells.

For charts with empty cells, select the chart and open Chart Design > Select Data > Hidden and Empty Cells to inspect the available empty-cell treatment. The choices depend on the chart type. A gap, a zero, or connected points can matter especially in line charts; a blank value in a bar chart will not create a normal bar. Fixing the source data is usually clearer than changing a display option to disguise missing values.

Make charts update when new records are added

If the problem returns whenever you append records, make the source data an Excel table. Select a cell in the list and choose Insert > Table, confirm whether the table has headers, and create or re-create the chart from the table. When new rows are added as part of the table, charts based on that table can expand with the table. Verify that the new row actually joined the table and that the chart uses the table’s data; typing several blank rows below it does not make those rows data.

For a chart based on a normal cell range, add new records inside the existing range or use Chart Design > Select Data to expand it. A table is often easier to maintain than repeatedly editing a fixed address, particularly for reports that grow over time. Keep one header row and consistent columns so Excel can identify category labels and series values reliably.

Before sharing a chart, update the workbook and check the final plotted categories against the source. This is worthwhile after pasting data, changing table filters, or editing a chart range. A chart can be visually polished and still omit a new record if its source was never expanded.

When to rebuild or change the chart

If the chart’s series and labels are badly tangled, rebuilding it from a clean selection may be quicker than editing many settings. Arrange the data with one heading row, one category column, and one or more numeric series columns. Select the complete range, including headings, and choose an appropriate bar chart from Insert > Insert Column or Bar Chart. Then verify that the chart shows the intended categories and series.

A clustered bar chart is useful for comparing several series across categories; a stacked bar chart emphasizes totals and component contributions. A 100% stacked chart compares proportions rather than raw totals. Switching chart type will not repair an incomplete source range, and a stacked chart can make an individual series harder to compare. Choose a different type only when it better fits the question the data is meant to answer.

Frequently Asked Questions

Why is my Excel bar chart missing the last row?
Most often, the chart’s source range stops before that row. Select the chart, open Chart Design > Select Data, and check the range. If the source is a table, confirm the new row is part of the table.

Why are some category names missing but the bars are there?
Excel may be showing labels at intervals to avoid crowding. Widen the chart and inspect the category axis label interval in Format Axis. Showing every label can create overlap, so adjust the chart size or shorten labels if needed.

Do hidden rows appear in an Excel chart?
They may be excluded by default. Select the chart and look under Chart Design > Select Data > Hidden and Empty Cells for Show data in hidden rows and columns. Consider whether including hidden records is appropriate for the chart’s purpose.

Why does a value of zero not show a bar?
A zero has no length on a bar chart with a zero-based value axis, so it can look like no bar exists. Check the source cell to distinguish a true zero from a blank or an error.

Will an Excel chart update when I add data?
A chart based on an Excel table can expand when new rows are added to that table. A chart based on an ordinary fixed range may not include rows typed beyond its boundary; check or expand the range in Select Data.

Why does changing the axis not bring back a missing category?
Axis bounds and label settings affect how existing chart data is displayed; they do not add omitted cells to the source. First confirm the category is included in the chart range and is not hidden by a chart or worksheet filter.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.