2 Replies Latest reply: Nov 6, 2015 9:27 AM by Paul Lazard RSS

    Orange Bar Chart

    Kieron Passfield

      Hello,

       

      I am trying to change the colour of my bar chart to orange, which isn't of the standard options.

       

      Is there a quick and easy way of doing this? Maybe by expressions?

       

      One method I came up with was pick(match( which works, however this is not feasible for where I have many months.

       

      Thanks

        • Re: Orange Bar Chart
          Stefan Wühl

          You can use a background color attribute expression (open the attributes by clicking on the small plus next to the expressions):

           

          =RGB( r, g, b)

           

          where r, g,b are numbers 0 to 255 defining the RGB color you want.

           

          For example

          =RGB(255,165,0)

          • Re: Orange Bar Chart
            Paul Lazard

            Hi Keiron

            I am a newbie to Qlikview, so there is probably a better way(!) but to get around the same problem, I added the RGB to the "Background Colour".

            In the expression, expand the variable (to show Background Colour, Text Colour, Pie Popout etc) and then I put the RGB in the definition (literally as RGB(xxx,xxx,x)

             

            As I say, this is probably not where I should be doing it, but it works!