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

To insert a chart:

  1. Select the cells you want to chart, including the column titles and row labels. These cells will be the source data for the chart. In our example, we'll select cells A1:F6.
    Selecting cells
  2. From the Insert tab, click the desired Chart command. In our example, we'll select Column.
    Selecting Column charts from the Insert tab
  3. Choose the desired chart type from the drop-down menu.
    Selecting a chart type
  4. The Selected chart will be inserted into the worksheet.

    Chart inserted into worksheet

If you're not sure which type of chart to use, the Recommended Charts command will suggest several different charts based on the source data.

Selecting recommended charts command