Working with Charts

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

To change chart style:

  1. Select the Design tab.
  2. Click the More drop-down arrow in the Chart Styles group to see all of the available styles.
    The Change Chart Type commandViewing all of the Chart Styles
  3. Select the desired style.
    Selecting a chart styleSelecting a chart style
  4. The chart will update to reflect the new style.
The updated chartThe updated chart

To move the chart to a different worksheet:

  1. Select the Design tab.
  2. Click the Move Chart command. A dialog box appears. The current location of the chart is selected.
    The Move Chart commandThe Move Chart command
  3. Select the desired location for the chart (choose an existing worksheet, or select New Sheet and name it).
    Selecting a different worksheet for the chartSelecting a different worksheet for the chart
  4. Click OK. The chart will appear in the new location.