Add a Zero Line to an Excel Chart: Methods and Tips

To add a zero line to an Excel chart, either make the value axis cross at 0 or add a separate data series whose values are all zero. The axis method is quickest; a zero-valued series is better when you want a distinctly styled reference line without moving the chart’s axes.

What a zero line means in a chart

A zero line is a visual reference at the value 0. It helps readers distinguish positive values from negative ones, or judge how far results sit above or below a baseline. For example, a monthly variance chart might show values from -12 to 18. A visible line at zero makes it easier to see which months were below target and which were above it.

People use “zero line” to mean two different things in Excel. It can mean the horizontal axis itself, repositioned to cross the vertical value axis at zero. It can also mean an additional plotted series drawn across the chart at zero. These methods can look similar, but they behave differently: moving the axis changes where category labels and the axis line appear, while a helper series adds a reference mark and leaves the axes in place.

The best choice depends on what the chart needs to communicate. If the chart already includes both positive and negative values and you want the categories separated at zero, move the horizontal axis. If you want the category labels to stay at the bottom, or need a colored or dashed reference line, add a series.

Move the horizontal axis to zero

In Excel for Microsoft 365 on Windows, use these steps for a chart with a vertical value axis, such as a column, line, or bar chart:

Select the chart, then click the vertical value axis—the one with the numeric scale.
Right-click the axis and choose Format Axis. The Format Axis pane opens.
Under Axis Options, find Horizontal axis crosses.
Select Axis value, then enter 0 in the value box.
If you want the zero line to stand out, open Fill & Line in the pane and set the axis line to a solid line with a suitable color and width.

Excel now places the horizontal axis at the zero value, provided zero is within the displayed value range. This is often a natural choice for a chart of gains and losses, temperature differences, or budget variances. A column extending upward is positive and one extending downward is negative, with the baseline visibly between them.

This setting is attached to the value axis, not to a particular data point. If you later change the axis bounds or the data range, check the result again. The zero crossing can appear at the edge of the plot area, or fail to appear in the visible region, when the displayed scale does not include zero.

Keep category labels at the bottom

Moving the horizontal axis to zero may also move the category labels from the chart’s bottom edge to the zero crossing. That can be useful when labels should sit beside the positive and negative portions of the plot, but it can make a crowded chart harder to read.

To keep the labels at the bottom while retaining an axis crossing at zero, select the horizontal axis and open Format Axis. Under Labels, set Label Position to Low. The exact options shown depend on the chart type and Excel build. This changes label placement; it does not move the zero crossing itself. If the axis line at zero is also too prominent or awkwardly placed, use a helper series instead and leave the horizontal axis at its usual position.

For a chart with only positive values, zero is often the bottom boundary of the plot area. With only negative values, it may be the top boundary. In either case, an axis at zero may coincide with the plot-area border rather than run through the middle. A reference series can make that boundary easier to style, but it cannot create visible chart space beyond the axis limits.

Add a zero-valued data series

A helper series gives you more control over the line’s appearance. Suppose the worksheet has months in A2:A7 and monthly variances in B2:B7. Add a heading such as Zero reference in C1, then enter 0 in C2:C7. Include the new column in the chart as another series. Repeating the zero value for every category gives Excel a flat series across the chart.

Select the chart and choose Chart Design > Select Data.
In the Select Data Source dialog, choose Add.
Set Series name to the helper-column heading, and set Series values to the cells containing the zeros, such as C2:C7. Do not include the heading in the values range.
Confirm the dialog. If necessary, check that the horizontal category labels still use the month cells in A2:A7.
If Excel plots the new series as columns, choose Chart Design > Change Chart Type and set the helper series to Line. For a column chart, use a combo chart so the original values remain columns and the zero reference is a line.
Select the zero series and use Format Data Series to set its line color, width, or dash style. Turn off markers if Excel displays them.

Keep the helper series on the primary axis in ordinary cases. Putting it on a secondary axis can make its apparent zero position differ from the main values’ zero if the two axes have different scales. A secondary axis is useful only when the chart has a deliberate reason to use a second scale and you have aligned the zero positions appropriately.

On Excel for Mac, the chart design commands and Select Data dialog are available, though their placement and pane layout may vary slightly by release. Excel for the web can handle common chart edits, but some chart-type and formatting controls are more limited; use the desktop app if you cannot set the helper series to a line or cannot find the axis-crossing option.

Choose the method that fits your chart

Use axis crossing when the zero level is part of the chart’s coordinate system and you want the axis to mark the division between positive and negative values. It is fast, does not add worksheet data, and adjusts naturally when the data changes. The trade-off is that it affects axis placement and may also affect where category labels appear.

Use a zero series when the reference line should be independently formatted, when labels must remain at the chart bottom, or when you want the axis to stay in its standard position. A helper column is also easy to document for other workbook users. Its drawback is that it adds a chart series and requires its category values to align with the plotted categories.

Choose axis crossing for a simple positive/negative chart where the zero axis belongs in the middle.
Choose a helper series for a colored, dashed, or heavier baseline that should not relocate the category axis.
Choose both only deliberately: an axis at zero and a zero series can overlap, making the line look thicker or darker than intended.

Chart types and scale details

For a standard column chart, negative columns extend down from zero and positive columns extend up. Moving the horizontal axis to zero often makes the comparison immediately clear. A line chart can also show positive and negative values around a zero crossing, although the connecting line may cross zero between observations rather than at a category.

For a bar chart, the categories run vertically and the value axis runs horizontally. The equivalent zero reference is therefore a vertical line. Setting the category axis to cross the value axis at zero may position the categories at that reference; a helper series may be more straightforward when the goal is a separate vertical marker. Check the orientation of the axes rather than assuming the zero reference will always be horizontal.

Scatter charts use numeric x- and y-axes, unlike category charts. For a horizontal zero reference, add a scatter series with two x-values spanning the visible x-range and y-values of 0 at both endpoints. For example, if the displayed x-range is -5 to 5, the helper points are (-5, 0) and (5, 0). Format the series as a line and remove its markers. If the chart’s x-axis limits change, update the helper endpoints so the reference still spans the plot area. A vertical zero reference uses x-values of 0 at both endpoints and y-values spanning the visible range.

Axis bounds matter. Select the value axis and inspect Format Axis > Axis Options > Bounds. If a fixed minimum and maximum both exclude zero, the zero line cannot appear within the plot. Set bounds that include zero, or return them to automatic if suitable. In a chart with all-positive data, a zero baseline may sit at the bottom; that is mathematically correct, even if the line is not centered.

Common problems and fixes

If “Axis value” is unavailable or the axis options differ, make sure you selected the numeric value axis rather than the category axis. Some chart types, including certain 3-D charts, have different controls or do not support the same axis behavior. Switching to a 2-D chart may expose the expected options.

If the zero series looks like a row of dots, select the series and choose a line chart type or enable its line in Format Data Series; also set the marker option to none. If it appears as a flat bar or column, change only that series to a line using the combo chart settings.

If the line is missing, first verify that the zero values are numeric zeros rather than text, and confirm that the helper series uses the intended category range. Then check whether zero falls inside the plotted scale and whether the line color is visible against the chart background. A line with no width, a transparent line, or markers alone can be difficult to see.

If the zero line is visible but the chart seems misleading, check for a secondary axis. Two axes with different minimum and maximum values can make identical numeric zero positions appear at different heights. Also check whether a manually fixed scale is clipping positive or negative values. A technically visible reference line is only useful when the scale and labels make its meaning clear.

Frequently Asked Questions

Can I add a zero line without changing the data?
Yes. Set the value axis’s horizontal crossing to 0. If you need a separately styled line, add a helper series; that method requires zero values in the worksheet or another source range.

Why does my zero line appear at the bottom of the chart?
If all plotted values are positive, zero is normally at the bottom of the value scale. If all values are negative, it may be at the top. To see it inside the plot, the displayed scale must include values on both sides of zero.

Can I make the zero line dashed or a different color?
Yes. Format the axis line if you used axis crossing, or format the helper data series if you added one. A series is often preferable when you want a strong custom style without changing axis placement.

Does adding a zero line change the underlying values?
No. Moving an axis changes how Excel displays the chart, and a helper series adds plotted reference values. Neither operation edits the original measurements, though adding a helper column does add cells to the worksheet.

Can I add a vertical zero line to a scatter chart?
Yes. Add a scatter series with x-values of 0 and two y-values spanning the chart’s vertical range, then format it as a line without markers. Adjust the endpoints if you later change the displayed y-axis bounds.

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.