Microsoft Office Tutorials and References
In Depth Information
Understanding Series Names
Figure 6-8 shows a chart with three series. The series names, which are stored in B3:D3, are Main, N.
County, and Westside. The SERIES formula for the first data series is as follows:
=SERIES(Sheet1!$B$3,Sheet1!$A$4:$A$9,Sheet1!$B$4:$B$9,1)
Figure 6-8: The series names are picked up from the worksheet.
Note that the first argument for this SERIES formula is a reference to the cell that contains the
series name.
Changing a series name
The series name is the text that appears in a chart’s legend. In some cases, you may prefer the chart
to display a name other than the text that’s in the worksheet. To change the name of a series, follow
these steps:
1. Activate the chart.
2. Choose Chart Tools➜Design➜Data➜Select Data to display the Select Data Source
dialog box.
3. In the Select Data Source dialog box, select the series that you want to modify, and click the
Edit button to display the Edit Series dialog box.
4. Type the new name in the Series Name box.
Normally, the Series Name box contains a cell reference. But you can override this and enter any text.
If you go back to a series that you’ve already renamed, you’ll find that Excel has
converted your text into a formula — an equal sign, followed by the text you entered (the
new series name), within quotation marks.
Note
Search JabSto ::




Custom Search