Nov 24 2021 08:49 AM - edited Nov 24 2021 01:02 PM
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).
Nov 24 2021 12:19 PM
You forgot to attach a sample workbook...
Nov 24 2021 01:20 PM
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).
Nov 24 2021 06:00 PM