Excel 2000 in a Nutshell

Name

Chart → Add Data

Synopsis

It is not uncommon to decide you want to add data to a chart once it has been created. The easiest method for doing this is to select the Chart → Add Data option. When you select this option the Add Data dialog displays, as shown in Figure 10-22.

Figure 10-22. Select the range of cells that you want to add to your chart

As you can see from the figure, this is really a simple dialog. To add data to your chart you can either type the data range in the Range field, or you can select the Collapse dialog button and highlight the desired range of data.

When you select the OK button, Excel displays the Paste Special dialog, shown in Figure 10-23, so you can indicate how you want to add the new data to the chart.

Figure 10-23. You need to specify how the new data should be added to the chart

Although the Paste Special dialog is rather small, it can also be a little confusing to use. You need to use the options on this dialog to tell Excel how the data should be added to the chart. For example, do you want to add a new data series or should the data values be added to the existing data series.

Add cells as

In the “Add cells as” section, select the appropriate radio button to indicate how you want the new data added to the chart. If you select “New series,” Excel will ...