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 ?
I would suggest you include a last year flag field in your load script so that this can be used in your colour expression.
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.
Yes, modify the load script and then change the Colours and legend property to something like if([latest_year_flag] =1,lightgray(),green()).
Retrieving data ...