Microsoft Office Tutorials and References

In Depth Information

**Editing the SERIES formula to change series data**

The Source Data dialog box will vary somewhat, depending on the chart

type. The Source Data dialog box for a bubble chart, for example, has four

range selector controls: Name, X Values, Y Values, and Sizes (for the range

that contains the size data for the bubbles).

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. The formula bar, in Figure 3-8,

shows one of two SERIES formulas for a chart that displays two data series.

Although a SERIES formula is displayed in the formula bar, it is not 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 learn about the various arguments

for a SERIES formula.

Figure 3-8: The SERIES formula for the selected data series appears in the

formula bar.

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.