Excel XP

Formatting the Axis Labels

We've previously made reference to a Y-axis and an X-axis in Excel. In Excel, a graph represents a data in two dimensions. The number of items sold in January is data on two dimensions: number of items and month. The number of items might be plotted on one axis, Y-axis, while the month may be plotted on the X-axis. The Y-axis runs up-and-down on the graph. The X-axis runs left-to-right.

When formatting the Axis labels in your chart, you can adjust the numbers on the Scale of the chart as well as change font, color, and style.

To Format an Axis:

• Click anywhere in the Axis label that you want to edit:
  
  
  
  
  
  
• Click the Format Button on the Chart Toolbar (or double click the chart axis).
  
  
  
  
• The Format Axis dialog box contains five different tabs-Patterns, Font and Alignment-that can be used to format the Chart Title.
• The Patterns tab lets you define borders and tick marks.
• The Scale tab lets you define numeric intervals on the Value (Y) Axis scale.
• The Font tab lets you define Font, Font Style, Size and Color.
• The Number tab lets you define the format of numbers displayed in the Axis (see lesson 12).
• The Alignment tabs let you define text orientation (see lesson 11).
  
  
  
  
• Click the OK button to accept the Axis format changes.

You can also use the angle axis buttons on the chart toolbar to change the angle of the value and category axis.