6 Replies Latest reply: May 8, 2018 7:58 AM by Sofia Vaz RSS

    Coloring a Stacked bar chart

    Sofia Vaz

      Hi all,

       

      I have a ctacked bar chart where one of the dimensions is a calculates dimension with the following expression:

       

      =if(InventorySubType='OV',Dual('Short Shipped - OverPlanned',1),

      if(match(InventorySubType,'OM','AU') , dual('Short Shipped - OverMade',2),

          if(InventorySubType='OC', dual('Short Shipped - OverChange',3),

              if(InventorySubType='PL', dual('Short Shipped - Under-Planning',5),

          if(InventorySubType='PR',dual('Short Shipped - Under-Production',6),

                      if(InventorySubType='UD', dual('Short Shipped - Under-Dispatch',4),

                          if(InventorySubType='OP', dual('Short Shipped - Old Stocks & PFE',7),

                              if(InventorySubType='MS', dual('Short Shipped - Mill Stock',8),dual('Blank',9)))))))))

                                 

      I'm trying to personalize this chart with other colors. in other to do that, I've tried to replace the above expression by this one:

       

      =match(if(InventorySubType='OV',Dual('Short Shipped - OverPlanned',1),

      if(match(InventorySubType,'OM','AU') , dual('Short Shipped - OverMade',2),

          if(InventorySubType='OC', dual('Short Shipped - OverChange',3),

              if(InventorySubType='PL', dual('Short Shipped - Under-Planning',5),

          if(InventorySubType='PR',dual('Short Shipped - Under-Production',6),

                      if(InventorySubType='UD', dual('Short Shipped - Under-Dispatch',4),

                          if(InventorySubType='OP', dual('Short Shipped - Old Stocks & PFE',7),

                              if(InventorySubType='MS', dual('Short Shipped - Mill Stock',8),dual('Blank',9))))))))), rgb(208,120,87),rgb(221,157,131),rgb(236,201,187), rgb(166,133,83), rgb(196,173,138), rgb(219,205,185), rgb(63,63,63), rgb(139,139,139), rgb(201,201,201))                     

       

      but it isn't working... Do you have any idea what I might be doing wrong or what can I do to personalize these colors?

       

      Thank you!

       

      Sofia Vaz