Excel Graph Not Showing 0 Values? Fix the Chart

Charts & pivot tables · Updated November 18, 2026

Excel normally plots a numeric zero as a value, but it may be hard to see: it can sit on the horizontal axis, be excluded by the axis scale, or be hidden by the chart type or formatting. Check that the source cell contains a real number, then inspect the chart’s axis bounds, series formatting, and empty-cell settings to find the cause.

What a zero looks like in an Excel chart

A chart does not always make a zero look like a distinct point. In a column chart, a zero-height column has no visible height. In a line chart, a zero may appear as a marker on the horizontal axis; if markers are turned off, the point can be difficult to distinguish from the axis itself. A zero can also be plotted correctly but not labeled, which can make it seem as if Excel omitted it.

First compare the chart with its source range. Click the chart, then choose Chart Design > Select Data to check which cells supply the series. Confirm that the relevant row or column is included and that the series points to the expected cells. A correct chart cannot show a value that is outside its selected source range.

It also helps to distinguish zero from missing data. A cell containing the number 0 is not the same as a blank cell, a space, or text that looks like a zero. Excel’s chart behavior depends partly on that difference.

Check whether the source is a number or text

Click the source cell and look at its contents in the formula bar. A numeric 0 is a number. A value imported as text, such as a text-formatted zero, may not behave like a numeric measurement in a chart. Text can result from importing a file, using a leading apostrophe, or applying a conversion that leaves numbers stored as text.

To check a suspicious cell, select it and review its number format and alignment, but do not rely on appearance alone: formatting can make a number look like text or make text resemble a number. You can also try a simple test in an unused cell: enter a numeric zero directly, include that cell in a temporary chart series, and see whether the chart displays it. If the test zero appears, investigate the original data and how it was imported or calculated.

When correcting a larger imported range, use a safe conversion method appropriate to the data, and check the result before replacing the original values. For example, selecting the range and choosing Data > Text to Columns can convert text-formatted numbers in many common cases, but conversion choices depend on the source format and regional number settings. Keep a copy of the original data when the values matter.

Inspect the chart axis limits

A zero can be outside the visible part of the chart. This commonly happens when the value axis has a manually specified minimum greater than zero. For example, if the vertical axis minimum is set to 10, a value of 0 is below the plotted range. Excel may still retain the point in the series, but it will not be visible in the chart area.

To inspect the scale, right-click the value axis and choose Format Axis. In the Format Axis pane, look under Axis Options for the Bounds fields. If Minimum is set to a fixed value, change it to Auto or enter 0 when that is appropriate for the data. Check the Maximum and major units too, since an unusual scale can make small differences hard to read.

Use a zero baseline thoughtfully. For bar and column charts, starting the value axis at zero is often useful because bar length encodes magnitude. A line chart may use a narrower scale to show small changes, but that choice should be clear and should not accidentally cut off meaningful zeros. If the chart has a secondary axis, inspect that axis separately; the zero may be plotted against a different scale from the other series.

Make zero-height points easier to see

For a column or bar chart, a value of zero produces a bar with no length or height. Excel has no visible bar area to draw, so the number may be present in the data without a noticeable mark. A line chart with markers can make the same value more apparent, provided the axis includes zero and the marker is not hidden by the axis line.

To add markers to a line series, select the line, right-click, and choose Format Data Series. In the pane, open Fill & Line, then expand Marker and choose a marker option. Adjust marker size or appearance if it blends into the axis. For a column chart, consider adding data labels: select the chart, then choose Chart Design > Add Chart Element > Data Labels. The available placements depend on chart type, and a zero-height column may still make some label positions awkward.

Formatting can hide a plotted point too. A series might have no markers, a line color matching the chart background, or a very thin line. Select the series and review its formatting. If several series overlap at zero, changing the marker shape or color can help distinguish them. Avoid changing the source value merely to make the point visible; that would make the chart inaccurate.

Understand blanks, formulas, and missing values

Blanks and zeros have different meanings. A zero says a measurement was made and its value was zero. A blank may mean no measurement was recorded, the observation is not applicable, or the result is not yet available. Decide which meaning is correct before changing chart settings.

To review how a chart treats empty cells, select the chart and choose Chart Design > Select Data. In the Select Data Source dialog, choose Hidden and Empty Cells. The dialog offers options for empty cells, including showing them as gaps, showing them as zero, or connecting data points with a line where supported. These options affect empty cells; they do not turn a genuine numeric zero into a blank.

A formula that displays an empty string can be confusing because the cell looks blank even though it contains a formula. Its chart behavior can vary with the chart and the way the data is supplied, so test the actual chart rather than assuming that a visually empty cell is treated exactly like a truly empty cell. If the intention is to omit a point rather than plot zero, choose a data design that clearly represents missing information and verify how the chosen chart renders it.

Do not replace every zero with a blank just to remove a mark. That can conceal real measurements and change totals or interpretations. Likewise, selecting the option to show empty cells as zero is not a fix for numeric zeros that are already in the source: it changes how missing cells are drawn.

Check chart types and special cases

Chart type affects what a zero can look like. A zero in a line chart can be represented by a point on the baseline. A zero in a column chart has no visible column. In a pie or doughnut chart, a zero-sized value contributes no slice, so there is no visible segment to label as a slice. If the purpose is to show that a category has a recorded value of zero, a bar, column, or line chart with suitable labels may communicate that better.

Logarithmic axes are another important exception. A logarithmic value axis cannot represent zero or negative values because the logarithm of zero or a negative number is undefined. If a chart uses a logarithmic scale, Excel cannot place a zero on that axis as an ordinary plotted value. Right-click the axis, choose Format Axis, and check whether Logarithmic scale is selected under Axis Options. Use a non-logarithmic scale if zero values need to appear, unless the data and analysis have a valid alternative treatment.

Combination charts can also cause confusion when series use different chart types or axes. A series on a secondary axis can appear at a different vertical position, and its axis may have a minimum that excludes zero. Check which axis each series uses and inspect both scales rather than assuming every series shares the same baseline.

A practical troubleshooting sequence

Work through these checks in order so you change only what is needed:

  1. Confirm the source range. Select the chart and use Chart Design > Select Data to verify that the row, column, or cells containing the zero are included.
  2. Check the cell value. Confirm that it is numeric 0 rather than text, a blank, or a formula result that only looks blank.
  3. Inspect the value axis. Right-click it, choose Format Axis, and check the minimum, logarithmic scale, and any secondary axis.
  4. Look for a zero-height or hidden mark. Add markers to a line series, add data labels where suitable, or adjust series formatting so the point contrasts with the axis.
  5. Review empty-cell handling. Use Chart Design > Select Data > Hidden and Empty Cells if the issue concerns missing or blank values, not a numeric zero.
  6. Test another chart type. If the value is zero and the current chart has no visible representation for it, try a chart type that can show a point or label more clearly.

After each adjustment, compare the chart with the underlying values. A chart should communicate the data accurately, not just make every category appear to have a visible mark.

Excel for Mac and Excel for the web

These instructions are for Excel for Microsoft 365 on Windows. Excel for Mac has the same general chart concepts, but ribbon placement and dialog layouts can vary by release. Select the chart and look for the chart design commands, including Select Data; use the axis or series formatting pane to check bounds and markers. If a dialog option is arranged differently, search Excel’s ribbon or Help for the command name rather than relying on a Windows-only click sequence.

Excel for the web also supports chart editing, but some detailed formatting controls and dialog options may differ from the desktop application. If you cannot find a particular axis, marker, or hidden-cell setting in the browser, open the workbook in the desktop app and make the change there. The source-data checks still apply in all versions: confirm the range, the numeric value, and whether the chart’s scale can include zero.

Frequently Asked Questions

Why does zero show in my worksheet but not in the chart?
A numeric zero may be plotted on the axis, have no visible height in a column chart, or fall outside a manually set axis minimum. Also confirm that the chart’s data range includes the cell and that the value is numeric rather than text.

How do I show zero labels on an Excel chart?
Select the chart and choose Chart Design > Add Chart Element > Data Labels. Whether a zero label is legible depends on the chart type and label position. A zero-height column may need a label position adjustment, while a line chart may benefit from a marker at the baseline.

Does Excel treat a blank cell as zero in a chart?
Not necessarily. In Chart Design > Select Data > Hidden and Empty Cells, you can choose how empty cells are represented, including as gaps or zero. A real numeric zero is different from an empty cell, and a formula that returns an empty string may not behave exactly like a truly empty cell.

Can a logarithmic chart show zero?
No. A logarithmic axis cannot plot zero or negative values as ordinary points. Use a non-logarithmic axis if the chart needs to show zero, or choose an appropriate chart and data approach for the analysis.

Why is a zero missing from a pie chart?
A zero has no slice size, so it produces no visible pie or doughnut segment. If readers need to see that the category was measured and its value is zero, use a chart type that can display a point, bar, or value label more clearly.

Related

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.