We need to do some calculations to produce data for the area chart series (see below).
The min and max X for the XY chart’s X axis are entered in B11 and B12 (these are Excel’s automatic scale limits in the XY chart above).
Here is the data and the initial chart for the two XY curves.
To provide reasonable resolution, we’ll scale the area chart’s X data from 0 to 1000.
The formulas for the area chart’s X values in column D are simple interpolation formulas to properly rescale the data.
Excel adds a secondary vertical axis along the right edge of the chart.
In Excel 2013, click the plus icon beside the chart, click on the right-facing arrow beside Axes, and check the Secondary Horizontal box.
It also took advantage of a trick using the category axis of an area (or line or column) chart: when used as a date axis, points that have the same date are plotted on the same vertical line, which allows adjacent colored areas to be separated by vertical as well as horizontal lines.
To fill under or between XY series, we’ll make use of this same approach: XY data on primary axes, Area data on secondary axes, with a secondary date axis.
Let’s start with the simple case of filling color below an XY plot.
Simple data, simple chart of type Scatter With Straight Lines and Markers.
You will not find this chapter on the Microsoft site. You should have reviewed the bookmarks and cross-reference portions of Complex Legal Documents before tackling this chapter.
Shading between plotted lines with a light color can enhance some charts.
The chart already contained the XY data in the first two columns of the data range (B4: C9).