Microsoft Office Tutorials and References

In Depth Information

**Converting range reference to arrays**

Converting range reference to arrays

The other way to unlink a chart from its data is to convert the SERIES formula

range references to arrays. Figure 3-22 shows an example of a pie chart that does

not use data stored in a worksheet. Notice that the chart’s data appears in the

SERIES formula, which is

=SERIES(,{“Work”,”Sleep”,”Drive”,”Eat”,”Other”},{9,7,2,1,5},1)

The first argument, the series name, is omitted. The second argument consists of

an array of five text strings. Notice that each array element appears in quotation

marks and is separated by a comma. The array is enclosed in brackets. The chart’s

data is stored as another array (the third argument).

This chart was originally created by using data stored in a range. Then, the

SERIES formula was “de-linked” from the range and the original data was deleted.

The result is a chart that does not rely on data stored in a range.

Figure 3-22: This chart is not linked to a data range.

To convert the range references in a SERIES formula to arrays:

1. Create the chart as usual.

2. Click the chart series (the SERIES formula will appear in the formula bar).

3. Click the formula bar.