Altering the Source Data Range

Right-click the plot area of your chart and select Source Data from the shortcut menu.

Click directly in your worksheet and select the new data range. The Data range area in the Source Data dialog box automatically updates.

Click OK.

The updated data range appears in your chart.