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
The converted SERIES formula is
=SERIES(,{“Work”,”Sleep”,”Drive”,”Eat”,”Play Banjo”,”Ot
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