4 Replies Latest reply: Sep 6, 2013 9:35 AM by Supratim Ray RSS

    Conditional Font colour in Axes on Chart

      Hi Guys

       

      Building a Line chart , I want to add a conditional colour format, on the Y axis is a list of values -8000 to 5000, I wish for the values in minus range to be red , the others black.

       

      I went into Chart props>Axes> selected Expressions font and clicked conditional, I put the following in

       

      if([Losses Deff]<'1',RGB(255,0,0),RGB(0,0,0))

       

      But all that did was change all my Y axis font BLACK

       

      Can anyone please help ??

       

      Thanks