6 Replies Latest reply: Aug 17, 2016 11:15 AM by Vishwarath Nagaraju RSS

    conditionally hide/show line on chart based on x-value

    Kristina Stephenson

      Hi All,

       

      I would like to only show the line on a combo chart for x-values -12 to -1, and subsequently from 1 to 12. I do not want a line from -1 to 1. How can I do this? The chart is technically not continuous because I have no 0 values, but I am setting the x-axis to continuous to show 0 on the chart. See below - no data point at 0, and do not want the line drawn from -1 to 1.

       

      I currently have the line style set: IF(month_num<-1,'<S2><W0>',IF(month_num>=1,'<S2><W0>'))

      Is there any style for no line?

      Thanks!!