Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
my QVF
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.
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
Yes, modify the load script and then change the Colours and legend property to something like if([latest_year_flag] =1,lightgray(),green()).