Change the cell range the chart is based on
- Click the chart you want to change.
- On the Chart menu, click Source Data, and then click the Data Range tab.
- Make sure the entire reference in the Data range box is selected.
- On the worksheet, select the cells that contain the data you want to appear in the chart.
If you want the column and row labels to appear in the chart, include the cells that contain them in the selection.