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.