Excel 2010 Bible

Part III: Creating Charts and Graphics

458

If your chart is on a chart sheet, you need to use one of the two methods described next.

FIGURE 19.20

Changing a chart’s data series by dragging the range outline.

Using the Edit Series dialog box

Another way to update the chart to reflect a different data range is to use the Edit Series dialog box.

A quick way to display this dialog box is to right-click the series in the chart and then choose

Select Data from the shortcut menu. Excel displays the Select Source Data dialog box. Select the

data series in the list, and click Edit to display the Edit Series dialog box, shown in Figure 19.21.

You can change the entire data range used by the chart by adjusting the range references in the

Chart Data Range field. Or, select a Series from the list and click Edit to modify the selected series.

FIGURE 19.21

The Edit Series dialog box.