Part III: Creating Charts and Other Visualizations
In some cases, you’ll also need to adjust the range that contains the category labels. The
labels are also outlined, and you can drag the outline to expand or contract the range of
labels used in the chart.
If your chart is on a chart sheet, you need to use one of the two methods described next.
These methods also work with embedded charts.
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. The Select Source Data dialog box
appears. Select the data series in the list, and click Edit to display the Edit Series dialog
box, as shown in Figure 21.21.
FIGURE 21.21
The Edit Series dialog box
You can change the entire data range used by the chart by adjusting the range references
in the Chart Data Range field. Or, you can select a series from the list and click Edit to
modify the selected series.
Editing the Series formula
Every data series in a chart has an associated SERIES formula, which appears in the
Formula bar when you select a data series in a chart. If you understand the way a SERIES
formula is constructed, you can edit the range references in the SERIES formula directly to
change the data used by the chart.
The SERIES formula is not a real formula. In other words, you can’t use it in a cell, and you can’t use worksheet
functions within the SERIES formula. You can, however, edit the arguments in the SERIES formula.
A SERIES formula has the following syntax:
=SERIES(series_name, category_labels, values, order, sizes)
