3 Replies Latest reply: Jun 30, 2017 4:33 PM by Apolo Takeshi Batista RSS

    Coloring Even and/or Odds in Bar Chart?

    Apolo Takeshi Batista

      Hi there, I have the following data:

       

       

      PRODUCT_CodeColors_CodeNumber of Itens in Stock
      58423565332763
      9484480013438
      9484480024511
      9484481618593
      9484480571555
      9484481615500
      1927200013326
      19272000011012
      19272061111072
      2276256480995
      2276250029999
      5425830024982
      5425836121396
      5425836119397
      6209730013394
      6209733610994
      6209732694212
      620973269395
      620973164861
      4170310024878
      4170311067494
      4170311604341
      4462640013373
      4462646480450
      4462646109120
      4462646122533
      8536490024721
      8536490014407
      8536494092319
      21457364731437
      9441260013505
      9441260024387
      9441260195435
      3476186819731
      3476186980531

       

       

      And I want to use them as BarChart

      But I get the data like this:

       

      As-Is_To_be.jpg

      the Problem is, I need to alter the color between data in any order I decide to sort my itens.

       

      Any Ideas??

       

      The modeling I'm using is:

      Dimensions:

      1st: Product

      2nd: Product_color

       

      Expression:

      Sum(Stock)

       

      Sort:

      Sum(Stock) DESC