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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×