Working with Charts

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

To create 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.
    Selecting cellsSelecting cells
  2. Click the Insert tab.
  3. In the Charts group, select the desired chart category (Column, for example).
    Selecting the Column categorySelecting the Column category
  4. Select the desired chart type from the drop-down menu (Clustered Column, for example).
    Selecting a chart typeSelecting a chart type
  5. The chart will appear in the worksheet.
    The new chartThe new chart