Excel Chart Negative Values Below Axis?

Yes. In an Excel chart with a vertical value axis, negative numbers normally plot below the horizontal zero line; if they do not, check that the source values are truly negative, the chart type supports the display you expect, and the value axis includes zero. To position the horizontal axis at zero, right-click the vertical value axis, choose Format Axis, then under Axis Options set Horizontal axis crosses to Axis value and enter 0.

Why negative values appear below the axis

A standard column, line, or area chart uses a vertical value scale. Zero is the dividing point: positive values extend upward from it, while negative values extend downward. For example, if monthly results are 12, 8, -5, and 10, the column for -5 should extend below zero while the other columns rise above it. Excel may place the zero line somewhere other than the bottom of the chart because the chart needs room for both positive and negative values.

The horizontal line through zero is the horizontal axis. It is not necessarily fixed at the bottom of the plot area. When a chart contains negative values, Excel’s automatic axis settings generally move it to a position that makes both sides of the scale visible. This is useful for reading the data, but it can look unexpected if you are used to charts where every value is positive.

One distinction matters: the axis crossing controls where the horizontal axis is drawn, while the axis bounds control which values are visible. Changing one does not always fix the other. A chart can have a zero crossing but still have a scale that hides some data, or it can include negative numbers while the horizontal axis is set to cross at a different value.

Check the chart type and source data

Before changing formatting, confirm that Excel is plotting numeric values below zero. A cell that looks like -5 may actually contain text, such as a minus sign imported as part of a text string. Select the cell and check the formula bar. You can also test whether Excel recognizes the value as a number by changing its number format or using it in a basic calculation. If it is text, convert it to a number before relying on the chart to plot it as a negative value.

Next, check that the negative number is included in the chart’s data range. Select the chart and look at the highlighted source range, or use Chart Design > Select Data. A row or column may have been left out when the chart was created, or the source range may not have expanded to include newly added data. If the chart plots the wrong series, use Select Data to correct the range or series values.

For a column chart, negative values extend downward from the zero line.
For a line chart, negative points appear below zero, and the line connects them to adjacent points.
For a horizontal bar chart, negative values extend to the left of zero, not below it.

That last point often explains the apparent problem. A horizontal bar chart uses a horizontal value axis, so negative values are on the left side of the zero point. If the intended comparison is above and below a baseline, a column chart may be a more intuitive choice.

Set the horizontal axis to cross at zero

In Excel for Microsoft 365 on Windows, use these steps to place the horizontal axis at zero on a chart with a vertical value axis:

Select the chart, then right-click the vertical axis that displays the values.
Choose Format Axis to open the formatting pane.
In Axis Options, find Horizontal axis crosses.
Select Axis value and enter 0 in the value box.

The horizontal axis should now cross the vertical scale at zero, provided zero falls within the displayed axis bounds. The negative columns, points, or areas will be below that line in a vertical chart. If the value box is unavailable or the option is not shown, make sure you selected the value axis rather than the horizontal category axis, and confirm that the chart type has a vertical value axis.

On Excel for Mac, the same setting is available through the Format Axis pane: select or Control-click the value axis, choose Format Axis, and look in Axis Options for Horizontal axis crosses. The precise pane layout can vary by release. Excel for the web has chart-formatting controls too, though their placement and available options may differ from the Windows desktop app; if you cannot find the crossing control, open the workbook in desktop Excel.

Make sure the axis scale includes zero

If zero is outside the axis range, Excel cannot show the crossing where you expect. For example, an axis with a minimum of 5 and a maximum of 20 excludes zero, so it cannot display negative bars below a zero line. To check the range, select the vertical value axis and open Format Axis. Under Axis Options, review Bounds for Minimum and Maximum. Setting a bound to Auto lets Excel calculate it; entering a suitable number fixes the bound manually.

For a chart containing values from -5 to 12, a useful scale might run from -6 to 14, leaving a little space at each end. The exact limits depend on the data and the intended comparison. If you set the minimum and maximum manually, confirm that the minimum is at or below the most negative data point and the maximum is at or above the largest positive point. Include zero as well. Otherwise, a bar or point may be clipped or absent from view.

Axis bounds are display settings; they do not change the values in the worksheet. If the data later changes, a fixed range may no longer fit. Restore Auto bounds or revise the limits when necessary. Also check whether the axis is set to display values in reverse order, since reversing an axis can change the visual orientation and make the chart harder to interpret.

What happens in different chart types

Column charts are usually the clearest choice when the goal is to compare positive and negative amounts against a shared zero baseline. A negative column drops down from zero, making direction and size easy to see. A line chart is often better when the order of the categories represents time or another continuous sequence; negative points fall below zero while the connected line shows the trend.

In a horizontal bar chart, the value axis runs left to right. Positive bars extend right from zero and negative bars extend left. In a stacked chart, positive and negative series can extend in opposite directions from the baseline, but the segments and totals may be less straightforward to compare than in a simple clustered chart. Consider whether readers need to compare individual components or the overall positive and negative result.

Pie and doughnut charts are not suitable for showing negative values as negative slices. These charts represent parts of a whole, and a negative amount does not have a meaningful slice in the ordinary part-to-whole interpretation. Choose a column, bar, or line chart instead when the sign of the value matters.

Format negative values so they are easy to read

Once the values plot in the right direction, improve readability without obscuring the zero line. Select a series and use Chart Format or the Format Data Series pane to change its fill, outline, or marker appearance. Some Excel chart types and formatting choices allow individual points to have a different fill, but the exact controls depend on the chart type. A contrasting color for negative values can help, though color should not be the only way the chart communicates meaning.

Data labels can show the actual amount next to each column or point. Select the chart, choose Chart Design > Add Chart Element > Data Labels, and choose a position that does not overlap the zero line or other labels. For a chart with both positive and negative values, labels may need different positions so they remain legible. If a label omits the minus sign, inspect its number format; a custom format may be displaying negative numbers without a sign.

You can also make the baseline clearer with gridlines or a more visible axis line. Avoid adding so many gridlines that they compete with the data. If the categories are dates or labels, moving category labels to the bottom can sometimes improve the layout while leaving the actual horizontal axis crossing at zero. In Format Axis, look for the label-position setting on the category axis; label placement and axis crossing are separate options.

Common problems and how to fix them

The negative bar is missing: Check that the cell contains a numeric negative value, that the chart source includes it, and that the axis minimum is low enough to show it.
The zero line is at the bottom: The axis may be set to cross at a value other than zero, or the chart may contain only positive values. Set the crossing to 0 and verify the data.
The chart looks upside down: Check for a reversed value axis or a horizontal bar chart, where negative values go left. Confirm the chart type and axis direction.
The labels do not show a minus sign: The source value may be negative even if a custom number format hides the sign. Review the cell and data-label number formats.
Only some negative values appear: Fixed axis bounds may clip the outlying values. Change the bounds to Auto or widen the scale to include the full data range.

Also consider whether the chart is plotting a calculated series rather than the original cells. A formula that converts negative values to positive values, or a chart option that plots a different row or column, can make the picture disagree with the worksheet. Inspect the series values in Chart Design > Select Data when the chart does not match the visible source table.

Choose a chart that makes the comparison clear

If the chart still feels confusing after the axis is corrected, the issue may be the chart design rather than a setting. For results measured against a meaningful target, a column chart with zero as the baseline makes direction explicit. For profit and loss across periods, a line chart can emphasize change over time, while a diverging bar chart can make positive and negative categories easy to compare side by side.

For a waterfall-style explanation of how increases and decreases contribute to a running total, use a Waterfall chart when it is available in your Excel version. It answers a different question from a basic column chart: instead of showing every value relative to zero, it shows how successive changes build toward a total. Do not use it simply to make negative numbers appear below an axis if a straightforward column chart would communicate the data more clearly.

Frequently Asked Questions

Why are my negative values not showing below zero in Excel?
Check that the values are numeric, included in the chart source, and within the vertical axis bounds. Then select the vertical value axis, open Format Axis, and set Horizontal axis crosses to Axis value 0.

How do I make the x-axis cross at zero in Excel?
Right-click the vertical value axis and choose Format Axis. Under Axis Options, set Horizontal axis crosses to Axis value and enter 0. Make sure the axis minimum and maximum include zero.

Can negative values go below the axis in a bar chart?
In an Excel horizontal bar chart, negative values normally extend left of zero because the value axis runs horizontally. Use a column chart if you want negative values to extend down below a horizontal baseline.

Why does Excel put the horizontal axis through the middle of my chart?
If the data includes both positive and negative values, the zero point may be in the middle of the value range. Excel places the horizontal axis there so the chart can show both signs relative to zero; this is expected behavior.

Can a pie chart display negative values?
A pie chart is designed to show positive parts of a whole, not values that extend below zero. Use a column, bar, or line chart to show negative amounts accurately.

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.