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.

Keeping charts up to date

By default, when you add more data to your spreadsheet, the chart may not include the new data. To fix this, you can adjust the data range. Simply click the chart, and it will highlight the data range in your spreadsheet. You can then click and drag the handle in the lower-right corner to change the data range.

Screenshot of adjusting a data range

If you frequently add more data to your spreadsheet, it may become tedious to update the data range. Luckily, there is an easier way. Simply format your source data as a table, then create a chart based on that table. When you add more data below the table, it will automatically be included in both the table and the chart, keeping everything consistent and up to date.

Watch the video below to learn how to use tables to keep charts up to date.