Click the chart to select it.

Open the Chart menu and select Source Data. The Source Data dialog box opens, as shown in Figure 24.4.

Click the Series tab.

To remove a series, select it from the Series list and click Remove.

To add a new series, click Add. Then either type the appropriate range address in the Name and Values text boxes, or click the Collapse Dialog button and select the ranges you want to use from the worksheet.

Repeat step 5 to add additional series. The sample chart changes to reflect your additions and deletions.

When you finish making changes to your data series, click OK.