Microsoft Office Tutorials and References

In Depth Information

**Deleting a Chart Series**

Editing the SERIES formula to change series data

Every chart series has its own SERIES formula. When you select a data series in a chart, its SERIES

formula appears in the Formula bar. In Figure 6-7, for example, you can see one of two SERIES formulas

in the Formula bar for a chart that displays two data series.

Figure 6-7:
The SERIES formula for the selected data series appears in the Formula bar.

Although a SERIES formula is displayed in the Formula bar, it isn’t a “real” formula. In other words, you

can’t put this formula into a cell, and you can’t use worksheet functions within the SERIES formula. You

can, however, edit the arguments in the SERIES formula to change the ranges used by the series. To edit

the SERIES formula, just click in the Formula bar and use standard editing techniques. Refer to the

sidebar, “SERIES formula syntax,” to find out about the various arguments for a SERIES formula.

When you modify a series data range using either of the techniques discussed

previously in this section, the SERIES formula is also modified. In fact, those techniques are

simply easy ways of editing the SERIES formula.

Note

Following is an example of a SERIES formula:

=SERIES(Sheet4!$D$2,Sheet4!$B$3:$B$8,Sheet4!$D$3:$D$8,2)

This SERIES formula does the following:

➤ Specifies that cell D2 (on Sheet4) contains the series name.

➤ Specifies that the category labels are in B3:B8 on Sheet4.

➤ Specifies that the data values are in D3:D8, also on Sheet4.

➤ Specifies that the series will be plotted second on the chart (the final argument is 2).