Ten Minute Guide to Excel 97

Changing the Category Axis

You can customize the category axis (the x-axis) as well. For example, you can increase the space between columns (or bars, and so on.) To learn how, follow these steps:

1. Choose Category Axis from the Chart Objects drop-down list on the Chart toolbar.

2. Click the Format Object button.

3. Click the Scale tab, and you'll see the options shown in Figure 24.2.

   Figure 24.2. You can customize the Category axis as well.

   

4. You can change the point at which the value axis (y-axis) crosses the category axis (x-axis) by entering a different ...