Microsoft Office Tutorials and References
In Depth Information
Converting range references into arrays
The converted SERIES formula is
=SERIES(,{“Work”,”Sleep”,”Commute”,”Eat”,
“Play Banjo”,”Other”},{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.
Note
Figure 93-2: This chart is no longer linked to a data range.
Search JabSto ::




Custom Search