Excel Chart Y-Axis Range: Set Minimum and Maximum

Charts & pivot tables · Updated November 19, 2026

To change an Excel chart’s y-axis range, select the vertical value axis, open Format Axis, and enter the values you want under Bounds for Minimum and Maximum. Excel applies those limits to the chart; leave a bound on Auto, or reset it, to let Excel choose it.

Set the minimum and maximum in Excel

These steps apply to Excel for Microsoft 365 on Windows. The same Format Axis controls are available in current Excel for Mac, although the pane and ribbon may look slightly different.

  1. Click the chart, then click the vertical axis whose range you want to change. If it is difficult to select, use the Format tab’s Current Selection list and choose the vertical value axis.
  2. Right-click the selected axis and choose Format Axis. You can also press Ctrl+1 on Windows to open the formatting pane. On Mac, use Command+1 after selecting the axis, or open Format Axis from its context menu.
  3. In the Format Axis pane, select Axis Options and find Bounds. Type the desired value into Minimum, Maximum, or both. For example, set Minimum to 0 and Maximum to 100 to show a range from zero to one hundred.
  4. Close the pane or click elsewhere in the chart. Excel updates the display immediately. To return a bound to automatic scaling, use the Reset control beside the edited value when it appears.

Bounds must make sense together: the minimum should be less than the maximum. Use numbers that fit the data and the axis type. A date axis, percentage display, or logarithmic axis can have additional constraints, discussed below.

What the axis range controls

The y-axis range is the span of values shown on the chart’s vertical value axis. Its minimum is the lowest value represented at the bottom of the plotting area, and its maximum is the highest value at the top. Changing these limits changes the visual scale, not the source data, the chart’s formulas, or the values stored in the worksheet.

With automatic bounds, Excel chooses limits based on the plotted values and chart settings. It may add space above or below the data and select rounded tick marks to make the scale readable. Those choices can change when the source data changes. Fixed bounds keep the display steady, which is useful for comparing charts or monitoring a series over time, but they can hide values that later fall outside the chosen range.

Setting a range is different from filtering the chart or changing its data source. If a value is above a fixed maximum, its plotted point may be clipped at the top or not appear as expected; the worksheet value remains intact. If values are missing, first check the chart’s selected data range and filters rather than assuming the axis bounds removed the records.

How to choose a useful range

Choose bounds that make the pattern clear without exaggerating or concealing important differences. The right choice depends on the question the chart is meant to answer, the type of data, and whether readers need to compare it with another chart.

  • For counts and totals: A zero minimum is often a sensible baseline, especially for column and bar charts. If the chart compares 0, 20, and 40 units, a zero baseline makes the bar lengths correspond proportionally to their values.
  • For small changes in measurements: A tighter range can make variation visible. For example, daily temperatures of 18, 19, 20, and 21 degrees may be easier to inspect on a 15-to-24 range than on a 0-to-100 range. Label the scale clearly, because the shorter range makes the differences look larger.
  • For comparisons across charts: Use the same minimum and maximum on each chart when readers are comparing magnitude. Letting each chart autoscale independently can make similar series look dramatically different, or make very different series look similar.
  • For a changing live report: Consider leaving bounds on Auto if new values should always remain visible. Fixed limits work better when a stable scale is more important than automatically accommodating outliers.

A common misconception is that every chart must start at zero. Zero is important for bar and column charts because viewers judge values by the lengths of bars. A line chart focused on movement may use a nonzero minimum if the scale is conspicuous and the presentation does not imply a larger change than the data supports. There is no universally correct bound: make the choice transparent and appropriate to the comparison.

Set tick spacing and number formatting

Bounds determine the ends of the scale; they do not necessarily determine how many labels appear between them. In Format Axis, use Units to adjust the major interval, which controls the spacing of major tick marks and usually the labeled gridlines. A chart running from 0 to 100 might use a major unit of 20 to label 0, 20, 40, 60, 80, and 100. A major unit of 10 would show more detail but use more labels.

Minor units can add smaller tick marks between major intervals, if they are useful. Too many labels or gridlines can make a chart crowded, so choose intervals that are easy to read and fit the chart’s dimensions. Excel may choose a different major unit when the bounds change, so review the labels after setting a fixed range.

Number formatting is separate from the range. In the Format Axis pane, use Number to display values as percentages, currency, dates, or a chosen number of decimal places. For example, a bound of 1 can be displayed as 100% if the axis number format is Percentage. Formatting changes how a value appears, not its underlying numeric value; check that the labels match how readers will interpret the data.

Check which axis you are editing

Not every chart’s vertical axis is a value axis. In a column, line, or area chart, the vertical axis usually represents values, while the horizontal axis represents categories or dates. In a horizontal bar chart, the value axis is horizontal and the vertical axis lists categories. If the Bounds controls do not show the range you expect, check whether you selected the value axis rather than the category axis.

XY (scatter) charts use value axes on both the horizontal and vertical directions. You can set each axis independently, which matters when the horizontal and vertical quantities have different scales. Some chart types, including charts with a secondary axis, can have more than one value axis. Select the axis next to the data series you intend to format; otherwise you may change a scale that belongs to a different series.

Date axes and category axes can offer options that differ from ordinary numeric value axes. A date axis may let you set date limits and units, but it is not the same as changing a numeric y-axis bound. For a line chart with dates on the horizontal axis, the y-axis is normally the value scale; for a bar chart, verify the orientation before changing anything.

Common problems and limits

  • The chart does not change: Confirm that the correct axis is selected and that the entry was applied. If the chart has a secondary axis, you may be editing the other scale. Also check for chart filters or hidden series that affect what is plotted.
  • Some points disappear: A fixed minimum or maximum may exclude values. Expand the bounds or reset them to Auto if every observation should remain visible. This does not delete data, but clipping can make a chart incomplete.
  • Excel changes the scale later: A bound left on Auto can move when data is added or removed. If a report needs a consistent scale, set both bounds explicitly and revisit them when the expected data range changes.
  • The axis will not accept zero: A logarithmic scale cannot represent zero or negative values. In Axis Options, turn off Logarithmic scale if a linear scale is required, or use only positive values when a logarithmic view is appropriate.

Logarithmic scaling is not just a different pair of bounds: equal distances represent multiplicative changes rather than equal numerical additions. It can help show values spanning several orders of magnitude, but it is unsuitable for zero or negative data and may confuse readers unfamiliar with it. Do not use it merely to make a crowded chart fit.

Axis bounds versus axis crossing

The axis range and the point where axes cross are related but separate settings. Bounds decide what values the axis displays. The crossing setting determines where the horizontal axis meets the vertical value scale, or where the vertical axis meets the horizontal scale. In a chart with negative and positive values, the axes may cross at zero, inside the plotting area. Changing the minimum does not necessarily change that crossing point.

If labels or the horizontal axis appear in an unexpected position, inspect the crossing options in Format Axis rather than changing the bounds blindly. Likewise, reversing category order or switching the order in which values are displayed is an axis-order setting, not a range adjustment. These controls can alter the chart’s appearance without changing its data.

Frequently Asked Questions

How do I make an Excel chart y-axis start at zero?
Select the vertical value axis, open Format Axis, and enter 0 for the Minimum under Bounds. This is often useful for bar and column charts, but check that the resulting scale still makes the data readable.

Can I set only the maximum and leave the minimum automatic?
Yes. Enter a fixed Maximum and leave Minimum on Auto, or reset Minimum to Auto if it was previously fixed. Excel then chooses the lower bound while respecting the maximum you specified.

Why does my chart y-axis not show Bounds?
You may have selected a category axis, chart title, gridline, or another object instead of a numeric value axis. Click the axis labels and reopen Format Axis. In a horizontal bar chart, the value axis is usually horizontal rather than vertical.

Can a chart show negative values with a fixed range?
Yes, on a standard linear value axis you can set a negative minimum and a positive maximum, as long as the limits are valid. The axis may cross at zero, so adjust the crossing option separately if its position is not suitable.

Will changing the y-axis range change my worksheet data?
No. It changes the chart’s displayed scale only. The source cells and their values remain unchanged, although values outside fixed bounds may be clipped or not visibly represented in the plot.

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.