Microsoft Office Tutorials and References

In Depth Information

**Shading between two series in a line chart**

The formulas entered in Steps 1 and 2 display #NA if the corresponding

value in column B is not the maximum or minimum. In a line chart, an #NA

value causes a gap to appear in the line — which is exactly what is needed.

As a result, only one data point is plotted (or more, if there is a tie for the

maximum or minimum).

Shading between two series in a line chart

The example in this section describes how to apply shading to the region between

two lines in a line chart. Figure 8-29 shows a line chart with two series. The area

between the lines is shaded with a fill color.

Figure 8-29: This line chart has shading between the two line series.

This type of chart requires two additional series, formatted as area chart series.

One area chart series uses the data in column C. These values are the same as those

in column A. You can, in fact, simply create the area chart series from the data in

column A. The second area chart series uses the values in column D. These values

are generated with a formula that calculates the difference between the first line

and the second line data point. For example, the formula in D2 is

=B2-A2

After adding these two new area chart series, you need to hide the Area1 series.

Do this by accessing the Format Data Series dialog box. Select the Patterns tab, and

set the Border and Area to None.