Microsoft Office Tutorials and References
In Depth Information
Editing the SERIES formula to change series data
SERIES Formula Syntax
A SERIES formula has the following syntax:
=SERIES(series_name, category_labels, values, order, sizes)
The arguments you can use in the SERIES formula include:
series_name : (Optional) A reference to the cell that contains the series name
used in the legend. If the chart has only one series, the name argument is
used as the title. This argument can also consist of text, in quotation marks.
If omitted, Excel creates a default series name (for example, Series 1).
category_labels : (Optional) A reference to the range that contains the labels for
the category axis. If omitted, Excel uses consecutive integers beginning with 1.
For XY charts, this argument specifies the X values. A noncontiguous range
reference is also valid (the ranges addresses are separated by a comma and
enclosed in parentheses. The argument may also consist of an array of
commaseparated values (or text in quotation marks) enclosed in curly brackets.
values : (Required) A reference to the range that contains the values for the
series. For XY charts, this argument specifies the Y values. A noncontiguous
range reference is also valid (the ranges addresses are separated by a comma
and enclosed in parentheses. The argument may also consist of an array of
comma-separated values enclosed in curly brackets.
order : (Required) An integer that specifies the plotting order of the series.
This argument is relevant only if the chart has more than one series. Using a
reference to a cell is not allowed.
sizes : (Only for bubble charts) A reference to the range that contains the
values for the size of the bubbles in a bubble chart. A noncontiguous range
reference is also valid (the ranges addresses are separated by a comma and
enclosed in parentheses. The argument may also consist of an array of values
enclosed in brackets.
Following is an example of a SERIES formula.
=SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$7,Sheet1!$B$2:$B$7,1)
This SERIES formula:
Specifies that cell B1 (on Sheet1) contains the series name
Specifies that the category labels are in A2:A7 on Sheet1
Specifies that the data values are in B2:B7, also on Sheet1
Search JabSto ::




Custom Search