Excel Chart Not Plotting Zero Values? How to Fix It

Excel normally plots numeric zero values, but a zero can be hard to see: a zero-height column has no visible bar, and a line-chart point may sit directly on the horizontal axis. To hide zero-valued points deliberately, use a helper column that returns #N/A for zeros; to make them visible, first check the chart type, axis scale, and whether the source values are truly numeric.

What Excel Does With Zero Values

A numeric zero is a value, not a blank. Excel generally includes it when calculating a chart and positions it at zero on the relevant axis. What you see depends on the chart type and its formatting. In a line chart with markers, a zero may appear as a marker on the axis. In a line chart without markers, the line can meet the axis without making the individual zero obvious. In a column or bar chart, a value of zero creates a bar with no length, so there may be nothing visible to distinguish it from an omitted value.

This is different from an empty cell. A blank may be shown as a gap, treated as zero, or connected across in some chart types, depending on the chart settings. A formula that returns an empty text string, such as a formula displaying an apparently blank result, is also not necessarily the same thing as a genuinely empty cell. That distinction matters when you are deciding whether to display, suppress, or connect points.

Why a Zero Can Look Missing

Before changing the data, identify what is actually happening. A zero may be plotted correctly but hidden by the chart’s design, or Excel may not be reading the source entry as a numeric zero at all. Common causes include:

Zero-height bars: A column or bar with a value of zero has no visible length.
No marker on a line: The point is on the axis, but the chart uses a line without markers.
Axis limits: A manually set minimum greater than zero can put zero outside the visible plot area. A minimum of zero, by contrast, places zero at the bottom of the plot.
Hidden or filtered source rows: The chart may exclude data in hidden rows or columns, depending on its settings.
Text instead of a number: An entry that looks like 0 may be stored as text, or may contain a space or other character.
Overlapping series: Another series or a chart element can cover the point or make it difficult to distinguish.

Check the source cell and the chart’s selected data range before assuming Excel has a rule that suppresses zeros. If the chart is supposed to show the zero as a point, adding markers or adjusting the axis may solve the visual problem without changing the data.

Diagnose the Source Data and Chart

Start by selecting the chart and confirming that its data range includes the cells you expect. Then inspect a zero-valued source cell: select it and look at the formula bar, and check whether it is a number, a formula returning zero, or text that merely looks like zero. A formula returning the numeric value 0 is still a zero for charting purposes. Text values may be interpreted differently from numeric values, so convert or correct them if the chart should treat them as numbers.

Next, check the chart type and axis. For a line chart, select the series and use Format Data Series to choose a visible marker if individual zero points matter. To inspect the vertical axis, right-click it and choose Format Axis; review the Bounds, especially Minimum and Maximum. If the minimum is manually set above zero, reset it to Auto or choose a suitable minimum that includes zero. Avoid changing the scale just to hide data: an axis that excludes zero can make differences look larger than they are.

Hide Zero Values With a Helper Column

If the goal is to omit zero points while keeping the original data intact, make a separate charting range. The usual approach is to return the Excel error value #N/A for a zero and the original value otherwise. Excel charts generally do not plot #N/A as a data point, which makes this more dependable than returning an empty text string.

With original values in B2:B100, enter this formula in C2 and fill it down alongside the source data:

=IF(B2=0,NA(),B2)

If B2 contains 0, the helper cell returns #N/A and the chart omits that point; if B2 contains 12, it returns 12. Point the chart series at the helper column instead of the original values. Keep category labels in their existing range, so dates or names still line up with the corresponding observations. The source column remains unchanged for calculations, tables, and other reports.

This method is useful for line, scatter, and many other chart types, but check the result in the chart you are using. In a line chart, omitted points can leave a visible gap or affect how the line connects, depending on the chart’s treatment of missing data. If zeros are meaningful observations, removing them can also change the story the chart tells. Label the chart or explain the omission when readers could mistake hidden zeros for missing measurements.

Blanks, Empty Strings, and Chart Gaps

Excel provides a chart setting for empty cells. In Microsoft 365 for Windows, select the chart, go to Chart Design > Select Data, and choose Hidden and Empty Cells. The available treatment for empty cells includes showing them as gaps, as zero, or connecting data points with a line where that option applies. These controls address empty cells; they do not turn an ordinary numeric zero into a blank.

A cell containing a formula that returns "" looks empty in the worksheet, but it is not an actually empty cell. Chart behavior can differ by chart type and Excel version, so do not assume that a formula-generated empty string will reliably suppress a point. If predictable omission is important, use NA() in a helper range and confirm the chart’s result.

Excel for Mac has chart-data and empty-cell controls, though labels and dialog layouts can differ from Windows. Excel for the web may not expose every chart-formatting option available in desktop Excel. If you cannot find the empty-cell controls, use the desktop app or use a helper column and check the finished chart.

Make Zero Values Easier to See

If you want to show zeros rather than hide them, choose a chart treatment that makes their position clear. For a line chart, markers make a zero observation visible on the axis. Data labels can also identify zero values, especially when the chart has only a few points; use them selectively on a crowded chart so labels do not overlap. For a column chart, consider adding data labels or choosing a line or scatter chart if the existence of each zero observation matters more than the size of a bar.

Review the axis crossing and scale as well. If the chart includes both positive and negative values, zero may fall in the middle of the plot rather than at its bottom. That is expected. If every value is zero, a chart may have no meaningful variation to display; a descriptive note or table can be clearer than a chart with an automatically chosen scale. Do not set an arbitrary nonzero minimum merely to make zero-height bars appear, because a bar still has no height and the altered scale may mislead.

Chart Labels and Number Formatting

Sometimes the point is visible but its label shows 0 when you would rather suppress the label. That is a different task from omitting the data point. You can format labels or values so zeros are displayed differently, but changing number formatting affects presentation, not the underlying numeric value. The chart can still plot the zero even when a label is hidden or shown as a dash.

For example, a custom number format can use separate sections for positive numbers, negative numbers, and zero. Such formatting is useful when a report should display a dash instead of a zero, but test it on the chart labels as well as the worksheet cells: formatting applied to cells does not always transfer to chart labels in the way you expect. If the actual plotted point must disappear, use the helper-column approach rather than relying on a display format.

Choose the Right Fix

Use the fix that matches the intended message, not just the one that makes the chart look tidy. Keep and emphasize zero when it represents a real observation, such as no sales on a particular day or a measured value at a baseline. Suppress zero when it is a placeholder for no applicable reading, but consider whether a true blank or a separately defined missing-value marker would describe the data more accurately.

Zero is real and should be visible: Add markers or data labels, and check the axis bounds.
Zero should be omitted from the chart: Chart a helper range using NA() for zero values.
The source cell is genuinely blank: Adjust the chart’s empty-cell setting if the chart type supports the desired treatment.
Only the printed or displayed label should change: Format the label, while leaving the plotted value untouched.
The chart skips a supposed zero: Verify the source range, row visibility, and whether the cell contains a numeric value.

In a PivotChart, the chart is tied to its PivotTable and field layout. Check the PivotTable’s filters and the chart’s selected fields before building a separate fix. If you use a helper range, make sure it stays aligned when the underlying data grows or the PivotTable refreshes.

Frequently Asked Questions

Does Excel automatically hide zero values in charts?
Not generally. Excel treats a numeric zero as a value. It can look absent in a column chart because a zero-height bar has no visible length, or in a line chart because the point lies on the axis.

How do I stop a chart from plotting zeros but keep them in the worksheet?
Use a helper column that returns NA() for zeros and the original value for other entries, then use that helper column as the chart series. The source data remains unchanged.

Will changing empty-cell settings hide zeros?
No. The empty-cell settings control how the chart treats blank cells. A numeric zero is not blank. Use a helper range if you need to omit numeric zeros.

Why does my zero show in the worksheet but not in a column chart?
A column with height zero has no visible bar. Add a data label, or use a chart type or marker that makes the observation visible. Also check that the axis includes zero.

Can I hide a zero label without removing the data point?
Yes. Format the data label or its number display separately. The underlying zero can remain plotted, even if its label is changed or hidden.

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.