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

Each category on the category axis (axis: A line bordering the chart plot area used as a frame of reference for measurement. The y axis is usually the vertical axis and contains data. The x-axis is usually the horizontal axis and contains categories.) is identified by a label and separated from other categories by tick marks (tick marks and tick-mark labels: Tick marks are small lines of measurement, similar to divisions on a ruler, that intersect an axis. Tick-mark labels identify the categories, values, or series in the chart.). 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 (plot area: In a 2-D chart, the area bounded by the axes, including all data series. In a 3-D chart, the area bounded by the axes, including the data series, category names, tick-mark labels, and axis titles.), clear the Value (Y) axis crosses between categories check box.