Excel Chart Axis Range: Set Minimum and Maximum

To set an Excel chart axis range in Microsoft 365 for Windows, right-click the value axis, choose Format Axis, then under Axis Options enter values in Bounds for Minimum and Maximum. Excel normally chooses these limits automatically; entering your own values fixes the visible scale without changing the worksheet data.

What an axis range controls

An axis range is the span of values shown along an axis, from its lower bound to its upper bound. On a column chart, for example, you might change the vertical axis from 0–120 to 0–100 so that the scale ends at a meaningful target. On a scatter chart, you can set ranges for both the horizontal and vertical value axes.

Changing the range changes the chart’s framing, not the underlying values. It does not remove rows, alter formulas, or filter data. A point outside the chosen bounds may no longer be visible in the plot area, but its source value remains in the worksheet. This distinction matters if the chart is used for reporting: a fixed range can make comparisons easier, but it can also hide values that fall outside the displayed span.

Excel’s automatic bounds are often a sensible starting point. It examines the plotted data and selects limits and intervals intended to make the chart readable. A manual range is useful when you need a consistent scale across charts, want to focus on a particular interval, or need the axis to begin or end at a specific threshold.

Set minimum and maximum on a value axis

Select the chart, then click the axis whose scale you want to change. For a column chart, this is usually the vertical axis with numbers.
Right-click the selected axis and choose Format Axis. Excel opens the Format Axis pane.
In the pane, select Axis Options if it is not already selected. Look for the Bounds section.
Enter the desired number in Minimum, Maximum, or both. Press Enter after typing each value so Excel applies it.
Review the chart and adjust the bounds or units if the labels or data are difficult to read.

For example, suppose monthly counts range from 42 to 91 and the chart should emphasize variation above 40. Setting the vertical minimum to 40 and maximum to 100 gives the data room above the highest value while focusing the view. The range does not mean the lowest observation is 40; it is simply where the displayed scale begins.

To return a bound to automatic scaling, use the reset control beside that bound if your Excel version shows one. In versions where it does not, use the field’s automatic option or remove the custom value as offered by the pane. The exact appearance can vary slightly between Microsoft 365 updates.

Choose a useful range and interval

Choose bounds that support the question the chart is meant to answer. A chart comparing totals against a target may benefit from an axis that starts at zero, while a line chart examining small temperature changes may need a closer view of a narrow range. Make the choice clear to readers: a truncated scale can make modest differences look much larger than they are.

For column and bar charts: Starting the value axis at zero usually makes bar lengths proportionate to their values. If you start above zero, disclose that choice or make the break obvious; otherwise, viewers may overestimate differences.
For line charts: A nonzero minimum can help show movement within a tight range, such as values fluctuating between 96 and 101. Keep the scale visible and avoid implying that a small change represents a dramatic change in the overall quantity.
For comparisons between charts: Use matching minimum and maximum bounds when readers need to compare magnitudes across separate charts. Automatic scaling can give each chart a different range, making equal-sized visual changes appear unequal.
For a target or threshold: Set bounds that include the target and the relevant data, rather than clipping observations simply to make the plot look tidy.

The Major unit controls the spacing between the main axis labels or tick marks. If a chart runs from 0 to 100, a major unit of 20 produces labels at intervals of 20; a unit of 10 gives more detail. Minor unit, when available, controls smaller subdivisions between major marks. Excel may select these automatically, and the available options depend on the axis and chart type.

A practical approach is to choose simple bounds first, then select an interval that gives readers a quick sense of scale without crowding the labels. Values such as 0, 50, and 100 are usually easier to scan than an awkward sequence such as 3, 37, and 71, unless those limits have a specific analytical meaning.

Value axes, category axes, and chart types

Not every chart axis accepts a numeric minimum and maximum. A value axis represents a continuous numerical scale. It commonly appears vertically in column, bar, and line charts, and on both axes of an XY scatter chart. The Bounds controls are associated with value axes.

A category axis instead shows labels such as product names, months, or regions. On a typical line chart, the horizontal axis is a category axis even if its labels look like dates. You generally cannot type numeric minimum and maximum bounds for a list of categories in the same way. You can change settings such as label position, category order, and the interval at which labels appear.

Date axes are a special case. If Excel recognizes the horizontal labels as dates and the chart uses a date axis, the axis can be scaled by date rather than treating every label as an unrelated category. In Format Axis, check the axis type options; depending on the chart and data, you may be able to choose a date axis and set date bounds or units. If the dates are stored as text, Excel may not offer the date-axis behavior you expect. Converting the source values to real Excel dates can resolve that issue.

For a scatter chart, both horizontal and vertical axes are numerical. Select each axis in turn and set its own bounds. This is useful when plotting, for example, delivery time against order size and you want to focus on a defined range for both variables. Do not assume that setting the vertical range also changes the horizontal one.

Secondary axes and other scale settings

A chart with two series measured in very different units may use a secondary value axis. For instance, a chart could show sales as columns and a percentage as a line. If the percentage series is assigned to a secondary axis, select that axis itself before changing its bounds. Formatting the primary axis will not set the scale for the secondary one.

Secondary axes can make a combined chart readable, but they also require care. Two scales can make the series appear to move together even when their underlying values have different units and ranges. Label each axis clearly, use appropriate number formats, and explain what each scale measures.

Other controls in the Format Axis pane affect how the scale appears. Axis crosses determines where the horizontal and vertical axes meet. Values in reverse order can flip the direction of a value axis, and number-format settings control whether labels appear as numbers, percentages, dates, or currency. These settings do not change the source values, but they can change how readers interpret the chart.

A logarithmic scale is another option for some value axes, especially when values span several orders of magnitude. It spaces values by ratios rather than equal numerical differences. Logarithmic axes cannot display zero or negative values, so the setting is unsuitable when the data includes them. Use it only when the scale helps explain the data and label it clearly; it is not simply a way to make a chart look more balanced.

Why the axis range may not behave as expected

Bounds are missing: You may have selected a category axis rather than a value axis. Try the numbered vertical axis, or, for a scatter chart, select the other numerical axis. Some chart types expose different controls.
The axis keeps changing: If bounds are automatic, Excel can recalculate them when the data changes. Enter fixed values to hold the range steady. Remember that new values outside those limits may be clipped from view.
The chart does not show the full dataset: Check whether the minimum or maximum excludes some observations. Also check filters, hidden rows or columns, and the chart’s selected data range.
Dates are treated as categories: Excel may be reading the source labels as text. Confirm that the cells contain valid date values and review the axis type options.
A percentage axis looks wrong: Excel stores percentages as decimal values, so 100% is represented as 1. If setting bounds manually, use values that match the underlying scale, then apply a percentage number format if needed.
A bound seems to snap or change: Check that the minimum is lower than the maximum and that the values are compatible with the axis type. For a logarithmic axis, use positive bounds.

If you are working in Excel for Mac, select or Control-click the axis and choose Format Axis; the formatting pane provides the corresponding axis options, although its layout can differ from Windows. Excel for the web supports common chart editing, but some detailed formatting controls may differ or be unavailable. If you cannot find a bounds setting there, open the workbook in the desktop app and change the axis in its Format Axis pane.

Fixed versus automatic scaling

Automatic scaling is convenient for charts that should adapt as the source data grows or changes. It is often the right choice for exploratory work and dashboards where the latest data matters more than maintaining a fixed visual scale. Its drawback is that the chart’s framing may shift between updates, so a value can appear to change dramatically even when only the axis limits changed.

Fixed bounds improve consistency. They are useful in recurring monthly reports, side-by-side comparisons, and charts where a threshold must remain visible. The trade-off is that fixed limits do not adapt to new extremes. If a later value falls outside the range, it may not appear in the plot area. Review fixed limits when the dataset changes, particularly if readers could mistake a clipped point for missing data.

A helpful compromise is to fix bounds when comparability is essential and leave them automatic when complete visibility of changing data is the priority. In either case, retain readable axis labels and consider a note when the scale does not start at zero or when observations are intentionally outside the displayed range.

Frequently Asked Questions

How do I make the vertical axis start at zero in Excel?

Select the chart’s vertical value axis, choose Format Axis, and enter 0 in Minimum under Axis Options and Bounds. This changes the displayed scale, not the data. If the chart is a bar or column chart, a zero baseline is usually helpful for fair visual comparison.

Can I set the horizontal axis minimum and maximum?

Yes, if the horizontal axis is a value axis, as it is in an XY scatter chart. Select that axis and set its bounds in the Format Axis pane. A standard line chart usually has a category axis horizontally, so it may offer category-order and label controls instead of numeric bounds.

How do I make two Excel charts use the same scale?

Set the same minimum and maximum on the corresponding value axes in both charts, and match the major units if the label spacing should also agree. Check that the charts measure the same kind of quantity and use the same units; identical bounds are not meaningful when one chart shows dollars and the other shows percentages.

Does changing the axis range delete or change data?

No. Axis bounds affect only the chart’s visible scale. The worksheet values and formulas remain unchanged, although data beyond fixed bounds may be outside the visible plot area. Widen the bounds if you need to show those observations.

Why can’t I type a minimum for my chart axis?

You may have selected a category axis, whose labels are items rather than a continuous numerical scale. Select a value axis instead. If the axis is a date axis or the chart is in Excel for the web, available controls can depend on how the data is stored and which editing features are supported there.

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.