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

Microsoft Graph

Show All

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.

    For Help on an option, click the question mark and then click the option.

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.