Microsoft Office Tutorials and References
In Depth Information
Charting a Noncontiguous Range
in reverse order on the series axis. Consequently, the order of the entries in the
legend remains the same.
Figure 3-13: Some of the data points are obscured.
Figure 3-14: After I’ve reversed the series axis,
the chart is more legible.
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 is not in a contiguous range. Figure 3-15 shows an
example of a noncontiguous series. This chart displays monthly data for the first
and fourth quarter. The data in this single series is contained in rows 2:4 and 11:13.
The SERIES formula for this series is
=SERIES(,(Sheet1!$A$2:$A$4,Sheet1!$A$11:$A$13),(Sheet1!$B$2:$B$4,Sheet1!$B$11:$B
$13),1)
Search JabSto ::




Custom Search