Change the scale of the value (y) axis

The scale specifies the range of values on an axis, the intervals at which the values occur, the way the axis values are displayed, and the point at which one axis crosses another.

Note: Depending on your chart type, you may not see all of the options listed here in the topic.

Value (Y) axis scale

Minimum

To change the number at which the value (Y) axis starts or ends, type a number. The number should be different from the Maximum number.

Maximum

To change the number at which the value (Y) axis starts or ends, type a number. The number should be different from the Minimum number.

Major Unit

To change the interval of tick marks and chart gridlines, type a number. The number should be different from the Minor unit number.

Minor unit

To change the interval of tick marks and chart gridlines, type a number. The number should be different from the Major unit number.

Category (X) axis Crosses at

To change the point where you want the horizontal (category) axis to cross the vertical (value) axis, enter a number.

Display units

If your chart values consist of large numbers, you can make the axis text shorter and more readable by changing the display unit on the value axis.

Tip: Changing the display unit is useful when the chart values are large numbers that you want to appear shorter and more readable on the axis. For example, you can display chart values that range from 1,000,000 to 50,000,000 as 1 to 50 on the axis and show a label that indicates the units are expressed in millions.

Logarithmic scale

Select the check box to change the value axis to logarithmic.

Values in reverse order

Select the checkbox if you want to reverse the order of categories.

Category (X) axis crosses at maximum value

Select the checkbox if you want to specify that the category (X) axis should cross the value (Y) axis after the highest value on the axis.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×