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:
The above examples are from Excel 2013 but I need to deploy it in Excel 2010.
-- removed inline image ---
Can anybody suggest a magic trick to do this?

I've tried a few methods but all have problems:
- 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. - 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. - 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.
Last edited: