Excel Chart Axis Range: Set Minimum and Maximum Values

To adjust an Excel chart’s axis range, select the value axis, open Format Axis, and enter new values under Axis Options > Bounds for Minimum and Maximum. Excel uses automatic bounds by default; setting fixed bounds changes the chart’s displayed scale, not the data in your worksheet.

Set a fixed axis range in Excel

These steps apply to Excel for Microsoft 365 on Windows and to charts with a numeric value axis, such as a column chart’s vertical axis or a scatter chart’s horizontal axis.

Click the chart, then click the axis whose range you want to change. Check that the axis labels are highlighted so you have selected the axis, not a series or gridline.
Right-click the selected axis and choose Format Axis. The Format Axis pane opens. On a Mac, Control-click or right-click the axis and choose Format Axis; the pane and available options may look slightly different.
In the pane, open Axis Options if necessary. Under Bounds, enter the desired Minimum and Maximum, then press Enter after each value.
Optionally adjust Units to control the spacing between tick marks. Review the chart to make sure the new scale is readable and does not hide important variation.

For example, if a column chart compares values from 82 to 96, setting the vertical axis minimum to 0 and maximum to 100 makes the bars start at the baseline and gives the scale an intuitive reference. If you instead set the minimum to 80 and maximum to 100, small differences among the values become more visible, but the bars no longer show the full distance from zero. That choice affects how readers interpret the comparison.

What changing the bounds actually does

Minimum and maximum are the lower and upper limits of the visible axis. Excel normally chooses them automatically based on the plotted values, often adding some space above or below the data. A fixed bound tells Excel to use a specific limit rather than recalculate it whenever the data changes.

This is a display setting, not a data filter. If a value falls outside the range, Excel does not remove it from the worksheet or alter the source series. Depending on the chart type, the point or part of a column may simply be outside the visible plotting area. To show the entire series again, widen the bounds or restore automatic scaling.

Bounds and units are separate settings. Bounds determine the extent of the axis; units determine the intervals used for labels and tick marks within that extent. For instance, a range from 0 to 100 might use major units of 20, creating labels at 0, 20, 40, 60, 80, and 100. Excel may choose a different interval if major units remain automatic.

How to choose useful minimum and maximum values

Choose bounds for the question the chart needs to answer, not simply because a tighter range makes the data look more dramatic. A range that is too wide can make modest changes hard to see; one that is too narrow can exaggerate them or clip observations. Keep the scale consistent when readers are comparing multiple charts.

For quantities with a meaningful zero: Use zero as the minimum when comparing magnitudes, especially with bars and columns. A bar’s length visually represents its value, so a truncated baseline can overstate differences.
For detail in a time series: A narrower vertical range can help reveal small movements, such as monthly temperatures or sensor readings. Make the nonzero baseline clear in the axis labels or chart notes.
For a known target or threshold: Set bounds that include the target and enough space around it to show whether observations are above or below. Add a reference line if readers need to see the target directly.
For comparisons across charts: Use the same minimum, maximum, and units on charts intended for side-by-side comparison. Automatic scaling can give identical values different visual heights in separate charts.

There is no universally correct range. A column chart of sales totals and a line chart tracking a small change in a laboratory measurement may call for different scales. Include units in the axis title and use clear labels so readers can understand the chosen bounds without guessing.

Which chart axes can have numeric bounds?

Bounds are available for a value axis. In a column chart, the vertical axis is usually the value axis and the horizontal axis lists categories. In a horizontal bar chart, the horizontal axis is usually the value axis. In a scatter chart, both axes are numeric, so you can set bounds on either one. The orientation of the chart therefore matters when deciding which axis to format.

A category axis, such as one listing product names or months as discrete labels, does not generally offer numeric minimum and maximum bounds in the same way. A date axis is a special case: Excel treats dates as positions along a time scale, and its formatting options can include date-based bounds. If the axis is behaving like a list of text categories rather than a time scale, check the axis type in Format Axis and the source data format.

To see whether you have selected the correct axis, click it and look at the pane. Numeric Bounds should appear for a value axis. If they do not, you may have selected the category axis, a data series, or a chart element that does not support those settings.

Examples: column, line, and scatter charts

For a column chart, consider values of 42, 47, and 51. With the vertical axis starting at zero, the chart communicates their relative sizes against the full scale. Setting the minimum to 40 makes the differences easier to spot, but the bars begin at 40 rather than zero. That can be useful for examining small changes, provided the truncated scale is intentional and not misleading.

For a line chart showing weekly website visits between 9,500 and 10,300, a vertical axis from 9,000 to 11,000 may make movement easier to see than a scale beginning at zero. If the chart is used to compare performance over time, keep those bounds stable when adding new weeks; otherwise, an automatic range may shift and make the same change look larger or smaller.

For a scatter chart, you can set horizontal and vertical bounds independently. Suppose the horizontal axis represents hours from 0 to 24 and the vertical axis represents temperature from -10 to 30 degrees. Set the horizontal bounds to 0 and 24, and the vertical bounds to -10 and 30. This keeps the plotted area focused on the period and values that matter. Do not assume the two axes need matching limits: their units and meanings are different.

Automatic scaling, resetting, and changing data

Automatic scaling is convenient when values change frequently and you want Excel to keep the full series visible. Fixed bounds are better when a chart needs a stable reference, such as a monthly report or a comparison between several periods. A common practice is to fix only one end of the scale—for example, keep the minimum at zero while allowing the maximum to adjust—if that suits the chart’s purpose.

To return an individual bound to automatic scaling, open Format Axis and clear the value you entered or use the reset control shown beside that bound, if available in your Excel build. Press Enter and let Excel recalculate the scale. Resetting one bound does not necessarily reset the other, so check both fields if you want the entire axis to be automatic.

When new data extends beyond a fixed limit, the chart may appear to omit the newest high or low values. The source cells can still contain those values. Increase the relevant bound, or return it to automatic, and inspect the chart again. If a report is updated regularly, document fixed limits so another editor knows that the scale is intentional.

Common axis-range problems

The Bounds fields are missing: Select a numeric value axis rather than the category axis or a series. In a bar chart, the value axis is horizontal, which can be easy to overlook.
The chart looks empty after changing a limit: A bound may exclude most or all of the data. Reopen Format Axis and check the source values and the entered minimum and maximum.
Excel changes the scale after an edit: One or both bounds may still be automatic. A fixed maximum does not automatically fix the minimum.
Tick labels are crowded or awkward: Adjust the major unit, enlarge the chart, or simplify the number format. A suitable range can still be hard to read if too many labels are displayed.
Negative values are missing: Check that the minimum is below the lowest negative value and that the chart type can display the data as intended.

Also consider whether a logarithmic scale is appropriate. It can help show values spanning several orders of magnitude, but it changes how equal distances on the axis relate to values. A logarithmic axis cannot display zero or negative values. Use it only when that scale suits the data and explain it clearly to readers.

Secondary axes and Excel for the web

A combination chart may use a secondary value axis when two series have very different units or magnitudes, such as revenue and percentage growth. Select the axis on the side of the chart that corresponds to the series you want to scale, then format its bounds separately. If the secondary axis is not present, you may need to assign a series to it through the chart’s series formatting options before you can adjust its range.

Two axes can make a chart easier to read, but they can also imply a relationship that is not meaningful. Their scales may be independently chosen, so lines that visually move together are not necessarily comparable. Label both axes with units, and consider separate charts when the dual scale would confuse the comparison.

In Excel for the web, select the axis and look for its formatting options; the available controls can vary by chart and current web version. If you cannot find the bounds controls or need more detailed formatting, open the workbook in the desktop app. On Mac, the Format Axis pane serves the same purpose, though the pane layout and context-menu wording can differ slightly from Windows.

Frequently Asked Questions

How do I change the vertical axis scale in Excel?
Select the vertical value axis, right-click it, choose Format Axis, then enter the desired minimum and maximum under Axis Options > Bounds. Press Enter after each value.

Why can’t I change the axis minimum in Excel?
You may have selected a category axis, a series, or another chart element. Click the numeric value axis instead. If Bounds still do not appear, check whether the chart type and selected axis support numeric limits.

How do I make an Excel chart axis start at zero?
Open Format Axis for the value axis and enter 0 as the minimum bound. This is often appropriate for bar and column comparisons, but it is not mandatory for every chart; choose a scale that represents the data fairly.

How do I make the Excel chart axis adjust automatically again?
Open Format Axis and clear the fixed minimum or maximum, or use the available reset control beside the bound. Clear both limits if you want Excel to choose the full range automatically.

Can I set different axis ranges on two charts?
Yes. Each chart has its own axis formatting, so you can set different bounds. For charts readers will compare directly, matching the ranges is often clearer and prevents scale differences from distorting the visual comparison.

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.