Forum Discussion
Creating a colored band in a chart
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 spe...
You forgot to attach a sample workbook...
I sure did; I just attached it.
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.