Creating a Chart

Excel XP charts let you illustrate your workbook data graphically to see trends. Also use charts in Excel XP to visualize comparisons.

Challenge!

  • Type the following information on the worksheet:

    In cell A2, type January
    In cell A3, type February
    In cell A4, type March
    In cell B1, type Bill
    In cell B2, type 3542
    In cell B3, type 7184
    In cell B4, type 6531
    In cell C1, type Mary
    In cell C2, type 2943
    In cell C3, type 6542
    In cell C4, type 7137
    In cell D1, type Bob
    In cell D2, type 3403
    In cell D3, type 7314
    In cell D4, type 6942

  • Create an embedded line chart showing the numbers on the Y axis and the months on the X axis.
  • Change the embedded line chart to an area chart.
  • Convert the embedded area chart to a chart sheet.