Excel Graph Y-Axis Not Starting at Zero? How to Fix It

Charts & pivot tables · Updated November 18, 2026

To make an Excel graph’s vertical axis start at zero, right-click the value axis, choose Format Axis, and under Axis Options > Bounds, set Minimum to 0. If the graph is a column or bar chart, a zero baseline is often the clearest choice—but it is not right for every kind of data or every chart.

Set the minimum value to zero

In Excel for Microsoft 365 on Windows, select the chart, then right-click the numbers along its vertical axis and choose Format Axis. In the Format Axis pane, open Axis Options if it is not already selected. Under Bounds, enter 0 in the Minimum box and press Enter. The chart should redraw with zero at the bottom of the value scale. The maximum can remain on Auto unless you have a reason to set it too.

Make sure you click the axis labels, not the chart area, a gridline, or a data series. A chart can have more than one value axis; for example, a combo chart may have a primary axis on the left and a secondary axis on the right. Format the particular axis you want to change. If the chart is a horizontal bar chart, its values usually run along the horizontal axis, so set the minimum on that axis instead.

  • Windows: Right-click the value-axis labels and choose Format Axis.
  • Mac: Control-click the value-axis labels, choose Format Axis, and change the Minimum bound in the formatting pane. The pane layout can differ slightly from Windows.
  • Excel for the web: Select or right-click the axis and look for its formatting options. If the bounds controls are not available in your current web interface, open the workbook in the desktop app.

To restore automatic scaling later, return to the Minimum bound and use its Reset control if shown. This lets Excel choose the bound again. If you do not see that control, inspect the pane carefully before changing other settings; the exact controls can vary between desktop and web versions.

What an axis starting at zero means

The axis minimum is the lowest value shown on the scale, not a change to the numbers in your worksheet. Setting it to zero does not alter the source data, formulas, or chart series. It changes the visual range displayed in the chart. Values below the chosen minimum may be hidden or cut off, so a zero minimum is unsuitable when the data includes negative values that you need readers to see.

Excel uses axes differently depending on the chart type. In a column chart, the vertical axis normally measures the values and the horizontal axis lists categories such as months or products. In a line chart, the vertical axis is also typically the value scale, while the horizontal axis shows categories or dates. In a horizontal bar chart, the value scale is generally horizontal. Scatter charts use value scales on both axes, so the zero setting might be relevant to either one.

People often say graph when they mean any Excel chart, but the setting is specifically an axis bound. If a chart has no numbered vertical scale—for example, some charts use categories or labels without a value axis—there may be no vertical minimum to edit. Check the chart type and which axis carries the numeric values before looking for the Bounds setting.

Why Excel may not start the scale at zero

Excel chooses axis limits automatically when bounds are set to Auto. Its aim is to make the plotted values readable within the available chart area, and the resulting scale may begin above zero. That can make modest differences between nearby values easier to see, especially in a line chart where the direction and size of change are the focus. It can also make differences look much larger than they are if viewers interpret the bars or visual distance as a proportion of the whole scale.

A chart may also have a nonzero minimum because someone manually set the bound, because the chart was copied from another workbook, or because a particular chart setup has its own formatting. The data itself is not necessarily wrong. Check Format Axis > Bounds to tell whether the minimum is a fixed number or is being chosen automatically.

There is an important exception: a logarithmic value axis cannot include zero. A logarithmic scale represents multiplicative intervals, and zero has no logarithm. If the axis is set to logarithmic, Excel will require a positive minimum; turn off the logarithmic scale if a zero baseline is necessary and the data supports a linear scale. Do not use a logarithmic scale merely to force a chart to fit.

When a zero baseline is usually best

For column and bar charts that compare amounts, starting at zero is usually the most straightforward way to communicate the size of each value. The length of a bar or column is visually compared with its baseline. If the baseline begins at 90, a value of 100 gets a visible bar only 10 units tall, while a value of 110 gets one 20 units tall. The second bar can appear twice as tall even though its value is only 10 percent greater. Starting at zero makes the displayed lengths correspond more closely to the actual values.

A zero baseline is especially useful when a chart will be read quickly, viewed without a detailed explanation, or used to compare categories. For example, if three stores sell 100, 105, and 110 items, a column chart with a zero baseline shows that their totals are similar. A truncated axis may instead make the difference between 100 and 110 appear dramatic. The data labels may be accurate, but the visual impression can still be misleading.

Zero is not automatically meaningful for every measurement. Temperatures in Celsius, for instance, can be below zero, and zero Celsius does not mean there is no temperature. Still, if the chart uses columns to compare recorded temperatures, a zero baseline may help compare the numerical values, provided negative values are included. Choose the scale based on what the numbers represent and what comparison the reader needs to make.

When starting above zero can be appropriate

A nonzero minimum can be reasonable when the goal is to show small movements in a continuous series rather than compare bar lengths as parts of a whole. A line chart of a sensor reading that changes from 48.9 to 49.3 may be hard to interpret if the vertical scale runs from zero to 50. A closer range can make the change visible. In that case, label the axis clearly and make the truncated range apparent so readers do not mistake a small change for a large one.

For example, a line chart showing a monthly measurement from 98 to 103 could use a vertical range of 95 to 105 to make the variation legible. That choice is not deceptive by itself. It becomes problematic if the chart is presented as evidence of a dramatic change without noting the scale, or if a reader might assume the vertical axis begins at zero. A title, axis labels, visible tick marks, and a clear caption can supply useful context.

Consider alternatives before narrowing the axis. You might use a larger chart, add data labels, show a separate close-up panel, or describe the change directly. If the chart is intended to compare categories, a zero-based bar or column chart alongside a zoomed-in line chart can preserve both the overall scale and the fine detail.

Choose the scale for the chart type and message

Ask what visual comparison the chart invites. Bars and columns encode values using length, so a zero baseline is generally important. Lines encode a sequence and its movement; a carefully chosen nonzero range can emphasize variation, although it still needs transparent labeling. A scatter chart may need a nonzero range on one or both axes to show a cluster of observations, but the scale should not distort the relationship being examined.

Also consider the data’s sign and units. If values include negatives, setting the minimum to zero can remove part of the series from view. If values are percentages, zero means zero percent only when the underlying values and axis formatting use that interpretation. If the chart uses two axes with different units, changing one axis to zero does not make the two series directly comparable; their scales still represent different quantities.

  • Use zero as the starting point for many bar and column comparisons.
  • Consider a clearly marked nonzero range for a line chart when small changes are the main subject.
  • Keep negative values visible when they matter to the story.
  • Do not compare apparent heights across two axes with different units as if they shared one scale.

Common problems when changing the axis

The Minimum box will not accept zero. Check whether the axis is logarithmic. A log scale cannot display zero, so you must use a linear scale if zero is required. Also verify that you selected the numeric value axis rather than a category axis.

Some data disappears. A fixed minimum can clip values below it. If your series includes negative values, a zero minimum hides the negative portion; use a lower minimum that includes the full range or return the bound to Auto. Check the chart after changing it rather than assuming the setting only affects the baseline.

The axis changes again when data updates. If the bound is on Auto, Excel may recalculate it as the source values change. If you need the chart to keep a zero minimum, enter zero as a fixed bound. The maximum can remain automatic, though its display may adjust as new data is added.

The chart looks different after switching types. A setting that makes sense for a value axis may not apply to a category axis, and a chart type change can alter which axis is numeric. Reopen Format Axis and confirm the selected axis and its role. For a secondary axis, select and format that axis separately.

Frequently Asked Questions

How do I make the Y-axis start at zero in Excel?
Right-click the chart’s vertical value-axis labels, choose Format Axis, then enter 0 under Axis Options > Bounds > Minimum. The exact pane arrangement can differ slightly by platform.

Why does my Excel chart not start at zero automatically?
The axis may be set to Auto, in which case Excel chooses a range based on the data and chart. It may also have a manually fixed minimum, or it may use a logarithmic scale, which cannot include zero. Check the Bounds and scale settings in Format Axis.

Should a graph always start at zero?
No. Zero is usually appropriate for bar and column charts comparing amounts because the lengths are read from a baseline. A line chart focused on small changes may use a nonzero range, as long as the scale is clear and the presentation does not exaggerate the change.

Why can’t I set the minimum to zero?
The most common reason is that the value axis uses a logarithmic scale, where zero is not a valid value. Turn off the logarithmic scale if a linear zero-based axis suits the data. Also check that you are formatting a numeric value axis.

Will changing the Y-axis minimum change my data?
No. It changes the chart’s displayed scale, not the worksheet values or formulas. However, points below a fixed minimum can be cut off, so confirm that the chart still shows the full range of values you intend readers to see.

Check the chart before sharing it

After setting the minimum, inspect the chart at its final size and read it as someone unfamiliar with the workbook would. Confirm that the axis labels and units are visible, that no values have been clipped, and that the chosen scale supports a fair comparison. If the axis starts above zero, make that choice easy to notice and explain when necessary. The best setting is not simply the one that makes the chart look most dramatic; it is the one that makes the relevant data understandable without hiding important context.

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.