Excel charts let you illustrate your workbook data graphically to see trends. Also use charts in Excel to visualize comparisons.
To insert a chart:
- 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.
- From the Insert tab, click the desired Chart command. In our example, we'll select Column.
- Choose the desired chart type from the drop-down menu.
- The Selected chart will be inserted into the 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.