2 Replies Latest reply: Jul 31, 2015 9:56 AM by Colin Devon RSS

    Line Chart - display continuous line when zero value

      I have a chart with the following data.

       

      x = 1,2,3,4,5,6,7,8,9,10

      y = 2,3,2,3,0,0,4,5,3,4

       

      Does anyone know if it is possible to have a continuous line between points 4 and 7 in a similar fashion to Chart 1 Dim 1 = A in the attached doc, though I'd want a similar effect to Chart 3 i.e. dotted line when zero value to represent the anomoly?

      Line Style : =IF(SUM({<[Dim 1]={'A'}>}Val)>0, '<S1>', '<S3>')

       

       

      This is just a simplified example of what would be a standard time-series chart where certain months might be filtered out depending on user selections.