5 Replies Latest reply: Feb 3, 2015 10:29 AM by jorge gardeazabal RSS

    Accumulation in line chart - Change line colour from a certain accumulated point onwards

      Dear all,


      I am having a problem with the design of a line chart.


      I have it done so that we see on the x-axis the clients ranked by the amount of sales, and on the y-axis we see the relative accumulated sales with respect to the total amount of sales.


      This is the look of my graph right now.

      However, I would like to have it done so that from the point in which line crosses 25 % onwards, its color changes from blue to red. Do you know how can I do this?


      I have tried with this formula in the colour option of the expression, but I do not get the results that I am looking for:




      Can anybody help me please?


      Thank you very much!!