Change the axis scale by right-clicking the axis and selecting Format Axis
To change how your graph displays numbers on the vertical or horizontal axis, right-click directly on the axis itself—the line with the numbers running up the side or across the bottom. A menu will appear. Click Format Axis. A panel opens on the right side of your screen with options to set the minimum value, maximum value, and the spacing between numbers. Adjust these fields to show the range and intervals you want, then close the panel. The graph redraws when ready.
The most common reason to change a scale is to zoom in on data that clusters in a narrow range, or to zoom out when one large value makes smaller values hard to see. For example, if your sales data ranges from $48,000 to $52,000, the default scale might run from $0 to $60,000, making the variation invisible. Changing the minimum to $45,000 and the maximum to $55,000 makes the differences clear.
Key Takeaways
- Right-click the axis (the numbered line on the side or bottom of the graph) and select Format Axis to open the scaling controls.
- Set the Minimum and Maximum values to control the range the axis displays, and set Major Units to control the spacing between numbers.
- Changing the scale does not change your data—it only changes how the graph displays it visually.
- You can format the vertical axis (Y-axis) and horizontal axis (X-axis) separately, and each graph can have its own scale settings.
Where to find the axis scaling options in the Format Axis panel
When you right-click the axis and select Format Axis, a panel labeled Format Axis appears on the right side of Excel. Look for the section called Axis Options. Under this heading, you will see fields for Minimum, Maximum, and Major Units.
The Minimum field sets the lowest value shown on the axis. The Maximum field sets the highest value. Major Units controls the gap between the numbered tick marks—for example, if you set Major Units to 10, the axis will show numbers 0, 10, 20, 30, and so on. Leave any field blank or set it to Auto if you want Excel to calculate that value based on your data.
Setting a custom minimum and maximum to zoom in or out
To zoom in on a narrow range of data, type a higher number in the Minimum field and a lower number in the Maximum field. For instance, if your data runs from 100 to 150 but you want to see the variation clearly, set Minimum to 100 and Maximum to 150. The graph will now fill the entire vertical space with just that range, making small differences visible.
To zoom out and show a wider context, set Minimum to a lower number and Maximum to a higher number than your actual data range. This is useful when you want to show that your values are small compared to a larger possible range, or when you are comparing multiple graphs and want them all to use the same scale for fairness.
Adjusting the spacing between numbers with Major Units
The Major Units field controls how often Excel places a number label on the axis. If your axis runs from 0 to 1000 and Major Units is set to 100, you will see labels at 0, 100, 200, 300, and so on. If you change Major Units to 250, the labels jump to 0, 250, 500, 750, 1000.
Smaller Major Units values create more labels and tick marks, which can make the graph crowded. Larger values create fewer labels, which can make it harder to read exact values. Choose a Major Units value that makes the axis straightforward to read without clutter. Excel's default is usually reasonable, but you can adjust it if the labels overlap or if you need finer gradations.
Changing the scale on the horizontal axis instead of the vertical axis
The same process works for the horizontal axis (the axis running left to right across the bottom). Right-click on the horizontal axis itself, select Format Axis, and adjust Minimum, Maximum, and Major Units the same way. This is less common than changing the vertical axis, but it is useful when you have many categories or time periods and want to show only a subset, or when you want to control the spacing of category labels.
You can format both axes independently. For example, you might zoom in on the vertical axis to show detail in your values while keeping the horizontal axis at its default scale to show all time periods or categories.
Reverting to automatic scaling if you want Excel to choose the scale
If you have set custom values and want Excel to go back to choosing the scale automatically, open the Format Axis panel again. In the Minimum, Maximum, and Major Units fields, select the text and delete it, or click the field and choose Auto from any dropdown menu if one appears. Excel will recalculate the best scale based on your data.
Automatic scaling is the default and works well for most graphs. You only need to change it when the automatic scale hides important detail or when you are comparing multiple graphs and need them to use the same scale.
Why the scale matters: how it changes what the graph shows
The scale does not change your actual data—it only changes how the graph displays it. Two graphs with the same data but different scales can look very different. A steep line might flatten out if you zoom out, or a flat line might look dramatic if you zoom in. This is why it is important to choose a scale that honestly represents your data without exaggerating or downplaying the variation.
When you share a graph with others, be aware that your choice of scale influences how they interpret the data. If you zoom in on a small range, readers might think the change is larger than it actually is. If you zoom out too far, they might miss important variation. A good practice is to use a scale that shows the full context of your data unless you have a clear reason to focus on a narrower range.
Frequently Asked Questions
Can I set different scales for two data series on the same graph?
Yes, if you have two data series with very different ranges (for example, one ranging from 0 to 10 and another from 0 to 1000), you can create a secondary axis for one series. Right-click the series you want to move, select Format Data Series, and choose Secondary Axis. Then format each axis independently. This is advanced and can be confusing to read, so use it only when the ranges are truly incompatible.
What if I want the axis to start at zero instead of at the data minimum?
Set the Minimum field to 0 in the Format Axis panel. This is common for bar charts and column charts, where starting at zero is considered more honest. Line charts and scatter plots often start at the data minimum instead. Excel's default depends on the chart type, but you can override it by setting Minimum manually.
How do I make the axis show percentages or currency instead of plain numbers?
Right-click the axis, select Format Axis, and look for a section called Number. Click the Category dropdown and choose Currency, Percentage, or another format. The axis will display numbers in that format without changing your actual data. This is purely visual and makes the graph easier to read.
Can I change the scale after I have already created the graph?
Yes. Click the graph to select it, then right-click the axis you want to change. The Format Axis panel opens, and you can adjust the scale at any time. Your data stays the same; only the display changes.