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.

    Screenshot of Excel 2013Selecting cells A1:F6
  2. From the Insert tab, click the desired Chart command. In our example, we'll select Column.
    Screenshot of Excel 2013Clicking the Column chart command
  3. Choose the desired chart type from the drop-down menu.

    Screenshot of Excel 2013Choosing a chart type
  4. The selected chart will be inserted in the worksheet.
    Screenshot of Excel 2013The inserted chart

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.

Screenshot of Excel 2013Clicking the Recommended Charts command