Microsoft Office Tutorials and References
In Depth Information
Adding horizontal or vertical "bands"
Figure 8-4: The vertical bands are provided by a column series that uses the
secondary value axis.
The column chart series, which uses the data in columns D:E, is associated with
the secondary value axis and has a scale range from 0 to 1. Normally, you would
hide the secondary axis, but it’s shown here for clarity. Note that the data consists
of TRUE and FALSE values that determine whether the band is visible. In Excel,
TRUE has the value 1 and FALSE has the value 0. Therefore, these Boolean values
map perfectly to the chart’s scale.
The companion CD-ROM contains a practical example of this technique.
A line chart plots 100 data points, and the background vertical band displays
only if the data point is greater than the previous one (see Figure 8-5).
Figure 8-6 shows another example. In this case, the “band” series consists of 50
bars rather than columns. The result is a column chart that shows horizontal bars in
the background. The visibility of each of the 50 bars is controlled by changing
the Boolean values in a range of 50 cells. The axes for the bars are displayed in the
figure, but you would normally hide these axes.