Microsoft Office Tutorials and References

In Depth Information

**Freezing a Chart**

Repeat these steps for each series in the chart.

Figure 148-1 shows a pie chart that has been unlinked from its data range. Notice that the

Formula bar displays arrays, not range references. The original data SERIES formula was

=SERIES(,Sheet3!$A$1:$A$6,Sheet3!$B$1:$B$6,1)

The converted SERIES formula is

=SERIES(,{“Work”,”Sleep”,”Drive”,”Eat”,”Play Banjo”,”Ot

her”},{8,7,2,1,3,3},1)

Excel places a limit on the length of a SERIES formula. Therefore, this method may not

work if the series consists of a large number of data points.

Figure 148-1:
This chart isn’t linked to a data range.