6 Replies Latest reply: Apr 22, 2015 5:36 AM by Ian McGivern RSS

    Customised coloured area in line chart?

    David Brandstädter

      Hi all,

       

      I'm trying to colour the area underneath the line of a line-chart according to the following nested if-statement:

       

      IF(Sum([Diff x Amount])/Sum([Amount in Euro])<20,kRed,

        if(Sum([Diff x Amount])/Sum([Amount in Euro])<30, kYellow,

            if(Sum([Diff x Amount])/Sum([Amount in Euro])<40, kGreen,

            if(Sum([Diff x Amount])/Sum([Amount in Euro])<50, kYellow,

              kRed

         ))))

       

       

      However, despite selecting "Area" as presentation mode (Präsentation: Fläche in German), only the line is coloured and now area is visible.

       

       

      Thank you for your help!

       

      line.PNG