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
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.
Search JabSto ::

Custom Search