Formatting a Chart

Excel XP charts let you illustrate your workbook data graphically to see trends. Learn how to format charts in Excel XP in this free lesson.

Formatting the axis labels

In Excel, a graph represents data in two dimensions. The number of items sold in January, for example, is data on two dimensions: number of items and month. The number of items might be plotted on the Y axis, while the month may be plotted on the X axis. The Y axis runs up and down on the graph, while 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 you want to edit:

    Chart X-Axis

    Chart Y-Axis
  • Click Format on the Chart toolbar, or double-click the chart axis.

    Chart Toolbar
  • The Format Axis dialog box contains three 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.
  • The Alignment tabs let you define text orientation.

    Format Axis Dialog Box
  • Click OK 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 axes.