This is kind of a two-part question. You can see from the first image below that weeks 12, 14, and 16 are NULL values and have been skipped. In the second chart, I unchecked the value to "Supress Zero-Values". We are currently in week 22 and I would like to show the NULL values <= current week as zero. But, I would also like to hide/suppress the NULL values betond week 22. It seems that I can't have it both ways. I even tried to change the background color to white for these week values, but was unable to get it to work.
Are there any suggestions to get this working as I described above?
I've actually been playing around with the "Suppress Zero-Values" button on one of my own projects and it does seem to be doing some strange, incomprehensible things. This thread (Re: Suppress zero values in Tables/Charts) makes me think this functionality is slightly broken.