Change the scale of the category (X) and value (Y) axis

Modify the scale options for the category (X) axis and value (y) axis.

Value (Y) axis crosses at category number

To change the point where you want the value (Y) axis to cross the category (X) axis, enter the appropriate category number.

Number of categories between tick-mark labels

The number that you type determines how many categories are displayed between the tick mark labels.

Number of categories between tick marks

The number that you type determines how many categories are displayed between the tick marks.

Value (Y) axis crosses between categories

This option (when it appears as checked) indicates that the value (Y) axis crosses between categories, and not just a single category.

Categories in reverse order

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

Value (Y) axis crosses at maximum category

Select the checkbox if you want to specify that the value (Y) axis should cross the category (X) axis after the last category on the X-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.

×