Excel > Excel 2007 Intermediate > Charts

Change a Charts Source Data

A chart is linked to its underlying data source, meaning that should the data change, the chart is automatically updated.

Online Excel School

Once created though, you may need to change the charts data source.

  1. Select the chart
  2. Click the Design tab under Chart Tools on the Ribbon
  3. Click Select Data from the Data group
  4. Data group on the Ribbon

  5. The Select Data Source dialogue box shows the data range currently being used including the series and category axis labels.
  6. Click the Chart Data Range reference button. The dialogue box shrinks to make it easier to select the new data range in the worksheet.
  7. Change the chart source data

  1. Select the new cell range to use as the data source and click the Chart Data Range reference button to return the dialogue box to its normal size

Selecting a new chart data source

  1. Click Ok and the chart will update to reflect the new data source

Follow us on

Facebook  Twitter  You Tube