5 Replies Latest reply: Jul 1, 2014 5:28 PM by Nilo Barreto Pontes RSS

    Plot NULL values as zero

    Dan Heller

      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.

       

      Chart zero values.png
      Are there any suggestions to get this working as I described above?

       

      Thanks,

      Dan