Microsoft Office Tutorials and References
In Depth Information
Chapter 17: Charting Techniques
Figure 17-1: The Formula bar displays the SERIES formula for the selected data series in a chart.
A SERIES formula is not a “real” formula. In other words, you can’t use it in a cell, and
you can’t use worksheet functions within the SERIES formula. You can, however, edit
the arguments in the SERIES formula to change the data that’s used by the chart. You
can also drag the outlines in the worksheet to change the chart’s data.
A SERIES formula has the following syntax:
=SERIES(series_name, category_labels, values, order, sizes)
The arguments that you can use in the SERIES formula include
h 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 series_name argument is used as the title. The
series_name argument can also consist of text, in quotation marks. If omitted, Excel
creates a default series name (for example, Series 1).
h 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
range’s 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 curly brackets.
h 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 range’s 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.
 
Search JabSto ::




Custom Search