Microsoft Office Tutorials and References
In Depth Information
Charting a Noncontiguous Range
Figure 6-11: After changing the plot order, the stacked columns correspond to the order of the data.
Charting a Noncontiguous Range
Most of the time, a chart series consists of a contiguous range of cells. But Excel does allow you to
plot data that isn’t in a contiguous range. Figure 6-12 shows an example of a noncontiguous series.
This chart displays monthly data for the first and fourth quarters. The data in this single series is
contained in rows 2:4 and 11:13. Notice that the category labels display Jan, Feb, Mar, Oct, Nov, and Dec.
Figure 6-12: This chart uses data in a noncontiguous range.
The SERIES formula for this series is as follows:
=SERIES(‘Figure 6-12’!$B$1,(‘Figure 6-12’!$A$2:$A$4,’Figure
6-12’!$A$11:$A$13),(‘Figure 6-12’!$B$2:$B$4,’Figure 6-12’!$B$11:$B$13),1)
Search JabSto ::

Custom Search