The fastest way to change your graph's scale
Right-click directly on the axis numbers you want to change — the vertical axis for values, the horizontal axis for categories or time. A menu will appear. Click Format Axis. In the panel that opens on the right side of your screen, go to the Axis Options tab. You can now set the minimum value, maximum value, and the spacing between gridlines. Type in your numbers and the graph updates when ready.
If you do not see the Format Axis option, you clicked on the axis line itself instead of the numbers. Try again, making sure your cursor is directly over the axis labels — the actual numbers running down the left side or across the bottom.
Excel also lets you change the scale by double-clicking the axis. This opens the same Format Axis panel. Either method takes about 10 seconds once you know where to click.
Key Takeaways
- Right-click the axis numbers (not the line) and select Format Axis to open the scale controls.
- Set a custom minimum and maximum value to zoom in on a specific range of your data.
- Change the major unit value to control how far apart the gridlines and labels appear.
- A logarithmic scale compresses large ranges of numbers and is useful when your data spans several orders of magnitude.
Setting minimum and maximum values
The minimum and maximum fields let you control which part of your data the graph actually shows. If your data ranges from 0 to 1,000 but you only care about the 200 to 600 range, set the minimum to 200 and the maximum to 600. The graph will zoom in on that section and make the differences between values much more visible.
Leave these fields blank or set them to Auto if you want Excel to choose the boundaries automatically based on your actual data. This is the default and works well for most graphs. When you add new data to your spreadsheet, the scale adjusts on its own.
If you set a minimum or maximum that falls outside your actual data range, Excel will straightforward show empty space. This is sometimes useful if you want to compare multiple graphs on the same scale, even if one graph does not use the full range.
Adjusting the spacing between gridlines and labels
The Major Unit field controls the distance between gridlines and axis labels. If your axis shows labels at 0, 100, 200, 300, the major unit is 100. Increase this number to show fewer labels and less clutter. Decrease it to show more detail.
For example, if your vertical axis currently shows every 50 units but you want it to show every 10 units, change the major unit from 50 to 10. The gridlines will multiply and the axis will become more granular. This is especially useful when you are zoomed in on a narrow range and need to read exact values.
The Minor Unit field adds smaller gridlines between the major ones. These do not have labels, just faint lines. Most people leave this on Auto, but you can set it manually if you want a specific visual pattern.
Using a logarithmic scale for wide data ranges
A logarithmic scale compresses large numbers so they fit on the same graph as small numbers. If your data includes values like 1, 10, 100, and 1,000, a normal scale will make the smaller values nearly invisible. A logarithmic scale spreads them out evenly.
To switch to a logarithmic scale, open the Format Axis panel, find the Axis Type section, and check the box for Logarithmic scale. The axis will when ready recalculate. This is common in scientific and financial graphs where data spans several orders of magnitude.
Be aware that a logarithmic scale can be misleading if your audience is not familiar with it. The visual distance between 1 and 10 looks the same as the distance between 10 and 100, even though the actual difference is very different. Label your graph clearly if you use this option.
Reversing the axis direction
By default, the vertical axis increases from bottom to top and the horizontal axis increases from left to right. You can reverse either direction by checking the Categories in reverse order box in the Format Axis panel.
This is useful when you are graphing something like depth (where you might want deeper values at the bottom) or when you want to match a specific layout or convention. Most business graphs do not need this, but it is available if your data tells a clearer story in reverse.
Fixing a scale that looks wrong
If your graph suddenly shows a huge empty space above your data, or if the scale jumps unexpectedly when you add a new row, Excel probably set the maximum value too high. Right-click the axis and open Format Axis. Check whether the maximum is set to a specific number or to Auto. If it is a specific number that no longer makes sense, switch it back to Auto.
If you have negative numbers in your data and the axis does not cross at zero, you can force it to by setting the minimum to 0 or a negative value that makes sense for your data. This prevents the graph from looking distorted.
Another common issue: if your axis labels overlap or run at an angle, the problem is usually not the scale but the label formatting. Right-click the axis labels themselves (not the numbers, but the text), select Format Axis Labels, and adjust the angle or font size.
Matching scales across multiple graphs
If you have two graphs side by side and want them to use the same scale so they are visually comparable, set the minimum, maximum, and major unit values to match on both axes. Write down the numbers from the first graph, then explore them to the second.
This is especially important when you are presenting data from different time periods or different categories and want the reader to compare them directly. If one graph goes from 0 to 500 and another goes from 0 to 5,000, the visual impression of growth or decline will be completely different even if the underlying change is the same.
Frequently Asked Questions
How do I change the scale on just the horizontal axis?
Right-click the horizontal axis numbers at the bottom of your graph and select Format Axis. The same Axis Options panel opens. You can set the minimum, maximum, and major unit for the horizontal axis independently from the vertical axis.
Can I make the axis numbers show as percentages or currency?
Yes. In the Format Axis panel, look for the Number tab or section. You can choose a category like Percentage or Currency and set the decimal places. The axis will reformat without changing the underlying scale.
What if I want to start the axis at a number other than zero?
Set the minimum value in the Format Axis panel to whatever number you want. For example, if you set the minimum to 50, the axis will start at 50 instead of 0. This zooms in on your data but can be misleading if not labeled clearly.
How do I undo a scale change I made?
Press Ctrl+Z (or Cmd+Z on Mac) when ready after making the change. If you have made other changes since, right-click the axis again, open Format Axis, and set the minimum and maximum back to Auto.
Why does my scale show weird numbers like 2.5 or 7.5?
Excel is choosing a major unit that divides evenly into your data range. If this looks odd, set the major unit manually to a rounder number like 5 or 10. You can also adjust the minimum and maximum to create a range that divides more neatly.