Microsoft Office Tutorials and References
In Depth Information
Understanding Series Names
Specifies that the series will be plotted first on the chart (the final
argument is 1)
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.
Figure 3-9 shows a chart with three series. The series names, which are stored
in B3:D3, are Main, N. Cnty , and Westside . The SERIES formula for the first data
series is
=SERIES(Sheet1!$B$3,Sheet1!$A$4:$A$8,Sheet1!$B$4:$B$8,1)
Figure 3-9: The series names are picked up from the worksheet.
Search JabSto ::




Custom Search