Creating a colored band in a chart

[gplawhorn]

Back to my diabetes tracking spreadsheet.

In the "Fasting" sheet of the attached spreadsheet, I've created a "high" and "low" normal area (the horizontal green bars). 

Is there any way to specify a color for the area between the green bars? I would want it to be adjustable. (The "Chart Data" sheet is the data being charted). 

[#2]

@gplawhorn 

You forgot to attach a sample workbook...

[#3]

I sure did; I just attached it.

[#4]

@gplawhorn 

I don't see green lines in the Fasting, Average sheet, but I do see orange lines in the High, Low, Carbs sheet.

I did the following:

I changed the value for Upper Limit on the Chart Data sheet to Upper Limit-Lower Limit. The reason will become clear in a moment.

I changed the chart type for the Upper Limit and Lower Limit to Stacked Area.

Lower Limit was plotted at the top, so I switched the order of Upper Limit and Lower Limit in the Select Date dialog.

I made the Lower Limit series transparent (No Line, No Fill), and removed the border from the Upper Limit series (No Line).

[#5]

Wow, thanks - that's exactly what I wanted to achieve. I'll unpack what you did and learn from it.