Microsoft Office Tutorials and References
In Depth Information
Adding horizontal or vertical "bands"
2. Select D2:D7 and choose Edit
3. Select the chart and choose Edit
Paste Special. In the Paste Special dialog
box, select New series and Values (Y) in Columns.
4. Click the original series (not the newly added series) and access the
Format Data Series dialog box. Select the Axis tab and choose the
Secondary axis option.
5. Click the newly added series and access the Format Data Series dialog
box. Click the Options tab and set the Gap width to 0. Click the Patterns
tab and set the Border to None. Change the Area to some light color such
as yellow. The columns will appear as a single background block.
6. Click the fifth bar in the series and change the fill color. Repeat these
actions for the sixth bar in the series.
7. Access the Format Axis dialog box for the left value axis (the axis
associated with the background series). Click the Scale tab and set the Maximum
scale value to 1200 (which is the maximum scale value for the right value
8. Access the Format Axis dialog box for the right value axis. Select the
Patterns tab and set all options to None (this hides the axis).
9. Add a title and descriptive labels to indicate the Pre-Merger and
PostMerger sections of the chart.
If you followed the previous steps, you’ve realized that the value axis on the
left is actually associated with the background column series. This is
necessary because a column series plotted on the secondary axis always appears
in front of a column series plotted on the primary axis.
This procedure can easily be adapted to other situations — for example, dividing
a chart into three vertical sections. Just change the colors of the appropriate
background bars. In most cases, you’ll want the background series to contain the same
number of data points as the actual data series.
Adding horizontal or vertical “bands”
The examples in this section demonstrate a variation on the previous concept.
Figure 8-4 shows a chart that displays vertical bands. Again, it’s a combination
chart — this time an XY series combined with a column chart series.