On the attached workbook, the TO1Chart worksheet has a chart that calculates weekly data based on values selected from the dropdown lists in cells C24 and F24. It works beautifully as long as I do not select the last date value in the F24 cell, which in this case is 2/5/20. If I try to chart any range using this last 2/5/20 value, then the chart will cause all the named ranges referenced in the Weekly TO Chart to be replaced with static cell addresses. NOT good!
What can I do to prevent this from happening? Must there be something put in to prevent anyone from being able to use that last value?
I'm so darn close to having a program that we can use for our agency here. So frustrating!
NOTE: To the right of the chart are listed the named references and formulas that I have currently placed in the Select Data section of the chart. Hopefully, this will help to illuminate the problem better.
Also Note: the Daily chart seems to work just fine using the last value in the dropdown list in cell F2. Why?
Bookmarks