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 chart legend

The chart legend displays useful information about the chart. Like a roadmap, the legend identifies what different colors or objects represent in the chart. The chart legend—like the chart title and category axis labels—can be formatted to your liking.

To format the chart legend:

  • Press the show/hide legend button on the Chart toolbar to turn on the legend display. (This button acts like a toggle by turning the display on or off.)

    The Legend Button on the Chart Toolbar
  • Click to select the chart legend.
  • Click Format on the Chart toolbar, or double-click the chart legend.

    Chart Toolbar
  • The Format Legend 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 fill colors.
  • The Font tab lets you define font, font style, size, and color.
  • The Placement tab lets you define the location where the legend will appear on the chart.

    Format Legend Dialog Box
  • Click OK to accept the chart legend format changes.

The only way to change the actual text that appears in the chart legend is to change the source data in the worksheet.