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.
Search JabSto ::




Custom Search