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.
- Click the category axis you want to change.
- On the Format menu, click Selected Axis, and then click the Scale tab.
- 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.