Microsoft Office Tutorials and References
In Depth Information
Understanding Series Names
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 the following:
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 scatter 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 comma-separated values (or text in quotation marks) enclosed in braces.
values: (Required) A reference to the range that contains the values for the series. For scatter
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 braces.
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 braces.
Notice that range references in a SERIES formula always include the worksheet name, and the range
references are always absolute references. An absolute reference, as you may know, uses a dollar sign
before the row and column part of the reference. If you edit a SERIES formula and remove the sheet
name or make the cell references relative, Excel will override these changes.
Understanding Series Names
Every chart series has a name, which is displayed in the chart’s legend. If you don’t explicitly provide
a name for a series, it will have a default name, such as Series1, Series2, and so on.
The easiest way to name a series is to do so when you create the chart. Typically, a series name is
contained in a cell adjacent to the series data. For example, if your data is arranged in columns, the
column headers usually contain the series names. If you select the series names along with the chart
data, those names will be applied automatically.
Search JabSto ::




Custom Search