Change the spacing of tick marks and labels on the category axis

Each category on the category axis is identified by a label and separated from other categories by tick marks. You can change the intervals at which labels and tick marks appear. For 2-D charts, you can specify where you want the value (y) axis to cross the category (x) axis.

  1. Click the category axis you want to change.

  2. On the Format menu, click Selected Axis, and then click the Scale tab.

  3. Select the options you want.

Tip To have the edges of an area chart meet the edges of the plot area, clear the Value (Y) axis crosses between categories check box.

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.