How to change the last year YTD bar to gray color now is red color ?

[paulyeo11]

Hi All

My chart have 2 Bar , one is YTD sales another is last year YTD sales.

Now the sales bar is yellow color and the last year YTD bar is red color .

May i know how to change the sales bar color to Green and last year sales bar to gray color ?

Paul

[paulyeo11]

my QVF

[rbartley]

Hi,

I would suggest you include a last year flag field in your load script so that this can be used in your colour expression.

[paulyeo11]

Hi Richard

Thank you very much for your sharing.

So do you mean it i must modify my load script in order to be able change my bar color ?

otherwise i may need to look into how to change the way i plot the chart with out using valuelist.

Paul

[rbartley]

Yes, modify the load script and then change the Colours and legend property to something like if([latest_year_flag] =1,lightgray(),green()).