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


  1. Open our practice workbook.
  2. Click the Challenge tab in the bottom-left of the workbook.
  3. Select cells A1:E6 and insert a 2D Clustered Column chart.
  4. Change the chart title to September to December Sales.
  5. Use the Switch Row/Column command. The columns should now be grouped by month, with a different color for each salesperson.
  6. Move the chart to a new sheet.
  7. Change the chart type to line with markers.
  8. Use the Quick Layout command to change the layout of the chart.
  9. When you're finished, your workbook should look something like this:

    Charts Challenge