Microsoft Office Tutorials and References

In Depth Information

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

•
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 con-

sist 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 omit-

ted, 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 en-