Assigned colour in multi dimension histogram chart

[Roberto03]

Hi, in the app I'm developing, I have a histogram chart with two dimensions (one dimension which is a column of a table and another which is a drill down of several columns of the same table). In the "colour source" section I have inserted the formula to assign colors to pillars. However the colors of the columns are different from the RGB set. 

The formula works well in pie chart bur not in that type of chart.

the formula is =pick(wildmatch([TABLE FIELD],'GPL', 'ELETTRICITÀ', 'Gasolio', 'Metano - Carbone','pellet+pula+legna','SOLARE TERMICO/ FOTOVOLTAICO','*'),
RGB(255,165,0), RGB(171,205,239), RGB(112,128,144), RGB(123,160,91), RGB(152,118,84), RGB(255,216,0), RGB(0,0,0))

thanks.

[GiuseppePanella_ · Accepted solution]

Hi, maybe this video can helps you