Color range for horizontal linear gauge

[omegat29]

Dear all

 

I have some problem about color range of horizontal linear gauge.

 

I define 5 colors range and get range value via database, if range value sort by ascending color will shown as pic.1 (red, orange, yellow, lime, green).

and If range value sort by descending color will shown as pic.2 (green, lime, yellow, orange, red).

 

How to fix color range for horizontal linear gauge. (not related to database)

Thanks alot