Microsoft Office Tutorials and References
In Depth Information
Understanding Series Names
Figure 6-9 shows the previous chart, after changing the series names. The first argument in each of
the SERIES formulas no longer displays a cell reference. It now contains the literal text. For example,
the SERIES formula for the first series is as follows:
=SERIES(“Branch 1”,’Figure 6-9’!$A$4:$A$9,’Figure 6-9’!$B$4:$B$9,1)
Figure 6-9: The series names have been changed; the new names are shown in the legend.
You can also change the name of a series by editing the SERIES formula directly. Select the series,
click inside the Formula bar, and replace the first argument with your text (make sure that the text is
enclosed within quotation marks).
Deleting a series name
To delete a series name, use the Edit Series dialog box as described previously. Highlight the range
reference (or text) in the Series Name box and press Delete.
Alternatively, you can edit the SERIES formula and remove the first argument. Here’s an example of a
SERIES formula for a series with no specified name (it will use the default name):
=SERIES(,Sheet2!$A$2:$A$6,Sheet2!$B$2:$B$6,1)
When you remove the first argument in a SERIES formula, make sure that you do not
delete the comma that follows the first argument. The comma is required as a
placeholder to indicate the missing argument.
Note
To create a series with no name, use a set of empty quotation marks for the first argument in the
SERIES formula. A series with no name still appears in the chart’s legend, but no text is displayed.
Search JabSto ::




Custom Search