Forum Discussion
Solved
Overlayed Glucose Chart range grows as I insert new rows.
This chart used to work correctly, but now it doesn't. Someone help me a couple of years ago, but now something happened and it is broken. I need the chart to do similarly as does the Carbs chart. It...
The Carbs chart uses named ranges, but the Glucose chart used fixed ranges. I have changed that.
But there appears to be confusion between several sheets referring to the first quarter.
Thank you. What is the confusion you mentioned.
The Q1Carbs and Q1CarbsDay ranges used for the Carbs chart on the Q 1 sheet refer to cells on the 1st Q sheet. You can inspect the definitions by clicking Name Manager on the Formulas tab of the ribbon.
- I am not sure how to resolve the references to "1st Q". Do I just delete them?
No, you should change them to references to Q 1
- Won't that cause some redundancy for Q1?