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.

Challenge!

  • Type the following information in the worksheet:

    In cell A2, type October
    In cell A3, type November
    In cell A4, type December
    In cell B1, type Clothes
    In cell B2, type 124
    In cell B3, type 78
    In cell B4, type 97
    In cell C1, type Movies
    In cell C2, type 12
    In cell C3, type 18
    In cell C4, type 20
    In cell D1, type Books
    In cell D2, type 45
    In cell D3, type 78
    In cell D4, type 15

  • Create an embedded bar chart that plots October, November, and December on the Y axis. The legend will include Clothes, Movies, and Books.
  • Assign a chart name in the Titles tab of the Chart Options dialog box.
  • Format the chart name by assigning it a Verdana font, bold font style, a size of 20, and the color red.
  • Format the chart legend so its placement is at the top of the screen.
  • Format the X axis so the text orientation is 45 degrees for each label in the data series.
  • Select a data series color and change it to another color.