How to update an existing chart, Part 1: Data Range

If you have an existing chart and you want to change the source data of that chart, by expanding it for example, then instead of recreating the chart you can just update it as follows:

1. Click on the chart.

2. On the top menu Click Chart, then click Source Data.

3. The Source Data window will open.

4. Click on the Data Range tab.

5. In the Data Range textbox (below the chart) highlight the current data range.

6. Go to your worksheet and select your data range.

7. The new data range will be reflected on the textbox. And the chart will be updated accordingly.

Applies to: Excel 2003

Related posts:

1. A primer on chart terminology
2. How to link to values in another worksheet / workbook