Change the axis range by right-clicking the axis and selecting Format Axis
To change how far an axis stretches on your chart, right-click directly on the numbers along that axis — not on the chart itself, but on the axis line. A menu will appear. Click Format Axis. On the right side of your screen, a panel opens. Under Axis Options, you will see fields for Minimum and Maximum. Type the numbers you want, and the axis will redraw to fit them.
This works the same way for the vertical axis (the one that usually shows values) and the horizontal axis (the one that usually shows categories or time). If you want the axis to start at zero instead of at the lowest value in your data, set the Minimum to 0. If you want more space above your highest data point, increase the Maximum.
Excel normally sets these limits for you based on your data. Changing them manually lets you zoom in on a small range, zoom out to show more context, or force the axis to start and end at round numbers that make the chart easier to read.
Key Takeaways
- Right-click the axis numbers themselves, not the chart background, and select Format Axis from the menu.
- In the Axis Options panel, enter new Minimum and Maximum values to set where the axis begins and ends.
- Setting Minimum to 0 forces the axis to include zero, which can make small differences look smaller.
- Changing the range does not change your data — it only changes how the chart displays it.
Where to find the Format Axis option
The axis is the line with numbers running along the edge of your chart. On most charts, the vertical axis is on the left (showing values like 0, 10, 20, 30) and the horizontal axis is at the bottom (showing dates, categories, or values). Click directly on one of those numbers or on the line itself. Do not click on the chart title, the legend, or the bars or lines inside the chart — click only on the axis.
When you right-click the axis, a small menu appears. Look for Format Axis — it is usually near the top of the menu. Click it. A panel will open on the right side of your screen (in newer versions of Excel) or a dialog box will appear (in older versions). Either way, you are now in the place where you can change the axis range.
Setting minimum and maximum values
Once the Format Axis panel is open, look for the section labeled Axis Options. You will see checkboxes and text fields for Minimum and Maximum. By default, both are set to Auto, which means Excel picks the range based on your data.
To set your own range, uncheck the Auto checkbox next to Minimum, then type a number in the field below it. Do the same for Maximum. For example, if your data ranges from 5 to 95 but you want the axis to show 0 to 100, enter 0 for Minimum and 100 for Maximum. Press Enter or click outside the field, and the chart will redraw.
If you want only the Minimum to change (and let Excel pick the Maximum), uncheck only the Minimum checkbox. The same applies to Maximum. You do not have to change both at once.
Why you might want to change the axis range
The most common reason is to make a small change look bigger or smaller. If your sales data goes from $98,000 to $102,000 over a year, Excel will zoom in and make that 4 percent change look dramatic. If you change the Minimum to 0 and the Maximum to 150000, the same data will look flat — which is more honest. Conversely, if you want to highlight a small trend, zooming in (setting Minimum to 95000 and Maximum to 105000) makes the change visible.
Another reason is readability. If your axis shows 0, 33.33, 66.67, 100, it looks messy. Setting Minimum to 0 and Maximum to 100 might make Excel use 0, 25, 50, 75, 100 instead — cleaner numbers that are easier to read in a presentation or report.
You might also change the range to compare two charts side by side. If one chart shows 0 to 50 and another shows 0 to 200, the first one looks like it has bigger swings even if the percentage change is the same. Setting both to the same range makes the comparison fair.
Changing the number of intervals on the axis
While you are in the Format Axis panel, you can also control how many tick marks and labels appear on the axis. Look for Major Units or Minor Units (the names vary slightly by Excel version). Major Units are the big labeled marks; Minor Units are the smaller unlabeled ones in between.
If your axis shows too many numbers and looks crowded, increase the Major Units value. If it shows too few and looks sparse, decrease it. For example, if your axis goes from 0 to 1000 and shows marks at 0, 100, 200, 300, and so on, the Major Units value is 100. Change it to 250 and you will see marks at 0, 250, 500, 750, 1000 instead.
Like Minimum and Maximum, Major Units and Minor Units are usually set to Auto. You can uncheck Auto and type your own value to take control.
Resetting the axis to automatic
If you change the axis range and then want to go back to letting Excel choose, open the Format Axis panel again and check the Auto checkbox next to Minimum and Maximum. The axis will return to its original range based on your data.
There is no undo button for axis changes, but checking Auto is just as fast. You can also delete the chart and recreate it, though that is rarely necessary.
Frequently Asked Questions
Can I set different ranges for two axes on the same chart?
Yes. Right-click the first axis, change its range, then right-click the second axis and change its range separately. Each axis remembers its own settings. This is useful when you are plotting two different measurements on the same chart — for example, temperature in Celsius on the left axis and humidity percentage on the right axis.
What if I set a minimum that is higher than my data?
Your data will still appear on the chart, but it will be pushed to the bottom or left edge. For example, if your data is 50 and you set Minimum to 100, the bar or line will sit at the very bottom of the chart area. This is usually a mistake, but Excel allows it.
Does changing the axis range change the numbers in my spreadsheet?
No. Changing the axis range only changes how the chart looks. Your data in the cells stays exactly the same. The chart is just a picture of your data, and zooming in or out on that picture does not affect the original numbers.
How do I change the axis range on a chart in an older version of Excel?
Right-click the axis and select Format Axis. Instead of a panel on the right, a dialog box will open. Look for the Scale tab at the top. The Minimum and Maximum fields are there. Enter your values and click OK.
Can I set the axis to show negative numbers?
Yes. Set Minimum to a negative number, like -50, and Maximum to a positive number, like 50. The axis will include zero in the middle and show both negative and positive values. This is common in charts that show profit and loss or temperature above and below freezing.