How to set multiple colors in bar chart dimension text?

[woshua5550]

hi all

for example

"Beijing"  shown as red

"Shanghai" shown as black

thanks

[oknotsen]

Go to the Colors tab and near the top right corner select "Multicolored".

[Anonymous]

[Frank_Hartmann]

Try like this:

Add expression:

if(city='Beijing',red(),if(city='Shanghai',black(),'othercolour'))

[woshua5550]

thanks for your reply , but i don't think it works , i need to change the color of  label rather than the bar

[woshua5550]

hi

yes i supposed it will work but it not , i have tried but nothing happened, does it works for you ?

if so ,can you attech your test file ? thanks

[Frank_Hartmann]

Have a look at this post:

Dynamically Changing the colour of the dimension axis label

[sampada0810]

Go to colors tab in the chart properties and check the Multicolored checkbox

[beck_bakytbek]

Hi Lau,

try to make those steps:

1.tab: Expression >Select your Expression > BackgroundColor

2. type this this Expression: if(City='Beijing',Red())

i hope that helps

beck

[woshua5550]

Hi beck

maybe i didn't state clearly

i want to change the color of dimension axis lable

thanks