As you fine-tune your chart, you may discover that you originally selected the wrong cells for a particular data series. Or you may want to add an additional series to a chart. Both options are easy to complete using the Source Data dialog box. Here's how:
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.