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.
Search JabSto ::




Custom Search