Excel Chart Axis Range: Set Minimum and Maximum Values

To change an Excel chart’s numeric axis range in Microsoft 365 for Windows, select the chart axis, right-click it, choose Format Axis, and enter new values under Bounds for Minimum and Maximum. This fixes the displayed scale instead of letting Excel choose it automatically; the exact controls depend on whether you selected a value axis or a category axis.

Set a numeric axis minimum and maximum

Most often, people want to change the vertical value axis on a column or line chart, or the horizontal value axis on a bar chart. These are numeric axes, so you can set their lower and upper bounds. Follow these steps in Excel for Microsoft 365 on Windows:

Click the chart, then click the axis whose scale you want to change. Click its numbers or tick marks rather than a data series.
Right-click the selected axis and choose Format Axis. You can also select the axis and press Ctrl+1 to open the Format Axis pane.
In the pane, select Axis Options if it is not already open. Under Bounds, enter the desired value in Minimum, Maximum, or both.
Press Enter after each value. The chart updates to use the fixed bound. You can leave the other bound automatic if only one end needs adjusting.

For example, if the vertical axis currently runs from 0 to 120 and the meaningful values in the chart are 42 to 68, setting Minimum to 40 and Maximum to 70 can make differences easier to see. Those numbers are an illustration, not a recommended scale for every chart: choose bounds that suit the data and make the size of differences clear.

To return a bound to Excel’s automatic choice, use the Reset control next to that bound when it is shown in the pane. The label or appearance can vary slightly between Excel builds. If there is no Reset control, remove the fixed entry or use the automatic setting available for that field.

Understand value axes and category axes

A chart’s axes do different jobs. A value axis is a continuous numerical scale, such as 0, 10, 20, and 30. A category axis lists labels, such as months, product names, or departments. The axis you can edit depends on the chart type and the data being plotted.

In a standard column chart, the vertical axis is usually the value axis and the horizontal axis contains categories. In a bar chart, the orientation is reversed: the horizontal axis is usually numeric, while the vertical axis lists categories. In a scatter chart, both axes are value axes because each point has an x-coordinate and a y-coordinate. This distinction explains why selecting the bottom axis of a column chart may not show Minimum and Maximum fields.

A category axis does not generally have numeric minimum and maximum bounds in the same way as a value axis. To change which category labels appear, edit the chart’s source data or filter the chart. For a date axis, Excel may offer date-specific controls such as units or a base unit, because it treats dates as a timeline. A date axis still is not the same as a numeric value axis with freely chosen bounds in every chart type.

If your goal is to set a numeric range but the selected axis has no Bounds section, check that you selected the value axis. If the chart’s structure does not provide the numeric axis you need, a different chart type may be more appropriate.

Choose bounds that make the data honest and readable

The best range is not always the tightest range. A narrower scale can reveal small changes, but it can also make modest differences look dramatic. A scale beginning at zero is often useful for column and bar charts because the length of each bar visually represents its value. For a line chart showing a small movement in a measurement, a nonzero minimum may help readers see the pattern, provided the axis labels make the truncated range obvious.

Before fixing bounds, consider these factors:

What the chart is meant to compare: For absolute amounts, include a meaningful baseline. For variation over time, a closer range may help, but do not hide the broader context.
Whether readers will compare charts: Use consistent minimums and maximums across charts intended for side-by-side comparison. Excel’s automatic bounds can differ from one chart to another.
Whether values can change: A fixed maximum can cut off future data. Leave room for expected growth or keep the bound automatic if the chart is a live report.
How labels and gridlines fit: Allow enough space for readable intervals and avoid unnecessary decimal places.

For instance, two charts showing monthly revenue might both use a 0-to-100,000 scale if readers need to compare their heights directly, even when one series peaks at 60,000. If the purpose is instead to inspect changes within each location, separate scales might reveal detail but make the charts less directly comparable. State the scale clearly so the audience understands the choice.

Set the interval and axis labels

Changing the minimum and maximum controls the span, but it does not always produce the clearest tick marks. In Format Axis, the Units settings let you adjust the Major interval, which determines the spacing between principal tick marks and labels. Depending on the axis and chart, Excel may also offer a Minor interval for smaller subdivisions. For example, a value axis from 0 to 100 might use a major unit of 20 to show labels at 0, 20, 40, 60, 80, and 100.

Use an interval that is easy to interpret. An interval of 7 may be suitable for daily data in some contexts, while increments of 10, 25, or 100 are often easier to scan for quantities. Excel may choose different intervals after you change the bounds, so inspect the chart rather than assuming the labels will remain as they were.

Axis labels have separate formatting controls. In the Format Axis pane, Number settings can change how values appear—for example, as currency, percentages, or values with fewer decimal places. Number formatting changes the display, not the underlying data or the axis bounds. If labels overlap, consider a larger chart, fewer labels, or a different label interval rather than shrinking the text until it is difficult to read.

How chart type affects the range controls

Chart type determines which axis controls are available and how readers interpret the scale. In a line or column chart, the category axis usually spaces points or columns by category. A scatter chart uses numeric values on both axes, so you can set bounds for both dimensions. Scatter charts are useful when horizontal spacing represents actual numeric differences, not just the order of categories.

For a date-based line chart, Excel may treat the horizontal axis as a date axis. If the dates appear unevenly spaced or the controls do not match your expectation, select the horizontal axis and inspect Axis Options for the axis type. A text axis treats labels as equally spaced categories; a date axis positions dates along a timeline. Which one is right depends on whether the time gaps between observations matter.

Combo charts and charts with a secondary axis need extra care. A series can be plotted on a secondary value axis, often shown on the right side of the chart. Select that axis itself before changing its bounds. A primary axis and a secondary axis can have different scales, which may make two series look closely related even when their values differ substantially. Use a secondary axis only when it helps interpret series with different units or ranges, and label it clearly.

Common problems and how to fix them

There are no Minimum or Maximum boxes: You may have selected the category axis, chart title, or data series. Click the numeric tick labels on the value axis and open Format Axis again.
The chart does not show all the data: A fixed maximum may be below the largest value, or a fixed minimum may be above the smallest. Raise the maximum, lower the minimum, or reset the affected bound to automatic.
The chart looks misleading after changing the scale: Check whether the vertical axis starts above zero and whether the reader can see the axis labels. For bars and columns, a truncated baseline can exaggerate differences.
The axis will not accept the value: Check that the value is valid for the data and axis type. A logarithmic scale, for example, cannot display zero or negative values. If Logarithmic scale is enabled in Axis Options, turn it off when your data include zero or negative numbers.
Excel changes the scale after data updates: A bound set to automatic can move as the underlying values change. Fixed bounds remain fixed, so they can exclude new values. Decide whether the chart should adapt or preserve a stable comparison scale.
The wrong series seems affected: In a chart with multiple axes, verify whether the selected axis is primary or secondary. Changing one does not automatically change the other.

One frequent misconception is that changing the axis range changes the values in the worksheet. It does not: it changes how the chart maps and displays those values. The source cells remain unchanged. Likewise, formatting an axis label as currency does not convert the source data into a different amount; it changes the label’s appearance.

Excel for Mac and Excel for the web

In Excel for Mac, select the axis and use the Format Axis pane to edit its bounds. The pane and controls are broadly comparable to the Windows desktop version, although keyboard shortcuts and some interface details differ. On Mac, Command+1 opens the Format dialog for a selected chart element in supported desktop versions; use the context menu if the shortcut does not open the axis pane in your build. Windows users can use Ctrl+1.

Excel for the web has chart-formatting tools, but some detailed axis options may be unavailable or presented differently from the desktop app. If you cannot find the Bounds controls, open the workbook in the Excel desktop app and change the axis there. The chart remains part of the workbook, and you can return to the browser afterward.

Frequently Asked Questions

How do I make an Excel chart axis start at zero?
Select the numeric axis, open Format Axis, and set Minimum under Bounds to 0. This fixes the lower end at zero. Check that the chart type and scale still communicate the data accurately.

Why can’t I change the horizontal axis range?
On many column and line charts, the horizontal axis is a category axis, not a numeric value axis, so it has no ordinary numeric minimum and maximum. Use a scatter chart if both horizontal and vertical positions need numerical scales, or adjust the categories or date-axis settings.

How do I restore an automatic chart scale?
Select the relevant value axis and open Format Axis. Use Reset beside Minimum or Maximum, if shown, to return that bound to automatic. Check both ends if you want Excel to choose the entire range again.

Can I set different ranges for two chart series?
Only when the chart uses separate value axes, such as a secondary axis. Select the axis associated with the relevant series and set its bounds. Be cautious: separate scales can make the visual relationship between series harder to interpret.

Does changing the axis range change the worksheet values?
No. It changes the chart’s displayed scale, not the source cells. The plotted values remain the same, though a fixed range can make some values fall outside the visible chart area.

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.