Application screenupdating in powerpoint 2016
These duplicate X values will provide the vertical edges of the shaded region.
The formulas for the area chart’s Y values in column E provide the same Y values for both chart series.
It takes up space, but I’ll leave the legend there until the end to help us keep track of which series is which.
The formulas to calculate the area chart X and Y values are like those used in the simpler example above.
Excel adds a secondary vertical axis along the right edge of the chart (below right).
Since it’s plotted on the secondary axis, the area series fills the space between the secondary horizontal axis at the top of the chart and the data points. We start with two XY scatter chart series, one above and one below the filled area.
The formulas for the area chart’s X values in column D are simple interpolation formulas to properly rescale the data.
The X values are extended so that the first calculated X value in D5 is repeated in D4, and a zero is placed in D3; also the last calculated X value in D9 is repeated in D10, and the X max of 1000 is entered into D11.
You actually could have switched the area series to the secondary axis in this dialog (as long as you do it before changing the chart type), but I usually forget that it’s become this simple.
In Excel 20, select Area or Stacked Area from the pop-up window.