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




Custom Search