Chart: Fill Between Lines but Multiple Series

[Cool blue]

I'm trying to improve the chart below to render the white areas under the bands of colour as "no fill".


-- removed inline image ---


Can anybody suggest a magic trick to do this?

I've tried a few methods but all have problems:

1. Areas (as above)
   I organised the Areas into pairs and ordered them so that the lower ones cover the upper ones.
   I can use a foreground colour and a background colour for each pair and fiddle about with the transparency settings and get the above result, but I can't achieve the result I want which is bands of semi-transparent colour with the grid lines showing through and in the gaps.
2. Stacked Areas
   
   -- removed inline image ---
   
   Can render the bottom section with no fill, but can only have two bands, limited by primary and secondary axes groups.
   Can make a chart for each series and superimpose with no fill in plot area but that takes a lot of fiddling about.
   There is yet another asymmetry in Excel in that #N/A and gaps in stacked area series is rendered differently from area series and the gaps are not handled so nicely in the former.
3. Up-Down Bars
   Has a similar limitation as Stacked Areas in that it will only span the upper and lower lines in the axis group. I can't seem to pair them up.

The above examples are from Excel 2013 but I need to deploy it in Excel 2010.

 

[Cool blue]

This editor is a joke...

I'm trying to improve the chart below to render the white areas under the bands of colour as "no fill".

https://app.box.com/s/p39m7ocxas7zgntkblab

Can anybody suggest a magic trick to do this?

I've tried a few methods but all have problems:

1. Areas (as above)
   I organised the Areas into pairs and ordered them so that the lower ones cover the upper ones.
   I can use a foreground colour and a background colour for each pair and fiddle about with the transparency settings and get the above result, but I can't achieve the result I want which is bands of semi-transparent colour with the grid lines showing through and in the gaps.
2. Stacked Areas
   https://app.box.com/s/i8jqmjhh4vwrakoqd5dw
   Can render the bottom section with no fill, but can only have two bands, limited by primary and secondary axes groups.
   Can make a chart for each series and superimpose with no fill in plot area but that takes a lot of fiddling about.
   There is yet another asymmetry in Excel in that #N/A and gaps in stacked area series is rendered differently from area series and the gaps are not handled so nicely in the former.
3. Up-Down Bars
   Has a similar limitation as Stacked Areas in that it will only span the upper and lower lines in the axis group. I can't seem to pair them up.

The above examples are from Excel 2013 but I need to deploy it in Excel 2010.