Shading between 2 curve lines on chart

Hi,

On Excel charts we can shade between curves and axis; how can we shade the area between 2 data curves.

Make upper curve some area color, and bottom curve make white area

You can shade by using additional data series plotted as stacked area.
First additional series should match the lowest curve and be formatted as no border/fill.

Second additional series should be difference between curves.

If you need more help post workbook example with your current curve chart

Please have an example attached.

You can not do the shading easily as you are already using the secondary axis and the area between the curves is based on 2 separate scales.

You would need to re calculate the Z values so they used the same scaling as the X and Y series.

OK, let me remove the secondary axis, please have a look at the attachment now.
Is there any other way to fill between the 2 primary curves rather than the mentioned above, by VBA for instance.

Simplest approach is to change xyscatter to area.
You will need to add 2 additional series for the intersection and lower red line.

Thanks Andy!
Very supportive

If you really want VBA the see here for examples.
http://peltiertech.com/Excel/Charts/BackgroundFill.html