Creating a colored band in a chart

%3CLINGO-SUB%20id%3D%22lingo-sub-3002334%22%20slang%3D%22en-US%22%3ECreating%20a%20colored%20band%20in%20a%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3002334%22%20slang%3D%22en-US%22%3E%3CP%3EBack%20to%20my%20diabetes%20tracking%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20%22Fasting%22%20sheet%20of%20the%20attached%20spreadsheet%2C%20I've%20created%20a%20%22high%22%20and%20%22low%22%20normal%20area%20(the%20horizontal%20green%20bars).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20specify%20a%20color%20for%20the%20area%20between%20the%20green%20bars%3F%20I%20would%20want%20it%20to%20be%20adjustable.%20(The%20%22Chart%20Data%22%20sheet%20is%20the%20data%20being%20charted).%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3002334%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3003090%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20a%20colored%20band%20in%20a%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3003090%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1224787%22%20target%3D%22_blank%22%3E%40gplawhorn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20forgot%20to%20attach%20a%20sample%20workbook...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3003223%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20a%20colored%20band%20in%20a%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3003223%22%20slang%3D%22en-US%22%3EI%20sure%20did%3B%20I%20just%20attached%20it.%3C%2FLINGO-BODY%3E
Occasional Contributor

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). 

4 Replies

@gplawhorn 

You forgot to attach a sample workbook...

I sure did; I just attached it.

@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).

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