Excel Graph Axis Range: How to Set Minimum and Maximum

Charts & pivot tables · Updated November 16, 2026

To change an Excel graph’s axis range, select the chart axis, right-click it, choose Format Axis, and enter values under Axis Options > Bounds for Minimum and Maximum. These controls apply to a value axis; for a category axis, such as the labels along a typical line chart, adjust the label or date-axis settings instead.

What an axis range controls

An axis range is the span of values shown between the axis minimum and maximum. On a column chart, for example, a vertical value axis might run from 0 to 100. If the largest value in the data is 82, Excel may choose a maximum somewhat above 82 and select convenient tick marks automatically. Setting the bounds yourself makes the chart show a deliberate span, such as 0 to 100, rather than relying on Excel’s automatic choice.

Changing the range changes the view of the data, not the underlying worksheet values. A chart that displays only values from 40 to 80 still contains—and may still plot—values outside that span; those points can fall beyond the visible plotting area. Bounds therefore affect interpretation. A narrow range can make small differences easier to see, while a broad range can make those differences appear modest.

Excel charts commonly have a horizontal axis and a vertical axis, but their roles depend on the chart type. In a column chart, the vertical axis usually measures values and the horizontal axis lists categories. In an XY (Scatter) chart, both axes are value axes. You can set numerical bounds on either scatter-plot axis.

Set minimum and maximum on a value axis

  1. Click the chart, then click the axis whose range you want to change. Click the labels or numbers on the axis, not a data point.
  2. Right-click the selected axis and choose Format Axis. The Format Axis pane opens on the right.
  3. In the pane, select Axis Options if it is not already selected. Look for the Bounds fields, usually labeled Minimum and Maximum.
  4. Type the desired lower and upper values. Press Enter after entering each value to apply it.
  5. Check the tick marks and labels. If the chart looks crowded or the intervals are awkward, adjust the major unit as well as the bounds.

For instance, suppose a chart shows monthly totals between 63 and 91. If the purpose is to compare those totals closely, a vertical range of 60 to 100 might be useful. If the chart is comparing performance against a target of 100, a range of 0 to 100 may give more helpful context. The appropriate range depends on what the chart is meant to communicate, not simply on which setting makes the lines or columns look largest.

To return a bound to Excel’s automatic setting, remove the value you entered from the Minimum or Maximum box and press Enter. Excel then chooses that endpoint based on the chart’s data and settings. You can leave one endpoint fixed and the other automatic, though the resulting scale may change when the data changes.

Choose a useful range and interval

Start with the question the chart should answer. A chart intended to show whether values meet a zero-based target often benefits from a baseline of zero. A chart intended to reveal small movements over time may need a tighter range, as long as the limited scale is clear and does not exaggerate the differences. For two charts being compared side by side, matching their minimum and maximum values can make visual comparisons more reliable.

  • Use a zero baseline when it matters. For bars or columns, the length of each bar is read against the baseline. Starting the value axis above zero can make modest differences look much larger than they are.
  • Use sensible endpoints. Round numbers are often easier to read than bounds that precisely match the smallest and largest observations. A range of 0 to 100 is usually easier to interpret than 3 to 97 when the scale represents percentages.
  • Set the major unit for readable ticks. With bounds of 0 and 100, a major unit of 20 produces a simpler scale than a label every 1 unit. The best interval depends on the chart size and audience.
  • Keep comparisons consistent. If separate charts use different scales, similar-looking bars or slopes may represent very different changes. Use the same bounds when readers are expected to compare charts directly.

Excel may choose major and minor units automatically. In Format Axis > Axis Options, enter a major unit to control the spacing between primary tick marks. A minor unit controls smaller intervals when minor tick marks or gridlines are shown. A fixed major unit can improve consistency, but it can also create too many labels if the chart is small or the range is large.

Value axes and category axes are different

A frequent source of confusion is trying to enter a minimum or maximum for the wrong kind of axis. A value axis represents a numerical scale, so it has numeric bounds. A category axis represents labels such as product names, months, or regions. On a standard column or line chart, the horizontal axis is often a category axis, even when its labels look like numbers. It may not offer the same Minimum and Maximum fields.

For a category axis, Excel provides other controls. In Format Axis > Axis Options, you may be able to change the axis type, specify how often labels appear, or set where categories cross the other axis. If the labels are dates, choosing a Date axis can space dates according to time rather than treating each label as an equally spaced category. The available options depend on the chart type and the data Excel recognizes.

If you need numerical horizontal bounds—for example, to show only x-values from 10 to 50—an XY (Scatter) chart is often the right chart type. Scatter charts treat horizontal positions as numbers, so the x-axis has value-axis bounds. A line chart, by contrast, usually spaces its category labels evenly. Switching chart type changes how Excel interprets the horizontal data, so confirm that the chart still represents the data correctly.

Adjust the scale, axis crossing, and number format

Bounds are only one part of the scale. The Format Axis pane may also include options for the major and minor units, display units, logarithmic scale, and the point where the horizontal and vertical axes cross. These settings can improve readability, but they affect different aspects of the chart.

For example, setting the vertical axis to display values in thousands can shorten labels without changing the worksheet data. The number format controls how values appear—for instance, as percentages, currency, or dates—while the bounds determine the numeric span. If a chart’s values look incorrect, check both the axis number format and the source data before changing the range.

The axis-crossing setting controls where one axis meets the other. For a value axis, you can often specify a particular value for the crossing point. This can be useful when negative and positive values are both present, but moving the crossing point does not remove values or change the axis bounds. Keep the distinction in mind: bounds set the visible scale, while crossing settings change the axes’ intersection.

A logarithmic scale is another option for data spanning several orders of magnitude. It spaces values by ratios rather than equal numerical differences. This can make a wide range of positive values easier to view, but it changes how distances on the axis should be interpreted. Excel’s logarithmic-axis option does not work with zero or negative values. Use it only when a logarithmic scale suits the data and can be explained clearly to readers.

Change the range in Excel for Mac or Excel for the web

In Excel for Microsoft 365 on Windows, use the chart’s Format Axis pane as described above. On Excel for Mac, select the chart axis and open Format Axis from the contextual chart-formatting controls or the axis context menu. The pane’s available controls are similar, though the ribbon layout and exact placement can differ by release.

Excel for the web supports chart editing, but its chart-formatting options may not include every control available in the desktop app. If you cannot find a particular bounds, scale, or axis-type setting in the browser, open the workbook in the desktop version of Excel and edit the chart there. After changing the chart, save the workbook so the update is available when you return to the web version.

Common problems and how to fix them

  • The bounds boxes are missing. You may have selected a category axis rather than a value axis. Try selecting the vertical value axis, or change to an XY (Scatter) chart if the horizontal dimension needs numerical bounds.
  • Excel changes the range again. A bound left on Automatic can adjust as data changes. Enter a fixed value for each endpoint you want to keep stable. To restore automatic scaling, clear the fixed value.
  • Some data disappears. A point outside the selected minimum-to-maximum span may be beyond the visible plot area. Expand the bounds to include it, or decide whether excluding it is appropriate for the chart’s purpose.
  • Columns look unusually tall. Check whether the vertical axis starts above zero. That can be appropriate for some close-up views, but it can mislead when bar length is being used to compare magnitudes.
  • Labels are hard to read. The range may be too broad, the major unit too small, or the chart too compact. Try fewer tick labels, a better-fitting chart size, or a more suitable number format.
  • The axis has an unexpected scale. Confirm the chart type, source data, and whether Excel has interpreted the axis as a date, category, or value axis. Changing chart type can change axis behavior.

When a chart is part of a report or dashboard, review it after new data is added. Fixed bounds preserve a stable comparison, but they can also hide newly larger or smaller values outside the range. Automatic bounds adapt to the data, but they can make successive versions of a chart harder to compare. Choose based on whether consistency or automatic inclusion matters more.

Frequently Asked Questions

How do I make an Excel chart axis start at zero?
Right-click the value axis, choose Format Axis, and enter 0 in Axis Options > Bounds > Minimum. Press Enter. If the axis has no Bounds fields, it may be a category axis rather than a value axis.

How do I change the maximum value on an Excel graph?
Select the value axis, open Format Axis, and type the desired number in the Maximum box under Bounds. Press Enter to apply it. Use a maximum that includes all values you intend readers to see.

Can I set the horizontal axis range in Excel?
Yes, if the horizontal axis is a value axis, as it is in an XY (Scatter) chart. A category axis on a typical line or column chart usually has category and label controls rather than numerical minimum and maximum bounds.

How do I return an axis range to automatic?
In the Format Axis pane, clear the fixed Minimum or Maximum value and press Enter. Excel will choose that endpoint automatically. Clear both values if you want Excel to determine the entire range.

Why does Excel not show axis bounds?
The selected axis may be a category axis, or the chart type may not support numeric bounds for that axis. Select a value axis instead. If you need a numerical x-axis range, consider whether an XY (Scatter) chart better fits your data.

A practical final check

After setting the range, compare the chart with the worksheet values and ask whether the scale supports a fair reading. Confirm that important values are visible, the tick labels are understandable, and the baseline fits the chart type and purpose. If the chart will be compared with another chart, check that the scales match where needed. A well-chosen axis range makes the data easier to interpret without changing what the data actually says.

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.