A zero line on a graph is the reference line marking a value of zero on an axis. It helps you see which plotted values are positive, negative, or exactly zero; in Excel, it may appear automatically as an axis or gridline, or you can add a separate line when the chart does not show it clearly.
What the zero line represents
On a graph with numerical values, zero is the point that separates values greater than zero from values less than zero. A horizontal zero line usually marks y = 0, while a vertical zero line usually marks x = 0. Which direction it runs depends on the graph and the variable being measured. In a standard coordinate plane, the x-axis itself is the horizontal zero line for y-values, and the y-axis is the vertical zero line for x-values.
The line is a reference, not necessarily a series of measured data. It gives the reader a fixed baseline against which to judge the data. For example, a monthly profit chart might show positive values above zero and losses below it. A temperature chart could use zero to distinguish below-freezing readings from above-freezing readings, provided the temperature scale is defined in the usual way.
“Zero line” is sometimes used loosely to mean the horizontal axis, a gridline at zero, or a separately drawn reference series. These are related but not always identical. A chart’s horizontal axis might sit at the bottom even when the vertical scale includes negative values; a zero gridline, by contrast, runs through the plot at the actual zero value. The distinction matters when interpreting a chart.
Why it matters when reading a graph
Without a clear zero reference, it can be harder to interpret direction and magnitude. A value of −5 and a value of +5 have the same distance from zero but represent opposite directions. The zero line makes that difference immediately visible. This is useful for data such as net gains and losses, departures from a target, account balances, changes in inventory, and deviations from an average.
It also prevents a common reading mistake: treating the bottom edge of the chart as if it were zero. If the plotted range runs from 40 to 60, the bottom of the plot is 40, not zero. A bar rising from 40 to 50 represents a change of 10 units, but it may look much larger than a bar on a chart whose scale starts at zero. A visible zero reference, a clearly labeled scale, or both help readers understand what the chart actually shows.
Zero is not always the most important reference. A chart about whether a project is ahead of schedule might be easier to read with a separate target line at the planned completion value. A zero line answers “where is no amount or no difference?” A target line answers “where is the desired or expected amount?” They should not be confused.
How a zero line works with positive and negative values
For a graph to show a zero line inside its plotting area, its numerical axis must include zero. If the axis range runs from −20 to 20, zero falls between the endpoints, and a horizontal line can cross the data area. If the range runs only from 2 to 20, zero is outside the displayed range; a zero line cannot appear inside the plot unless the scale is changed or a separate reference is added.
On a typical graph of values over time, time is placed along the horizontal axis and the measured values on the vertical axis. The zero line is horizontal because it marks zero on the vertical scale. On a scatter plot of two numerical variables, zero may matter on either axis: x = 0 is vertical and y = 0 is horizontal. If both axes include zero, the two reference lines meet at the origin, the point (0, 0).
When all data are positive, zero may sit at the bottom of the plot rather than passing through its middle. When data include both positive and negative values, it usually lies within the plot. The line’s position is determined by the scale, not by the visual midpoint of the chart. A zero line should therefore be interpreted alongside the axis labels and tick marks.
Common chart types and their zero lines
Column and bar charts often use a zero baseline because bar length is judged by the distance from the baseline. With positive and negative values, columns can extend upward and downward from zero, making gains and losses easy to compare. A line chart instead connects data points; its zero line helps show when the series crosses from negative to positive or the reverse.
In a scatter chart, zero lines can mark the origin or split the plot into positive and negative regions. This can be helpful when comparing two quantities that can both be above or below zero, such as differences from two targets. In a financial chart, a horizontal line at zero can separate gains from losses, but the units and scale still need to be stated clearly.
Not every chart needs a zero line. A chart of values that are all positive may have no visible zero reference if its vertical axis is deliberately narrowed to show small changes. That can be appropriate for some analytical purposes, but it can also exaggerate apparent variation. The chart should make its scale clear, and the choice should suit the question the graph is meant to answer.
Show a zero line in Excel
In Excel for Microsoft 365 on Windows, first check whether zero is included in the value axis. Select the chart, click the value axis, right-click and choose Format Axis. In the Format Axis pane, under Axis Options, set the minimum or maximum bound so the displayed scale includes 0. Excel may show a zero gridline when zero falls within the scale, depending on the chart and its gridline settings.
If you want the horizontal axis itself to cross the chart at zero, select the vertical value axis and look in Axis Options for Horizontal axis crosses. Choose the option to cross at an axis value and enter 0 when that option is available. The horizontal axis will then sit at the zero level instead of at the bottom of the plot. This changes the axis position; it does not necessarily create a separately styled reference line.
For a prominent zero line that remains distinct from the axes, add a helper data series. For a line or column chart with categories such as months, create a column of zero values with one zero for each category. Select the chart, go to Chart Design > Select Data > Add, and use the zero-value cells for the new series. Format that series so it is easy to distinguish. Depending on the chart type, Excel may require changing the added series to a line through Chart Design > Change Chart Type.
For an XY scatter chart, a horizontal zero reference needs x-values spanning the chart and y-values all equal to zero. Add those values as a new series using Chart Design > Select Data > Add, then set the series to a line and remove its markers if appropriate. To draw a vertical x = 0 reference instead, use x-values all equal to zero and y-values spanning the visible vertical range. Keep the helper values outside the main data area or label them clearly so they are not mistaken for observations.
On Excel for Mac, the chart concepts are the same, but ribbon placement and the formatting pane can look different. Select the chart or axis and use the chart formatting controls to locate axis options; if the interface does not offer the crossing setting you need, adding a zero-valued helper series is a practical alternative. Excel for the web also has chart editing controls, though some detailed formatting options may be more limited than in the desktop app.
Choose between an axis, gridline, and reference series
These options can all make zero visible, but they serve slightly different purposes:
- Axis at zero: Useful when the axis should divide positive and negative values. It also makes the axis labels and tick marks part of the reference.
- Gridline at zero: Useful when you want to preserve the chart’s axis placement but make the zero level easy to locate. It can look like other gridlines unless styled or emphasized.
- Separate reference series: Useful when you need a bold, colored, or dashed line, especially when the chart does not display a zero gridline in the desired way.
Consider the chart’s purpose before choosing. If the zero line is central to interpretation, give it enough contrast to find quickly, but do not make it so heavy that it competes with the data. If the line represents a target or threshold rather than mathematical zero, label it accordingly. A reader should be able to tell whether the line means zero, a goal, or another benchmark.
Common problems and misleading readings
A missing zero line often means zero is outside the displayed axis range, the relevant gridline is turned off, or the chart type does not display the reference as expected. Check the scale first: changing the bounds may reveal zero. If the data do not include values near zero, it can still be useful to show the line, but widening the scale may compress the data and make small differences harder to see.
A second problem is assuming that the chart’s bottom edge equals zero. This is not always true, particularly when an axis is truncated to highlight variation. Read the tick labels rather than estimating from the frame. Truncated scales can be useful for line charts when the goal is to compare small movements, but they can be misleading in bar charts because bar lengths imply a baseline. Make the scale choice visible and consider whether a zero-based display would better support fair comparison.
Finally, a line at zero is not proof that a value is “normal,” safe, or desirable. Zero may mean no change, no balance, or no measured amount, but its meaning comes from the definition of the variable. For example, zero change from a target is different from zero total output. Explain the measure and units so the reference has a clear interpretation.
Frequently Asked Questions
Is the x-axis always the zero line?
No. In a standard coordinate graph, the x-axis represents y = 0, but a chart’s horizontal category axis may be placed at the bottom even when the value axis includes negative numbers. Check the scale and axis labels to see where zero actually falls.
What is the zero line called on a coordinate plane?
The horizontal zero line for y-values is the x-axis, and the vertical zero line for x-values is the y-axis. They meet at the origin, (0, 0).
Why is there no zero line on my Excel chart?
Zero may be outside the value-axis bounds, gridlines may not be displayed, or that chart type may not show the line as expected. Check the axis bounds and gridline settings, or add a zero-valued helper series for a custom reference.
Does a zero line have to be in the middle of a graph?
No. Its location depends on the scale. If the axis runs from −10 to 30, zero is one quarter of the way up from the minimum, not at the midpoint. The axis range determines the position.
Is a zero line the same as a trendline?
No. A zero line marks the value zero on an axis and is usually fixed. A trendline summarizes a pattern in the data, such as an upward or downward tendency. They answer different questions and may both appear on one graph.
Related
- Balance of Payments Mind Map: Accounts and Flows
- Split a Part in Onshape: Steps, Uses, and Fixes
- Excel Goal Seek on Multiple Cells Explained
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- How to Combine Pie Charts in Excel: A Practical GuideTo combine pie charts in Excel into one chart, first combine their source data into a single list…
- Excel Pivot Table: Group Dates by Month, Quarter, YearIn an Excel PivotTable, you can group a date field by month, quarter, year, or several of those…
- Create a Pivot Table in Excel: Steps and Tips That WorkTo create a PivotTable in Excel for Microsoft 365 on Windows, select a cell in a well-organized data…
- How to Make a Log Graph in Google SheetsTo make a log graph in Google Sheets, put your data in columns, select it, choose Insert >…
- Excel Pivot Chart Pareto: Build and Read OneYes—but Excel cannot create a Pareto chart as a native PivotChart. The practical workaround is to build a…
- Excel Line Chart With Two Y-Axes: How to Create OneYes. In Excel for Microsoft 365 on Windows, create a line chart, select the series that needs its…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.