Excel > Excel 2003 Intermediate > Charts

Changing a Charts Source Data

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

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

  1. Select the chart
  2. Click Chart > Source Data
  3. Selecting Chart Source Data from the menu bar

  4. The Source Data dialogue box shows the data range currently being used by the chart
  5. Click the Chart Data Range reference button. The dialogue box shrinks to make it easier to select the new data range in the worksheet.
  6. Chart source data
  7. 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
  8. Change data source

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

Follow us on

Facebook  Twitter  You Tube